All AWR tables belong to the SYSTEM schema.
The AWR contains systemwide tracing and logging information.
The snapshots collected by the AWR are accessible through data dictionary views.
The snapshots collected by the AWR are used by self-tuning components in the database.
单选题 Observe the information in the columns： 1. The SGA a. Text and parsed forms of all SQL statements 2. The cursor state b. Run-time memory values for the SQL statement， such as rows retrieved 3. User-session data c. Security and resource usage information 4. The stack space d. Local variables for the process Which option has the correct match between the memory areas and their contents（）
1-c， 2-b， 3-d， 4-a
1-b， 2-c， 3-d， 4-a
1-a， 2-b， 3-c， 4-d
1-a， 2-b， 3-d， 4-c
when the data file of the undo tablespace is autoextensible
when there are more than one undo tablespaces available in the database
when the undo tablespace is of a fixed size and retention guarantee is not enabled
when the undo tablespace is autoextensible and retention guarantee is not enabled
单选题 Observe the information in the columns： 1： The SGA a. Text and parsed forms of all SQL statements 2： The cursor state b. Run-time memory values for the SQL statement， such as rows retrieved 3： User-session data c. Security and resource usage information 4：The stack space d. Local variables for the process Which option has the correct match between the memory areas and their contents（）
单选题 View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is trueabout the output of the command（）
The backup piece is expired as the new backup is available.
The backup piece is expired because the operating-system file was not found.
The backup piece is expired because the retention period for the backup has expired.
The backup piece is expired because the backup set to which it belongs is not complete
单选题 Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled（）
It is the time period after which the undo data becomes obsolete.
It is the time period after which the committed undo data would be transferred to a temporary tablespace.
It is the minimum time period up to which the committed undo data would be retained if free undo space isavailable.
It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
单选题 You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database. While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）
Use the external table population.
Use the Oracle Data Pump export and import utility.
Use the conventional path data load of the SQL*Loader utility.
Use the INSERT INTO...SELECT command to load the data.
单选题 You want to create a tablespace to contain objects with block size 16 KB. But while configuring thestorage you find that the block size that you can provide is only 8 KB. Which configuration could have enabled the block selection of 16 KB（）
choosing the extent allocation type to uniform
choosing the Segment Space Management option to manual
setting autoextension on for the data file mentioned for the tablespace
setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
The alert log file is corrupted.
A tablespace is accidentally dropped.
One of the redo log members is corrupted.
A database user terminates the session abnormally.
The hard disk on which the data file is stored is corrupted.
多选题 The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table： ERROR at line 1： ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock. two statements are true regarding the session of SCOTT in this scenario（）
The session is terminated after receiving the error and JIM can continue with his transaction.
SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
The session is rolled back after receiving the error and JIM can continue with his transaction.
SCOTT has to reexecute the last command in the transaction after he commits the transaction.