Valid 1Z0-052 Dumps shared by ExamDiscuss.com for Helping Passing 1Z0-052 Exam! ExamDiscuss.com now offer the newest 1Z0-052 exam dumps, the ExamDiscuss.com 1Z0-052 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1Z0-052 dumps with Test Engine here:
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.)
Correct Answer: B,F
Explanation/Reference: Explanation: 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 can't 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.