Free Oracle 1z0-061 Exam Dumps Questions & Answers

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 SYNONYM EDL_VU. FOR EACH USER. ON emp_dept_loc_vu;
• B.CREATE PUBLIC SYNONYM EDL_VU. ON emp_dept_loc_vu;
• C.CREATE PUBLIC SYNONYM EDL_VU. ON emp_dept_loc_vu. FOR ALL USERS;
• D.CREATE SYNONYM EDL_VU. ON emp_dept_loc_vu. FOR EACH USER;
• E.CREATE PUBLIC SYNONYM EDL:VU. FOR mary (emp_dept_loc_vu);
• F.CREATE PUBLIC SYNONYM EDL_VU. FOR emp_dept_loc_vu;

The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4, 3)
The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest.
Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?

• A.SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;
• B.SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;
• C.SELECT student_id, gpa FROM student_grades ORDER BY gpa;
• D.SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
• E.SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;
• F.SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;

You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:
Exhibit:

PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table.
What is the outcome?

• A.Number of days since the promo started based on the current Singapore data and time.
• B.Number of days since the promo started based on the current Chicago data and time
• C.An error because the ROUND function specified is invalid
• D.An error because the WHERE condition specified is invalid

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:

Which DELETE statement is valid?

• A.DELETE FROM employeesWHERE employee_id IN (SELECT employee_id . FROM new_employees . WHERE name = 'Carrey');
• B.DELETE * FROM employeesWHERE employee_id=(SELECT employee_id FROM
  new_employees);
• C.DELETE * FROM employeesWHERE employee_id IN (SELECT employee_id . FROM new_employees . WHERE name = 'Carrey');
• D.DELETE FROM employeesWHERE employee_id = (SELECT employee_id FROM
  employees);

View the Exhibit and examine the data in the products table.

You need to display product names from the products table that belong to the
'software/other' category with minimum prices as either S2000 or S4000 and no unit of measure.
You issue the following query:

Which statement is true regarding the above query?

• A.It executes successfully and returns the required result.
• B.It executes successfully but returns no result.
• C.It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.
• D.It generates an error because the condition specified for the prod category column is not valid.