网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
IfyoucreateyourdatabaseusingOracleManagedFiles(OMF),whatistrue?()
A.YoumustuseOraclepredefinednamestoidentifyrawpartitionsthatwillholdOMF structures.
B.Youmustdefinedirectoriesfortwoonlineredologgroupsandthreecopiesofthecontrolfile.
C.IfyourCREATEDATABASEcommandfails,anyOMFdatabasefilesthathavealreadybeencreatedwillbedroppedautomatically.
D.YoumustuseonlyOMFdatafileswhenaddingnewtablespacesordatafilestoyourdatabaseinthefuture.
参考答案
更多 “ IfyoucreateyourdatabaseusingOracleManagedFiles(OMF),whatistrue?() A.YoumustuseOraclepredefinednamestoidentifyrawpartitionsthatwillholdOMF structures.B.Youmustdefinedirectoriesfortwoonlineredologgroupsandthreecopiesofthecontrolfile.C.IfyourCREATEDATABASEcommandfails,anyOMFdatabasefilesthathavealreadybeencreatedwillbedroppedautomatically.D.YoumustuseonlyOMFdatafileswhenaddingnewtablespacesordatafilestoyourdatabaseinthefuture. ” 相关考题
考题
YoudisabledtheFlashbackDatabasefeaturebyusingthefollowingcommand:SQLALTERDATABASEFLASHBACKOFFWhatwouldbetheeffectofthiscommandontheexistingflashbacklogs?()
A.Flashbacklogsarenotdeleted.B.Flashbacklogsaredeletedautomatically.C.FlashbacklogsaredeletedonlyifyouareusingRecoveryManager（RMAN）.D.FlashbacklogsaredeletedonlyifyouareusingOracleManagedFiles（OMF）.E.FlashbacklogsaredeletedonlyifyouareusingAutomaticStorageManagement（ASM）.
考题
YouhaveanAutomaticStorageManagement（ASM）instancemanagingthedatabasefilesofyourproductiondatabase.ThedatabasecontainsASMfilesandnonASMfiles.UsingRecoveryManager（RMAN），youmigratethecompleteproductiondatabasetousetheASMinstance.Whichstatementistrue？（）A.RMANwouldrelocateallthedatabasefilestoanASMdiskgroup.B.RMANwouldchangethefiledefinitionsinthecontrolfiletousetheASMbutwouldnotrelocatethedatabasefilesphysically.C.RMANwouldrelocateallthedatafilestoanASMdiskgroupandotherfilestoanoperatingsystemlocation，definedusingOracleManagedFiles（OMF）.D.RMANwouldrelocatetheASMfilestoanASMdiskgroupandthenonASMfilestoanoperatingsystemlocation，definedusingOMF
考题
YouworkasadatabaseadministratorforSupportcenter.cn.YouareusingRecoveryManager（RMAN）forbackupandrecoveryofyourdatabase.YouexecutedthedeletecommandinRMANtodeleteabackupofatablespace.Whichstatementistrueinthisscenario？（）A.ThebackupstatuswillbemarkedexpiredinRMANrecoverycatalog.B.ThebackupstatuswillbemarkeddeletedinRMANrecoverycatalogafteryouexecutethecrosscheckcommand.C.ThebackupwillbedeletedphysicallyfromtheOS（Operatingsystem）andthebackupinformationisremovedfromtherecoverycataloglD.ThebackupstatuswillbemarkeddeletedandyoumustdeletethebackupfilemanuallyfromtheOS（Operatingsystem）.E.ThebackupstatuswillbemarkeddeletedandyoumustdeletethebackupfilemanuallyfromtheOS（Operatingsystem），ifyouarenotusingOracleManagedFiles（OMF）.
考题
YouworkasadatabaseadministratorforSupportcenter.cn.InyourOracledatabase10ginstallationyouhavesetORACLE_BASEto／u01／app／oracle.Whichobjectivewillbeachievedbythissetting?()
A.TheOraclekernelwillbeplacedinthislocation.B.TheOraclesoftwarewillbeplacedinthislocation.C.Theserverparameterfile（SPFILE）willbeplacedinthislocation.D.Thedatabasefileswillbeplacedinthislocation，ifnotspecifiedexplicitly.E.ThelocationwillbeconsideredforthebaseofOracleManagedFiles（OMF）.F.ThelocationwillbeconsideredforthebaseofOptimalFlexibleArchitecture（OFA）.
考题
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).
考题
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.
考题
YouareattemptingtocreateanOracle-ManagedFiles（OMF）tablespaceinaproductiondatabasewiththefollowingstatementandreceivethefollowingerrormessage：CREATETABLESPACEtbsl；ORA-02199：missingDATAFILE/TEMPFILEclauseoerrora219902199，00000，missingDATAFILE/TEMPFILEclause”*Cause：ACREATETABLESPACEstatementhasnoDATAFILE/TEMPFTLEclause.*Action：specifyDATAFILE/TEMPFILEclause.WhatisthecorrectiveactiontocreatetheOMFbasedtablespace？（）A.AB.BC.CD.D
考题
Nexusshipigmpsnoopingvlan120IGMP&en
Nexus#shipigmpsnoopingvlan120IGMPSnoopinginformationforvlan120IGMPsnoopingdisabledOptimisedMulticastFlood（OMF）disabledIGMPqueriernoneSwitch-querierenabled，address1.1.1.1，currentlynotrunningIGMPv3ExplicittrackingenabledIGMPv2FastleavedisabledIGMPv1/v2ReportsuppressionenabledIGMPv3ReportsuppressiondisabledLinkLocalGroupssuppressionenabledRouterportdetectionusingPIMHellos，IGMPQueriesNumberofrouter-ports：0Numberofgroups：0Activeports：Po100Po111Whichstatementbestdescribeswhatisdepictedintheshowcommandoutput？（）
考题
You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A、 You must use automatic undo management in the database.B、 You must configure OMF in your database.C、 You must configure ASM for storing the datafiles.D、 You must multiplex the online redo log file.
考题
The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility. What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（） A、 The block change tracking feature must be enabled.B、 OMF must be configured on your database.C、 The database must be in ARCHIVELOG mode.D、 A USERID must be supplied.
考题
You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature. What information will be written in the change tracking file？（）A、 the system change numberB、 the locations of the redo log filesC、 the locations of the datafilesD、 the physical location of all the database changes
考题
单选题The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for disk backups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters. Which statement is correct in this scenario？（）A
If the FORMAT option to the RMAN BACKUP command is specified， then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files （OMF） format.B
If any local destinations for LOG_ARCHIVE_DEST_n are set， then archived redo logs are stored in these destinations as well as in the flash recovery area.C
If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter， then the RMAN backup of Oracle managed datafiles （OMF） only will go to the flash recovery area by default.D
If no other destination is configured for recovery files， then RMAN places the control file autobackups in the flash recovery area by default.
考题
单选题If you create your database using Oracle Managed Files （OMF）， what is true？（）A
You must use Oracle predefined names to identify raw partitions that will hold OMF structures. B
You must define directories for two online redo log groups and three copies of the control file. C
If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. D
You must use only OMF data files when adding new tablespaces or data files to your database in the future.
考题
多选题Which two statements are true about Oracle Managed Files (OMF)?（）AOMF cannot be used in a database that already has data files created with user-specified directions.BThe file system directions that are specified by OMF parameters are created automatically.COMF can be used with ASM disk groups, as well as with raw devices, for better file management.DOMF automatically creates unique file names for table spaces and control files.EOMF may affect the location of the redo log files and archived log files.
考题
单选题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 database files to an ASM disk group.B
RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.C
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）.D
RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF
考题
单选题You have implemented OMF for redo log management. Which of the following choices reflects a log filename that might be employed when OMF is enabled?（）A
log01.log B
logORCL01.log C
1_2.logALTER ROLLBACK SEGMENT D
ora_1_asdf1234.log
考题
单选题You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature. What information will be written in the change tracking file？（）A
the system change numberB
the locations of the redo log filesC
the locations of the datafilesD
the physical location of all the database changes
考题
多选题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?（）AUse Oracle Managed Files (OMF).BSpecify the SEED FILE_NAME_CONVERT clause.CSpecify the PDB_FILE_NAME_CONVERT initialization parameter.DSpecify the DB_FILE_NAMECONVERT initialization parameter.ESpecify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
考题
单选题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 Managed Files （OMF）.E
Flashback logs are deleted only if you are using Automatic Storage Management （ASM）.
考题
单选题The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility. What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）A
The block change tracking feature must be enabled.B
OMF must be configured on your database.C
The database must be in ARCHIVELOG mode.D
A USERID must be supplied.
考题
单选题You are attempting to create an Oracle-Managed Files （OMF） tablespace in a production database with the following statement and receive the following error message： CREATE TABLESPACE tbsl； ORA-02199： missing DATAFILE/TEMPFILE clause oerr ora 2199 02199， 00000， “missing DATAFILE/TEMPFILE clause” *Cause： A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause. *Action： specify DATAFILE/TEMPFILE clause. What is the corrective action to create the OMF based tablespace？（）A
AB
BC
CD
D
热门标签
最新试卷
