Issue ALTER DATABASE BACKUP CONTROLFILE TO filename
Make a copy of the control file with the database shut down
Issue ALTER DATABASE BACKUP CONTROLFILE TO trace
Make a copy of the control file with the database still running
第1题:
You issue this statement:ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What does the statement generate?()
第2题:
You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup, you need the database ID (DBID). In which two sources would you find the DBID? ()
第3题:
The most commonly used locking level in implementing concurrency control is at which of the following levels?
A.database
B.table
C.record
D.field
第4题:
Which files are required for a full recovery of the database in ARCHIVELOG mode?()
第5题:
You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup,you need the database ID (DBID). In which two sources would you find the DBID? ()
第6题:
Which of the following is a differentiating feature of file permissions as compared to share permissions?()
第7题:
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused, and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter?()
第8题:
Which interface is used to configure debug parameters for log files?()
第9题:
Which six files are maintained in the Flash Recovery Area?()
第10题:
In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?()