nerdexam
Oracle

1Z0-007 · Question #160

1Z0-007 Question #160: Real Exam Question with Answer & Explanation

The correct answer is B. Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command:. Correct syntax to create a local synonym is CREATE SYNONYM synonym_name. With PUBLIC keyword you can create public synonym. Incorrect Answers A: There is no PRIVATE keyword for the CREATE SYNONYM command. C: There is no LOCAL keyword for the CREATE SYNONYM command. D: This SQL st

Question

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced?

Options

  • AScott can create a synonym for the EMP_DEPT_LOC_VU bus using the command:
  • BScott can create a synonym for the EMP_DEPT_LOC_VU by using the command:
  • CScott can create a synonym for the EMP_DEPT_LOC_VU by using the command:
  • DScott can create a synonym for the EMP_DEPT_LOC_VU by using the command:
  • EScott cannot create a synonym because synonyms can be created only for tables.
  • FScott cannot create any synonym for Mary's view. Mary should create a private synonym for the view

Explanation

Correct syntax to create a local synonym is CREATE SYNONYM synonym_name. With PUBLIC keyword you can create public synonym. Incorrect Answers A: There is no PRIVATE keyword for the CREATE SYNONYM command. C: There is no LOCAL keyword for the CREATE SYNONYM command. D: This SQL statement shows incorrect syntax to create a synonym. E: Synonyms can be created not only for tables but for other objects also. F: Scott can create synonym for Mary's view because she granted SELECT privilege to Scott on

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-007 Practice