单项选择题
You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this?()
A. The index tablespace contains bitmap indexes.
B. The index tablespace contains more than one data file.
C. The index tablespace supports only complete recovery.
D. The index tablespace is not a dictionary-managed tablespace.
E. There is a dependency relationship between a table and its indexes.
相关考题
-
单项选择题
Youhaveadiskgroup,DGROUP1,withthreediskandNORMALredundancy.Youexecutethefollowingcommandtocreateatemplateforthediskgroup:ALTERDISKGROUPdgroup1ADDTEMPLATEmy_tempATTRIBUTES(MIRRORFINE);Whichstatementistrue?()
A. When a file is created in DGROUP1 with the template, it would have three-way mirroring.
B. When a file is created in DGROUP1, the MY_TEMP template becomes the default template.
C. When a file is created in DGROUP1 with the template, it would have two-way mirroring and file striping.
D. When a file is created in DGROUP1 with the template, it would have three-way mirroring and file striping.
E. When a file is created in DGROUP1 with the template, it would have two-way mirroring but no file striping. -
单项选择题
Theproductiondatabasehasbeenfunctionalforthelastsevendays.Becauseofapplicationrequirements,someoftheinitializationparameterswerechangedduringruntimewithoutanycomments.Youhaveaskedtofindoutthevalueoftheparameterswhentheinstancewasstarted.Whichsourcewouldyouusetolocatethisinformation?()
A. Fixed views
B. The alert log file
C. The parameter file
D. The server parameter file
E. Dynamic performance views -
单项选择题
You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs?()
A. Flashback logs are not deleted.
B. Flashback logs are deleted automatically.
C. Flashback logs are deleted only if you are using Recovery Manager (RMAN)
D. Flashback logs are deleted only if you are using Oracle Manager Files (OFM)
E. Flashback logs are deleted only if you are using Automatic Storage Management (ASM)
