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
单选题 You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of yourdatabase to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1.Shut down the instance. 2.Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3.Execute the ALTER DATABASE FLASHBACK OFF command. 4.Start up the instance and mount the database. 5.Execute the ALTER DATABASE FLASHBACK ON command. 6.Open the database. Select the correct order in which these tasks need to be performed.（）
It can be increased up to the value of the SGA_MAX_SIZE parameter.
Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.
Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.
Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.
单选题 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
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
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.
单选题 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（）
单选题 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.
单选题 Which statement is true regarding the effect of this command on the transaction in Scott’s session（）
The command fails as a transaction is still pending.
The transaction in Scott’s session is rolled back and the tablespace becomes read-only.
The command waits and the user SCOTT can execute data manipulation language （DML） statements only as part of the current transaction.
The command hangsuntil all transactions on the objects in the tablespace commit or rollback， and then the tablespace is placed in read-only mode.