A. Mount the database
B. Open the database in NORMAL mode
C. Open the database in RESTRICTED mode
D. Open the database with the RESETLOGS option
您可能感兴趣的试卷
你可能感兴趣的试题
A. Check the alert log file
B. Query the V$FLASHBACK_DATABASE_LOG view
C. Query the V$RECOVERY_FILE_DEST_SIZE view
D.Query the V$FLASHBACK_DATABASE_STAT view
E. Check the value assigned for the UNDO_RETENTION parameter
A. You must configure block change tracking file
B. You must have first level 1 backups for RMAN to restore blocks
C. You must ensure that the SALES database is mounted or open
D. You must have full or level 0 backups for RMAN to restore blocks
E. You must take the tools01.dbf data file offline before you start a block media recovery
Examine the following command that is used to duplicate a database on the same host:
Which two statements describe the effect after the database is duplicated successfully? （）
A. The data files of the read-only tablespaces in the target database are not duplicated
B. The read-only tablespaces in the target database are still defined in new the database
C. The read-only tablespaces in the target database are changed to online after duplication
D. The data files of the read-only tablespaces in the target database get duplicated
E. The read-only tablespaces in the target database are not defined in the new database
View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:
SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );
What could be the reason?（）
A. The pending area is automatically submitted after the plan creation
B. The procedure must be executed before creating the resources plan directive
C. The SYS_GROUP resource consumer group is not included in the resource plan directive
D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
You plan to execute the following command to perform a Flashback Database operation in your database:
SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);
Which two statements are true about this?（）
A. The database must have multiplexed redo log files
B. The database must be in the MOUNT state to execute the command
C. The database must be in the NOMOUNT state to execute the command
D. The database must be opened in RESTRICTED mode before this operation
E. The database must be opened with the RESETLOGS option after the flashback operation
A. Flashback queries
B. Shared server requests
C. Login and logoff activities of sessions
D. Direct path load of data from external files by using utilities such as SQL *loader
E. Data definition language (DDL) and data manipulation language (DML) operations
A. All the related indexes and views are automatically dropped
B. The flashback drop feature can recover only the table structure
C. Only the related indexes are dropped whereas views are invalidated
D. The flashback drop feature can recover both the table structure and its data
Examine the following command:
SQL> ALTER TABLE booking SHRINK SPACE COMPACT;
Which activity is performed when the preceding command is executed?（）
A. The shrink operation touches every block in the BOOKING table
B. The high-water mark (HWM) for the BOOKING table is shifted from its original position
C. The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
D. The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
Multiple RMAN sessions are connected to the database instance.
Examine the following output when backup commands are running in server sessions:
What could have helped you to correlate server sessions with channels?（）
A. Implement RMAN multiplexing
B. Set the DEBUG ON in the RMAN script
C. Specify the command ID in the RMAN script
D. Use a tag with the RMAN BACKUP command
最新试题
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?（）
Which two commands never trigger an implicit rebalancing within the disk group?（）
You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File System option as the storage mechanism. What would be the result of choosing this option?（）
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.Which method must you use to recover the lost data?（）
Which three functions are performed by the SQL Tuning Advisor? （）
Examine the parameter setting in your database:Which statement is correct about the database?（）
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)？（）
Which three tasks can be performed using a duplicate database?（）
View the exhibit and examine the TRANS table's storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（）