1Z0-051 무료 덤프문제 온라인 액세스

Evaluate the following SQL query;

What would be the outcome?

• A.100
• B.150
• C.160
• D.200
• E.16

The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(4)
LAST_NAME VARCHAR2 (25)
JOB_ID VARCHAR2(10)
You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?

• A.SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';
• B.SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
• C.SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_' ESCAPE '\';
• D.SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE "\";

Which is a valid CREATE TABLE statement?

• A.CREATE TABLE 1EMP_TEST AS (empid number(2));
• B.CREATE TABLE EMP9$# AS (empid number(2));
• C.CREATE TABLE EMP*123 AS (empid number(2));
• D.CREATE TABLE PACKAGE AS (packid number(2));

The CUSTOMERS table has the following structure: Exhibit:

You need to write a query that does the following task:
*Display the first name and tax amount of the customers. Tax is 5% of their credit limit
*Only those customers whose income level has a value should be considered
*Customers whose tax amount is null should not be considered
Which statement accomplishes all the required tasks?

• A.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND tax_amount IS NOT NULL;
• B.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;
• C.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level <> NULL AND tax_amount <> NULL;
• D.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE (cust_income_level,tax_amount) IS NOT NULL;

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:

You want to create a report displaying employee last names, department names, and
locations. Which query should you use to create an equi-join?

• A.SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE e.department_id =d.department_id;
• B.SELECT last_name, department_name, location_id FROM employees , departments ;
• C.SELECT employees.last_name, departments.department_name,
  departments.location_id FROM employees e, departments D WHERE e.department_id =d.department_id;
• D.SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id =manager_id;