考题
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? ()A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE_LOG viewC. Query the V$RECOVERY_FILE_DEST_SIZE viewD.Query the V$FLASHBACK_DATABASE_STAT viewE. Check the value assigned for the UNDO_RETENTION parameter
考题
YouwantanASMinstancetomanagethefilesofyourdatabase.Toachievethisobjective,youspecifythefollowingparametersintheparameterfileofthedatabase:INSTANCE_TYPE=RDBMSDB_NAME=PRODLARGE_POOL_SIZE=8MBDB_BLOCK_SIZE=4KLOG_ARCHIVE_DEST=+dgroupALOG_ARCHIVE_FORMAT=$ORACLE_SID_%s_%t.%tDB_CREATE_FILE_DEST=+dgroupACOMPATIBLE=10.1.0.2.0CONTROL_FILES=+dgroupAWhichparameterwouldbeignoredwhilestartinguptheinstanceforthedatabasePROD?()A.DB_BLOCK_SIZEB.CONTROL_FILESC.LARGE_POOL_SIZED.LOG_ARCHIVE_DESTE.LOG_ARCHIVE_FORMATF.DB_CREATE_FILE_DEST
考题
Youexecutedthefollowingcommandtostartthedatabase:SQLSTARTUPORACLEinstancestarted.TotalSystemGlobalArea281018368bytesFixedSize789000bytesVariableSize229635576bytesDatabaseBuffers50331648bytesRedoBuffers262144bytesORA-00205:errorinidentifyingcontrolfile,checkalertlogformoreinfoWhichviewwouldyouqueryatthisstagetoinvestigatethismissingcontrolfile?()A.V$INSTANCEB.V$CONTROLFILEC.DBA_CONTROL_FILESD.V$DATABASE_PROPERTIESE.V$CONTROLFILE_RECORD_SECTION
考题
Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?()
A.QuerytheV$FLASHBACK_DATABASE_LOGview.B.QuerytheV$FLASHBACK_DATABASE_STATview.C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.D.QuerytheV$RECOVERY_FILE_DESTview.
考题
YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired?()A.V$DATABASEB.V$FLASHBACK_DATABASE_STATC.V$FLASHBACK_DATABASE_LOGD.V$RECOVERY_FILE_DEST
考题
Which command should an administrator use to view files and volume group backup information from a mksysb called server1.mksysb that is found in /backups?()
A.lsmksysb -l /backups/server1.mksysbB.showmksysb -f /backups/server1.mksysbC.listvgbackup -f /backups/server1.mksysbD.showvgbackup -l /backups/server1.mksysb
考题
Whileinstallinganapplication,theadministratorisinstructedtoperformtwofinaltaskspriortostartingtheapplication:1.Settheownershipofafilenamed’control_file’tobeownedbytheuser’database’andthegroup’appsrvr’.2.Changethepermissionsof’control_file’to0766.Afterthesetwotaskshavebeencompleted,whatwillthefilepermissionslooklikewhen’ls-lcontrol_file’isexecuted?()A.-rwxrw-rw-1databaseappsrvr4913Mar1708:24control_fileB.-rw-r--r--1appsrvrdatabase4913Mar1708:24control_fileC.-rw-r--r--1databaseappsrvr4913Mar1708:24control_fileD.-rwxrw-rw-1appsrvrdatabase4913Mar1708:24control_file
考题
WhichtwostatementsregardingthecontrolfileandRecoverManageraretrue?()
A.Thecontrolfilecangrowinsize.B.ThecontrolfilecanstoreRMANscripts.C.CONTROL_FILE_RECORD_KEEP_TIMEdeterminesretentiontimeforRMANrecords.D.TheRMANcatalogcanexistsolelyinthecontrolfileofthetargetdatabase.
考题
使用数据库初始化参数文件中的()参数可以指定控制文件名。
A.CONTROL_FILESB.CONTROL_FILES_NAMEC.CONTROL_NAMED.CONTROL_FILE
考题
______ has many elements: text, audio sound, static graphics images, animations, and video.
A.Multimedia]
B.DatabasE.C.File]
D.Document