网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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.
参考答案
更多 “ 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. ” 相关考题
考题
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;
考题
YoudisabledtheFlashbackDatabasefeaturebyusingthefollowingcommand:SQLALTERDATABASEFLASHBACKOFFWhatwouldbetheeffectofthiscommandontheexistingflashbacklogs?()
A.Flashbacklogsarenotdeleted.B.Flashbacklogsaredeletedautomatically.C.FlashbacklogsaredeletedonlyifyouareusingRecoveryManager（RMAN）.D.FlashbacklogsaredeletedonlyifyouareusingOracleManagedFiles（OMF）.E.FlashbacklogsaredeletedonlyifyouareusingAutomaticStorageManagement（ASM）.
考题
YourdatabasecontainstwotemporarytablespacesnamedTEMPandTEMP1.TheTEMPtablespaceisthedefaulttemporarytablespaceforthedatabase，andtheTEMP1tablespacewascreatedatdatabasecreation.YouwanttoincreasethesizeofthetempfilefortheTEMPtablespaceanddroptheTEMP1tablespacefromthedatabase.ThedatabaseisnotusingOracle-ManagedFiles（OMF）.WhichstatementmustyouusetoensurethatwhenyoudroptheTEMP1tablespacefromthedatabase，itscorrespondingoperatingsystemfileisalsodeleted？（）
考题
YouhavenotconfiguredOracleManagedFiles（OMF）inyourdatabase.Youdonotwanttoscantheentiredatafileeverytimeanincrementalbackupisperformed.Youdecidetoenabletheblockchangetrackingfeature.Whichstatementwillyouusetoenabletheblockchangetrackingfeature？（）A.ALTERSYSTEMENABLEBLOCKCHANGETRACKING；B.ALTERDATABASEENABLEBLOCKCHANGETRACKING；C.ALTERSYSTEMENABLEBLOCKCHANGETRACKINGUSINGFILE；D.ALTERDATABASEENABLEBLOCKCHANGETRACKINGUSINGFILE；
考题
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.
考题
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.
考题
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).
考题
IfyoucreateyourdatabaseusingOracleManagedFiles(OMF),whatistrue?()
A.YoumustuseOraclepredefinednamestoidentifyrawpartitionsthatwillholdOMF structures.B.Youmustdefinedirectoriesfortwoonlineredologgroupsandthreecopiesofthecontrolfile.C.IfyourCREATEDATABASEcommandfails,anyOMFdatabasefilesthathavealreadybeencreatedwillbedroppedautomatically.D.YoumustuseonlyOMFdatafileswhenaddingnewtablespacesordatafilestoyourdatabaseinthefuture.
热门标签
最新试卷
