单选题 You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）
Mount the database
Open the database in NORMAL mode
Open the database in RESTRICTED mode
Open the database with the RESETLOGS option
多选题 To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?（）
Multiple change tracking files can be created for a database.
The change tracking file must be created after the first level 0 backup.
RMAN does not support backup and recovery of the change tracking file.
The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
多选题 Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)？（）
You can use RMAN stored scripts
Recovery is faster if data is stored in catalog in addition to the control file
You can store backup information of all registered databases in one place
Database backups are automatically deleted when they are older than the specified time period
Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.
Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
Unix cp command of a file
Bit-by-bit copy of a file
Windows COPY command of a file
All of the above
多选题 The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?（）
All the related indexes and views are automatically dropped
The flashback drop feature can recover only the table structure
Only the related indexes are dropped whereas views are invalidated
The flashback drop feature can recover both the table structure and its data
单选题 You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?（）
A different procedure is required to restore a database from compressed backups
The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
Using this command to create backups minimizes the bandwidth consumed.
Using this command to create backups improves the performance of the backup process
多选题 You have enabled backup optimization for the RMAN environment.Identify two criteria on which RMAN will skip the file, if it has already been backed up.（）
The data file backup is done with multiple channels
The data files is in the read-write mode after being backed up in the read only mode
The backup was taken after the data files was taken offline-normal or is in the read only mode
The data file backup complies with the back retention policy and the backup duplexing feature
单选题 You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?（）
Set metric threshold
Implement Database Resource Manager
Enable resumable timeout for user sessions
Add directives to Automatic Database Diagnostic Monitor (ADDM)