单项选择题
You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？ （）
A. RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
B. RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF
C. RMAN would relocate all the database files to an ASM disk group.
D. RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
相关考题
-
单项选择题
OnMonday，youdroppedtheDEPTtablefromyourschemaandthenyoure-createdtheDEPTtableinyourschema.OnWednesday，youhavearequirementtorestoretheDEPTtablefromtherecyclebin.Whichstatementiscorrect？（）
A. You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
B. You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
C. You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
D. You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table. -
多项选择题
YourproductiondatabaseisrunningintheARCHIVELOGmodeandtheARCnprocessisfunctional.Youhavetwoonlineredologgroups.Whichthreebackgroundprocesseswouldbeinvolvedwhenalogswitchhappens？（）
A. log writer
B. archival
C. process monitor
D. system monitor
E. change tracking writer
F. database writer -
单项选择题
Youhavearead-onlytablespaceonread-onlymedia.Youwanttoperformamediarecoveryontheexistingdatafiles，butusingabackupcontrolfile.Thebackupcontrolfileindicatesthatthestatusoftheread-onlytablespacewasread/writewhenthecontrolfilewasbackedup.Whatshouldyouconsider？（）
A. take data files from the read-only tablespace offline before performing a recovery
B. recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
C. drop the read-only tablespace and re-create the tablespace after recovery
D. perform a recovery； status of the tablespace in control file will be changed automatically
