Exam 1z0-052 topic 3 question 31 discussion

Actual exam question from Oracle's 1z0-052

Question #: 31
Topic #: 3

A database user SMITH tries to query the V$SESSION view and fails to access it as follows:

Which are the two possible solutions to enable SMITH to query the data in V$SESSION? (Choose two.)

A. granting SELECT privilege to SMITH on V$SESSION
B. granting SELECT privilege to SMITH on V_$SESSION
C. asking the user SMITH to run the catalog.sql script
D. granting SELECT privilege to SMITH on V$FIXED_TABLES
E. setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
F. creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

Show Suggested Answer

Suggested Answer: BF 🗳️
Incorrect:
Not A:
v$session is a synonym of v$_session.
Oracle v$ views are named V_$VIEWNAME and they have synonyms in format V$VIEWNAME and you cant give privilage on a synonym.
Note:
*
ORA-00942: table or view does not exist
Cause: The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.
Action: Check each of the following:
the spelling of the table or view name.
that a view is not specified where a table is required.
that an existing table or view name exists.
Contact the database administrator if the table needs to be created or if user or application privileges are required to access the table.
Also, if attempting to access a table or view in another schema, make certain the correct schema is referenced and that access to the object is granted.

by [deleted] at April 4, 2025, 7:28 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!