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
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).
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."
You want to check the details of few errors that users have reported. You search for the alert log fileand execute few commands to find the location of the alert log file. View the Exhibit and check the commands executed.
What is the location of the alert_orcl.log file()
A.ORACLE_HOME/dbs
B.ORACLE_HOME/rdbms
C./u01/app/oracle/admin/orcl/adump
D./u01/app/oracle/flash_recovery_area
E.ORACLE_BASE/diag/rdbms/orcl/orcl/alert
F.ORACLE_BASE/diag/rdbms/orcl/orcl/trace
You executed the following commands to find the location of the alert log file:
Where is the alert log file stored()
A.in the BACKGROUND_DUMP_DEST location; in text format
B.in the BACKGROUND_DUMP_DEST location; in XML format
C.in the BACKGROUND_DUMP_DEST location; in both text and XML format
D.in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in text format
E.in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in XML format
F.in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in both text and XML format
You used the IMMEDIATE option to shut down your database instance. Consider the steps that
mayoccur when a database instance is started and database is opened:
1:SGA is allocated.
2:Control file is read.
3:Redo log files are opened.
4:Instance recovery is started.
5:Background processes are started.
6:Data file headers are checked for consistency.
7:Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur()
A.7,1,5,2,3,6,4
B.1,5,7,2,3,6;step 4 is not required
C.7,1,5,2,3,6;step 4 is not required
D.1,2,3,5,6,4;step 7 is not required
View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instanceis already running. You used the following steps to start the database instance and open the database:
Which file is used to start the instance in this case()
A.init.ora
B.spfile.ora
C.initorcl.ora
D.spfile+ASM.ora
After performing a clean shut down of the database instance for maintenance, you mount thedatabase and then execute a command to open the database: SQL> ALTER DATABASE OPEN;
Which two statements are true()
A.The online redo log files and online data files are opened.
B.All the online data file headers are checked for consistency.
C.Instance recovery is performed before opening the database.
D.The path and existence of all the log file members are checked
A.renaming the control files
B.re-creating the control files
C.dropping a user in your database
D.dropping a tablespace in your database
E.configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
View the Exhibit and examine the output of the query.
What do you infer from this()
A.The SGA_TARGET is a static parameter.
B.The instance is started, but the database is not yet open.
C.The server parameter file (SPFILE) was used to start the instance.
D.The SGA_TARGET parameter does not have any effect onthe databaseinstance untiltheSGA_MAX_SIZE parameter is specified.
最新试题
Which statements regarding the server parameter file (SPFILE) are true()
View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT hasstarted a query on a large table in the peak transactional hour that performs bulk inserts. The query runs formore than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too oldWhat could be the reason for this error()
In a new installation of Oracle Database 11g, you perform these activities:1. Organize software and data on different subdirectories to avoid poor performance.2. Use consistent naming conventions for database files.3. Separate administrative information pertaining to the database in different directories. Which optioncorresponds to the type of activities you performed()
Which statement is true about loading data using the conventional path of SQL*Loader()
View the Exhibit. You are creating an additional database by using the Database Configuration Assistant(DBCA). You opted to create a General Purpose database and during the database creation realize that theBlock Size field is not enabled. What could be the reason for this()
You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this()
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, orany data definition language (DDL) command:SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session()
Why does performance degrade when many UPDATE, INSERT, or DELETE statements are issued on a tablethat has an associated Bitmap index()
View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command:SQL> GRANT SELECT ON scott.emp TO hr;Which statement describes the outcome of the command()
You are working on a database that must be functioning 24 hours a day, 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()