Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
A. when you change the name of a datafile
B. when you drop a table from the database
C. when you take an export of the database
D. when you back up the database using OS utilities
E. when you issue an ALTER SYSTEM SWITCH LOGFILE statement
F. when you issue a BACKUP command from inside the RMAN run block
查看答案
相关试题
换一换
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）
A. Restore and recover the datafile. B. Restore and recover the tablespace. C. Restore and recover the database. D. Restore and recover the control file. E. Restore and recover the parameter file.
答案
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）
A.Restore and recover the datafile. B.Restore and recover the tablespace. C.Restore and recover the database. D.Restore and recover the control file. E.Restore and recover the parameter file.
答案
Which are the prerequisites for performing flashback transactions on your database？（）
A. Undo retention guarantee for the database must be configured. B. Supplemental log must be enabled for the primary key. C. Supplemental log must be enabled. D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.
答案
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）
A.renaming the control files B.dropping a user in your database C.enabling or disabling redo log archiving D.dropping a tablespace in your database E.re-creating the control files， after you lost all the control files in your database
答案
If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）
A. Complete database recovery. B. Incomplete database recovery. C. Approximate database recovery. D. Archived database recovery. E. The database could not be recovered with RMAN.
答案
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）
A. This operation resets the SCN for the database. B. This operation creates a new incarnation of the database. C. This operation moves all the redo log files to a different location. D. This operation deletes the old redo log files and creates new redo log files. E. This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
答案
You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）
A.xecute the ALTER DATABASE ARCHIVELOG statement B.Select ARCHIVELOG option in the database control and restart the database to apply the changes. C.Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement. D.Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.
答案
Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）
A.You can perform online whole database backups. B.You can performofflinewhole database backups. C.You cannot perform schema-level export/import operations. D.You can perform the backup of only the SYSTEM tablespace when the database is open.
答案
Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）
A.You can perform online whole database backups. B.You can performofflinewhole database backups. C.You cannot perform schema-level export/import operations. D.You can perform the backup of only the SYSTEM tablespace when the database is open.
答案
You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）
A.One tablespace has only one datafile B.Many tablespaces can share one datafile C.One tablespace can have many datafiles D.One datafile can contain many tablespaces
答案
热门试题
You work as a database administrator for Certkiller .com. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）
You work as a database administrator for Certkiller .com. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）
Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？ （）
Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）
You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）
Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）
You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）
Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）
You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database？（）
If you create your database using Oracle Managed Files （OMF）， what is true？（）
You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）
You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）
You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）
You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）
Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）
Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）
While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to achieve the objective？（）
According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）
While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）
使用微信扫一扫登录
