1Z1-051 試験問題を無料オンラインアクセス

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

View the Exhibit and examine the structure and data in the INVOICE table.
Which two SQL statements would execute successfully? (Choose two.)

• A.SELECT AVG(inv_date ) FROM invoice;
• B.SELECT MAX(AVG(SYSDATE - inv_date)) FROM invoice;
• C.SELECT MAX(inv_date),MIN(cust_id) FROM invoice;
• D.SELECT AVG( inv_date - SYSDATE), AVG(inv_amt) FROM invoice;

The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
Which statement finds the highest grade point average (GPA) per semester?

• A.SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;
• B.SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;
• C.SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;
• D.SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;
• E.SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;

Which constraint can be defined only at the column level?

• A.UNIQUE
• B.FOREIGN KEY
• C.PRIMARY KEY
• D.CHECK
• E.NOT NULL

Which object privileges can be granted on a view?

• A.none
• B.DELETE, INSERT, SELECT, UPDATE
• C.DELETE, INSERT,SELECT
• D.ALTER, DELETE, INSERT, SELECT