Examine the following scenario:
-Database is running in ARCHIVELOG mode.
-Complete consistent backup is taken every Sunday.
-On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted
-The disk having active online redo log files is also corrupted.
-The hardware is repaired and the paths for online redo log files and control files are still valid.
Which option would you use to perform the recovery of database till the point of failure?()
A. Restore the latest whole backup, perform complete recovery, and open the database normally
B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option
C. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option
D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
您可能感兴趣的试卷
你可能感兴趣的试题
A. The database must be in ARCHIVELOG mode
B. The database must be in MOUNT EXCLUSIVE mode
C. The database must be opened in RESTRICTED mode
D. The database instance must be started in the NOMOUNT state
E. The database instance must have the keep buffer pool defined
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
最新试题
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.Identify the two events that can occur in the event of a log switch?()
Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()
The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command?()
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?()
Which three statements are true about windows?()
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()
Examine the following ALTER command:SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command?()
The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?()
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()
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?()