YouaremanaginganOracleDatabase10gdatabasethatusesOracleManagedFiles(OMF).Youenabledtheblockchangetrackingfeatureforthedatabase.Whichstatementregardingthechangetrackingfileistrue?()A.Oneblockchangetrackingfileiscreatedforeachdatafile.Bydefault，thefileiscre

题目
YouaremanaginganOracleDatabase10gdatabasethatusesOracleManagedFiles(OMF).Youenabledtheblockchangetrackingfeatureforthedatabase.Whichstatementregardingthechangetrackingfileistrue?()

A.Oneblockchangetrackingfileiscreatedforeachdatafile.Bydefault，thefileiscreatedinDB_CREATE_FILE_DEST.

B.Oneblockchangetrackingfileiscreatedforeachdatafile.Bydefault，thefileiscreatedinBACKGROUND_DUMP_DEST.

C.Oneblockchangetrackingfileiscreatedforthedatabase.Bydefault，thefileiscreatedinDB_CREATE_FILE_DEST.

D.Oneblockchangetrackingfileiscreatedforthedatabase.Bydefault，thefileiscreatedinBACKGROUND_DUMP_DEST.

相似考题

1.HDPC进程是属于哪个软件进程组?()A.CPB.RSSC.FMD.OMF

2.YoudisabledtheFlashbackDatabasefeaturebyusingthefollowingcommand:SQL>ALTERDATABASEFLASHBACKOFFWhatwouldbetheeffectofthiscommandontheexistingflashbacklogs?()A.Flashbacklogsarenotdeleted.B.Flashbacklogsaredeletedautomatically.C.FlashbacklogsaredeletedonlyifyouareusingRecoveryManager（RMAN）.D.FlashbacklogsaredeletedonlyifyouareusingOracleManagedFiles（OMF）.E.FlashbacklogsaredeletedonlyifyouareusingAutomaticStorageManagement（ASM）.

3.YourdatabasecontainstwotemporarytablespacesnamedTEMPandTEMP1.TheTEMPtablespaceisthedefaulttemporarytablespaceforthedatabase，andtheTEMP1tablespacewascreatedatdatabasecreation.YouwanttoincreasethesizeofthetempfilefortheTEMPtablespaceanddroptheTEMP1tablespacefromthedatabase.ThedatabaseisnotusingOracle-ManagedFiles（OMF）.WhichstatementmustyouusetoensurethatwhenyoudroptheTEMP1tablespacefromthedatabase，itscorrespondingoperatingsystemfileisalsodeleted？（）

4.You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

更多“YouaremanaginganOracleDatabase10gdatabasethatusesOracleManagedFiles(OMF).Youenabledtheblockchangetrackingfeatureforthedatabase.Whichstatementregardingthechangetrackingfileistrue?() ”相关问题

  • 第1题：

    YouhavenotconfiguredOracleManagedFiles（OMF）inyourdatabase.Youdonotwanttoscantheentiredatafileeverytimeanincrementalbackupisperformed.Youdecidetoenabletheblockchangetrackingfeature.Whichstatementwillyouusetoenabletheblockchangetrackingfeature？（）

    A.ALTERSYSTEMENABLEBLOCKCHANGETRACKING；

    B.ALTERDATABASEENABLEBLOCKCHANGETRACKING；

    C.ALTERSYSTEMENABLEBLOCKCHANGETRACKINGUSINGFILE；

    D.ALTERDATABASEENABLEBLOCKCHANGETRACKINGUSINGFILE；


    参考答案：D

  • 第2题：

    Which two statements are true about Oracle Managed Files (OMF)?()

    A. OMF cannot be used in a database that already has data files created with user-specified directions.

    B. The file system directions that are specified by OMF parameters are created automatically.

    C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

    D. OMF automatically creates unique file names for table spaces and control files.

    E. OMF may affect the location of the redo log files and archived log files.


    参考答案：B, D

  • 第3题：

    IfyoucreateyourdatabaseusingOracleManagedFiles(OMF),whatistrue?()

    A.YoumustuseOraclepredefinednamestoidentifyrawpartitionsthatwillholdOMF structures.

    B.Youmustdefinedirectoriesfortwoonlineredologgroupsandthreecopiesofthecontrolfile.

    C.IfyourCREATEDATABASEcommandfails,anyOMFdatabasefilesthathavealreadybeencreatedwillbedroppedautomatically.

    D.YoumustuseonlyOMFdatafileswhenaddingnewtablespacesordatafilestoyourdatabaseinthefuture.


    参考答案：D

  • 第4题：

    ThedatabaseisrunninginARCHIVELOGmodeandtheFORMAToptionisnotconfiguredinRMANfordiskbackups.YouconfiguredtheflashrecoveryarealocationandsizebyusingtheDB_RECOVERY_FILE_DESTandDB_RECOVERY_FILE_DEST_SIZEinitializationparameters.Whichstatementiscorrectinthisscenario？（）

    A.IftheFORMAToptiontotheRMANBACKUPcommandisspecified，thenRMANcreatesbackuppiecesandimagecopiesintheflashrecoveryareawithnamesintheOracleManagedFiles（OMF）format.

    B.IfanylocaldestinationsforLOG_ARCHIVE_DEST_nareset，thenarchivedredologsarestoredinthesedestinationsaswellasintheflashrecoveryarea.

    C.IftheflashrecoveryarealocationisconfiguredusingtheDB_RECOVERY_FILE_DESTinitializationparameter，thentheRMANbackupofOraclemanageddatafiles（OMF）onlywillgototheflashrecoveryareabydefault.

    D.Ifnootherdestinationisconfiguredforrecoveryfiles，thenRMANplacesthecontrolfileautobackupsintheflashrecoveryareabydefault.


    参考答案：D

  • 第5题：

    You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achieve this?（）

    A. Use Oracle Managed Files (OMF).

    B. Specify the SEED FILE_NAME_CONVERT clause.

    C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.

    D. Specify the DB_FILE_NAMECONVERT initialization parameter.

    E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).


    参考答案：A, B, C

相关内容