多项选择题
A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL> connect smith/smith
Connected.
SQL> SELECT * FROM v$session；
SELECT * FROM v$session *
ERROR at line 1：
ORA-00942： table or view does not exist
Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）
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
相关考题
-
单项选择题
Note the points about data dictionary views and dynamic performance views： 1.These are stored in the SYSTEM tablespace. 2.These are the based on the virtual tables. 3.These are owned by the SYSuser. 4.These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set toTRUE. 5.V$FIXED_TABLE view can be queried to list the names of these views. Which statements listed describe the data dictionary views（）
A.1 and 3
B.2，3，and 5
C.1，2，and 3
D.2，3，4，and 5 -
多项选择题
Identifythetwosituationsinwhichthealertlogfileisupdatedwithdetails.（）
A.Running a query on a table returns "ORA-600： Internal Error."
B.Inserting a value in a table returns "ORA-01722： invalid number."
C.Creating a table returns "ORA-00955： name is already used by an existing object."
D.Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."
E.Rebuilding an index using ALTER INDEX ...REBUILD fails with an error "ORA-01578： ORACLE data block corrupted （file # 14， block # 50）. -
多项选择题
Identifythetwosituationsinwhichyouusethealertlogfileinyourdatabasetocheckthedetails.（）
A.Running a query on a table returns "ORA-600： Internal Error."
B.Inserting a value in a table returns "ORA-01722： invalid number."
C.Creating a table returns "ORA-00955： name is already used by an existing object."
D.Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."
E.Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource."
