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.
A.An SPFILE is a binary file.
B.An SPFILE cannot reside on a client.
C.An SPFILE cannot contain static parameters.
D.An SPFILE can store changes persistently across instance restarts.
E.An SPFILE can be read by the database server, but it is not written to by the server.
F.An SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database.
最新试题
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN;Which two statements are true()
Which statements are true about checkpointing()
The user HR receives the following error while inserting data into the TTK table:ERROR at line 1:ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation, you find that SMDis a small file tablespace.Which three action would allow the user to insert data()
You set the following parameters in the parameter file and restarted the database:MEMORY_MAX_TARGET=0MEMORY_TARGET=500MPGA_AGGREGATE_TARGET=90MSGA_TARGET=270MWhich two statements are true about these parameters after the database instance is restarted()
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace.Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()
Which statements regarding the server parameter file (SPFILE) are true()
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task()
You configured the Flash Recovery Area (FRA) for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy()
Which statements are correct about temporary tables()
All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions:SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’; 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’;3 rows deleted.The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands()