Using SQL commands.
Using SQL*Plus commands.
Using operating system commands.
Using Recover Manager commands.
第1题:
The IBM System Storage TS7650 ProtecTIER Appliance and Gateway solution is designed toaddress which customer requirement?()
第2题:
Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()
第3题:
Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()
A. Redo logs
B. Control file
C. The latest backup of only the damaged data file
D. The latest backup of all the data file in the USERS tablespace
E. Temporary files of temporary tablespace
F. Archive Logs since the latest backup to point of failure
第4题:
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?()
第5题:
The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file?()
第6题:
You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup?()
第7题:
In which scenario will you perform a cancel-based recovery?()
第8题:
A. System image
B. Incremental backup
C. System state restore
D. Differential backup
第9题:
For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files?()
第10题:
when a tablespace is dropped and you have only RMAN-based backup of the database
when a table is dropped and stored in the Recycle Bin
when you are required to recover an existing table to its previous state
when a tablespace is dropped and you have only a user-managed full backup of the database