Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?()
A. Data files that belong to only the root container
B. Data files that belong to the root container and all the pluggable databases (PDBs)
C. Data files that belong to only the root container and PDB$SEED
D. Data files that belong to the root container and all the PDBs excluding PDB$SEED
第1题
se.Youhavetwodiskgroups,DG1andDG2withonedeviceeach.Intheparameterfileoftheproductiondatabase,thefollowingparametershavebeenspecified:DB_CREATE_ONLINE_LOG_DEST_1=’+dg1’DB_CREATE_ONLINE_LOG_DEST_2=’+dg2’Whatwouldbetheimpactofthissetting?()
A.Whenanewloggroupisadded,itwouldhaveonememberineachdiskgroup.
B.Whenanewloggroupisadded,itwouldhavetwomembersineachdiskgroup.
C.Whenanewtablespaceisadded,itwouldhaveonedatafileineachdiskgroup.
D.Whenanewlogfileisadded,itwouldhaveonememberspreadacrossthediskgroups.
第2题
se.Redologblocksarecorruptedingroup2,andarchivinghasstopped.Alltheredologsarefilledanddatabaseactivityishalted.Databasewriterhaswritteneverythingtodisk.Whichcommandwouldyouexecutetoproceedfurther?()
A.RECOVERLOFIELBLOCKGROUP2;
B.ALTERDATABASEDROPLOGFILEGROUP2;
C.ALTERDATABASECLEARLOGFILEGROUP2;
D.ALTERDATABASERECOVERLOGFILEGROUP2;
E.ALTERDATABASECLEARUNARCHIVEDLOGFILEGROUP2;
第3题
uranalysisshowsthattheFlashRecoveryareaisfull.Whichtwoactionscouldyoutaketoresolvetheerrorandavoidthiserrorinthefuture?()
A.takethebackupoftheflashrecoveryarealessfrequently
B.increasethevalueoftheUNDO_RETENTIONinitializationparameter
C.changethevalueoftheWORKAREA_SIZE_POLICYinitializationparametertoAUTO
D.changethebackupretentionpolicytoretainthebackupsforasmallerperiodoftime
E.increasethevalueoftheDB_RECOVERY_FILE_DEST_SIZEinitializationparameter
F.increasethevalueoftheCONTROL_FILE_RECORD_KEEP_TIMEinitializationparameter
第4题
A.Whenatableisdropped,thecorrespondingindexesareautomaticallydropped.
B.ForeachDMLoperationperformed,thecorrespondingindexesareautomaticallyupdated.
C.Indexesshouldbecreatedoncolumnsthatarefrequentlyreferencedaspartofanexpression.
D.Anon-deferrablePRIMARYKEYorUNIQUEKEYconstraintinatableautomaticallycreatesauniqueindex.
第5题
A. None of the data definition language (DDL) statements are logged in the trace file.
B. Only DDL commands that resulted in errors are logged in the alert log file.
C. A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
D. Only DDL commands that resulted in the creation of new database files are logged.
第6题
YourdatabaseoperatesinARCHIVELOGmode.User-managedconsistentbackupsareperformedevery
Sundaynight.OnTuesday,clientAdropsatableat8:00a.m.asfollows:
SQL>DROPTABLEcust_ordPURGE;
Tabledropped.
ClientBexecutesaqueryat9:00a.m.onthesametableasfollows:
SQL>SELECT*FROMcust_ord;
SELECT*FROMcust_ord
*ERRORatline1:ORA-00942:tableorviewdoesnotexist
ClientBneedsthedroppedtableandreportstheproblemtoyou.Withreferencetothisscenario,whichactionshouldyoutake?()
第7题
A.Thedatabaseisinmountstate.
B.Oneofthetablespacesisoffline.
C.Oneofthetablespacesisreadonly.
D.ThedatabaseoperatesinARCHIEVELOGmode.
E.ThedatabaseoperatesinNOARCHIEVELOGmode.
第8题
A.displayingthetotalordervalueforsalesrepresentatives161and163
B.displayingtheordertotalforsalesrepresentative161intheyear1999
C.displayingthenumberofordersthathaveordermodeonlineandorderdatein1999
D.displayingthenumberoforderswhoseordertotalismorethantheaverageordertotalforallonlineorders
第9题
nd that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational?()
A. Mount the container database (CDB) and restore the control file from the control file auto backup.
B. Recover and open the CDB in NORMAL mode.
C. Mount the CDB and then recover and open the database, with the RESETLOGS option.
D. Open all the pluggable databases.
E. Recover each pluggable database.
F. Start the database instance in the nomount stage and restore the control file from control file auto backup.
第10题
A.The DESCRIBE DEPT statement displays the structure of the DEPT table.
B.The ROLLBACK statement frees the storage space occupied by the DEPT table.
C.The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D.The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!