Restore all the data files from last Sunday’s backup, and then perform a time-based recovery.
Restore all the data files from last Sunday’s backup, and then perform a cancel-based recovery.
Restore all the data files from last Sunday’s backup, and then perform a change-based recovery.
Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup, and then perform a complete recovery.
第1题:
You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)()
第2题:
In which two cases would you perform only consistent backup?()
第3题:
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8:00 P.M. Your database is running in ARCHIVELOG mode. On Monday, at 9:00 A.M., a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command?()
第4题:
You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03:00 p.m. What would you do to recover the table?()
第5题:
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
If you restart the database,the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
If you restart the database,the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
If you restart the database,the database will not be opened.
第6题:
open the database with the RESETLOGS option
open the database with the RESTRICTED option
recover all the data files to the same system change number (SCN)
recover to the required SCN only that data file in which the error occurred
第7题:
SPFILE
archive log
control file
system tablespace
第8题:
open the database with the RESTRICTED option
open the database with the RESETLOGS option
recover to the required SCN only that data file in which the error occurred
recover all the data files to the same system change number (SCN)
第9题:
Execute the ALTER DATABASE ARCHIVELOG statement
Select ARCHIVELOG option in the database control and restart the database to apply the changes.
Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.
第10题:
alter database archivelog
alter system enable archivelog mode
alter database enable archive
alter database archivelog enable
None of the above
第11题:
The alter database archivelog command will fail
The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode
The alter database archivelog command will succeed
The alter database archivelog command will ask if you want to make the database consistent first
There is no alter database archivelog command. The correct command is alter database alterlogging
第12题:
You are working on a database that must be functioning 24 hours a day, 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()
第13题:
You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario()
第14题:
Which is the correct command to put the database in ARCHIVELOG mode?()
第15题:
The database must be opened in restricted mode.
The database must be configured to run in ARCHIVELOG mode.
The tablespaces are required to be in backup mode before taking the backup.
The tablespaces are required to be in read-only mode before taking the backup
第16题:
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
If you restart the database, the database will not be opened.
第17题:
You have to shut down the database to perform the backups.
Archiving information is written to the data files and redo log files.
You can perform complete database backups without closing the database.
Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
第18题:
by using the Flashback Table feature
by using the Flashback Database feature
by performing incomplete recovery using RMAN utility
by performing incomplete recovery using user-managed recovery
第19题:
Open the database in read-only mode.
Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
Enable the block change tracking feature.
Execute the ALTER DATABASE FLASHBACK ON statement.
第20题:
The database is in NOMOUNT state.
The database is in ARCHIVELOG mode and the tablespace is online.
The database is in ARCHIVELOG mode and the tablespace is offline.
The database is in NOARCHIVELOG mode and the tablespace is online.
The database is in NOARCHIVELOG mode and the tablespace is offline.
第21题:
The database is in mount state.
One of the tablespaces is offline.
One of the tablespaces is read only.
The database operates in ARCHIEVELOG mode.
The database operates in NOARCHIEVELOG mode.
第22题:
You are working on a database where downtime is not tolerated.
You are working on a database where downtime can be tolerated.
You are working on a database that operates in ARCHIVELOG mode.
You are working on a database that operates in NOARCHIVELOG mode.
You are working on a database where all the tablespaces are locally managed.
You are working on a database where control files and redo log files are multiplexed.
You are working on a database where control files and redo log files are not multiplexed.