Free Oracle 1Z0-007 Exam Dumps Questions & Answers

You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns:

Which SELECT statement accomplishes this task?

• A.SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
• B.SELECT name, address FROM customers;
• C.SELECT cust_name, cust_address FROM customers;
• D.SELECT id, name, address, phone FROM customers;
• E.SELECT* FROM customers;

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database.
Which SQL statement can Mary use to accomplish that task?

• A.CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;
• B.CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);
• C.CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu;
• D.CREATE PUBLIC SYNONYM EDL_VU FOR emp_dept_loc_vu;
• E.CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;
• F.CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu;

Evaluate the SQL statement:
SELECT ROUND(45.953, -1), TRUNC(45.936, 2)
FROM dual;
Which values are displayed?

• A.46 and 45
• B.45.95 and 45.93
• C.45 and 45.93
• D.50 and 45.93
• E.46 and 45.93
• F.50 and 45.9

Which three statements correctly describe the functions and use of constraints? (Choose three.)

• A.Constraints provide data independence.
• B.Constraints enforce rules at the view level.
• C.Constraints prevent the deletion of a table if there are dependencies.
• D.Constraints prevent the deletion of an index if there are dependencies.
• E.Constraints make complex queries easy.
• F.Constraints enforce rules at the table level.

The EMPLOYEE tables have these columns:

You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column.
Which SQL statement displays the desired results?

• A.SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;
• B.SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;
• C.SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;
• D.SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;