A text copy of the control file.
A binary copy of the control file.
A file containing a SQL statement which will re-create the database.
A file containing a SQL statement which will re-create the control file.
第1题:
You executed the following command to back up the control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What do you find in the trace file?()
第2题:
You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()
第3题:
What methods are available to recover lost control files?()
第4题:
You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()
第5题:
In which situation will you run the script containing the following statement?() CREATE CONTROLFILE REUSE DATABASE SALES NORESETLOGS ARCHIVELOG MAXLOGFILES 20 MAXLOGMEMBERS 3 MAXDATAFILES 30 MAXINSTANCES 10 MAXLOGHISTORY 1200 LOGFILE GROUP 1 ( ’/disk1/prod/orders/db/log1a.dbf’, ’/disk2/prod/orders/db/log1b.dbf’ )SIZE 100K GROUP 2 ( ’/disk1/prod/orders/db/log2a.dbf’, ’/disk2/prod/orders/db/log2b.dbf’ ) SIZE 100K, DATAFILE ’/disk1/prod/orders/db/database1.dbf’, ’/disk2/prod/orders/db/file1.dbf ’;
第6题:
ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?()
第7题:
You issued the following statement: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What will be the result of issuing the statement?()
第8题:
You issue this statement:ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What does the statement generate?()
第9题:
You executed the following command to back up your control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Which initialization parameter is used to specify the location of the trace file?()
第10题:
In which of the following scenarios is a tablespace recovery required?()