YouissuethisSQLstatement:ALTERDATABASERENAMEFILE’／ORADATA／u02／user_data01.dbf’TO’／ORADATA／u04／user_data01.dbf’;WhatdoesthisSQLstatementdo?() A.Itupdatesthecontrolfilewiththenewlocationofthedatafile.B.Itupdatesonlythedatadictionarywiththenewlocationofthedatafile.C.Itchangesthelocationoftheuser_data01.dbffileintheoperatingsystem.D.Itchangesthelocationoftheuser_data01.dbffileintheoperatingsystemandupdatesthecontrolfilewiththenewlocationofthedatafile.
YouissuethisSQLstatement:ALTERDATABASERENAMEFILE’／ORADATA／u02／user_data01.dbf’TO’／ORADATA／u04／user_data01.dbf’;WhatdoesthisSQLstatementdo?()
A.Itupdatesthecontrolfilewiththenewlocationofthedatafile.
B.Itupdatesonlythedatadictionarywiththenewlocationofthedatafile.
C.Itchangesthelocationoftheuser_data01.dbffileintheoperatingsystem.
D.Itchangesthelocationoftheuser_data01.dbffileintheoperatingsystemandupdatesthecontrolfilewiththenewlocationofthedatafile.
相关考题：
Youhavelostallyouronlineredologs.Asaresult，yourdatabasehascrashed.Youhavetriedtorestartthedatabaseandcleartheonlineredologfiles，butwhenyoutrytoopenthedatabaseyougetthefollowingerror.SQLstartupORACLEinstancestarted.TotalSystemGlobalArea167395328bytesFixedSize1298612bytesVariableSize142610252bytesDatabaseBuffers20971520bytesRedoBuffers2514944bytesDatabasemounted.ORA-00313：openfailedformembersofloggroup2ofthread1ORA-00312：onlinelog2thread1：，，/oracle01/oradata/orcl/redo02a.logORA-27037：unabletoobtainfilestatusLinuxError：2：NosuchfileordirectoryAdditionalinformation：3ORA-00312：onlinelog2thread1：，，/oracle01/oradata/orcl/redo02.logORA-27037：unabletoobtainfilestatusLinuxError：2：NosuchfileordirectoryAdditionalinformation：3SQLalterdatabaseclearlogfilegroup2；alterdatabaseclearlogfilegroup2*ERRORatline1：ORA-01624：log2neededforcrashrecoveryofinstanceorcl（thread1）ORA-00312：onlinelog2thread1：，，/oracle01/oradata/orcl/redo02.logORA-00312：onlinelog2thread1：，，/oracle01/oradata/orcl/redo02a.logWhatstepsmustyoutaketoresolvetheerror？（）a.Issuetherecoverdatabaseredologscommand.b.IssuetheStartupMountcommandtomountthedatabase.c.Restorethelastfulldatabasebackup.d.Performapoint-in-timerecovery，applyingallarchivedredologsthatareavailable.e.Restoreallarchivedredologsgeneratedduringandafterthelastfulldatabasebackup.f.Openthedatabaseusingthealterdatabaseopenresetlogscommand.g.Issuethealterdatabaseopencommand.
Ausersendsyouanemailwiththefollowingerrormessage：createtableidtable（idnumber）*ERRORatline1：ORA-01110：datafile4：，，/oracle01/oradata/orcl/users01.dbfORA-27041：01116：errorinopeningdatabasefile4ORA-unabletoopenfileLinuxError：2：NosuchfileordirectoryAdditionalinformation：3Youcanchoosefromthefollowingsteps：a.Restorethemissingdatabasedatafiles.b.Takethemissingdatafileoffline.c.Shutdownthedatabase.d.IssuetherecovertablespaceUSERScommand.e.IssuetheStartupMountcommandtomountthedatabase.f.BringtheUSERStablespaceonline.g.Issuethealterdatabaseopencommand.Whichisthecorrectorderofthesestepsinthiscase？（）
AuserexecutesaqueryontheEMPtable，whichcontainsthousandsofrows，togetdetailsaboutemployeesinoneofthedepartments.Theuserreceivesthefollowingerror：SQLSELECTenameFROMempWHEREdeptno=10ORDERBYsalSELECTenameFROMempWHEREdeptno=10ORDERBYsal*ERRORatline1：ORA01157：cannotidentify/lockdatafile201seeDBWRtracefileORA01110：datafile201：’/u01/app/oracle/oradata/orcl/temp01.dbf’Whatisapossiblereason？（）A.Thetempfilebelongingtothedefaulttemporarytablespaceismissing.B.Thedatabaseisopenedinrestrictedmode，soqueriesarenotallowed.C.Thedefaulttemporarytablespacerequiredtoexecutethequeryisoffline.D.Thedefaulttemporarytablespacerequiredtoexecutethequeryisdropped.E.Thedefaulttemporarytablespacerequiredtoexecutethequeryisreadonly.
ExaminethecommandsexecutedinaDBAsession：SQLCREATEBIGFILETABLESPACEMRKT2DATAFILE’/u01/app/oracle/oradata/orcl/mrkt.dbf’size10MLOGGING3EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO；Tablespacecreated.SQLALTERDATABASEDEFAULTTABLESPACEMRKT；Databasealtered.WhichtwostatementsaretrueregardingtheMRKTtablespace（）A.Nomoredatafilescanbeaddedtothetablespace.B.Segmentspaceismanagedbyfreelistsinthetablespace.C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit
Whatdoestheoutputonthisreportindicate？（）RMANreportneedbackup；RMANretentionpolicywillbeappliedtothecommandRMANretentionpolicyissettoredundancy1Reportoffileswithlessthan1redundantbackupsFilebkpsName50C：\ORACLE\ORADATA\ORCL\MY_DATA_01.DBFA.Themy_data_01.dbfdatafileiscorruptedandneedstoberestored.B.Themy_data_01.dbfdatafilehasnotyetbeenbackedup.Thisreportdoesnotimplythatthedatainthedatafilecannotberecovered.C.Themy_data_01.dbfdatafilehasnotyetbeenbackedup.Thisreportimpliesthatthedatainthedatafilecannotberecovered.D.Themy_data_01.dbfdatafilenolongermeetstheretentioncriteriaforbackups.E.Datafile5ismissing.
Whatistheimpactoftheresultsoftheoutputofthefollowingcommand？（）RMANreportunrecoverabledatabase；ReportoffilesthatneedbackupduetounrecoverableoperationsFileTypeofBackupRequiredName4fullorincrementalC：\ORACLE\ORADATA\ORCL\USERS01.DBFA.Therearenobackupsetswithanybackupsoftheusers01.dbfdatafile.B.Theusers01.dbfdatafilehashadunrecoverableoperationsoccurinit.Itwillneedtobebackeduporsomedatalossispossibleduringarecovery.C.Theusers01.dbfdatafileiscorrupted.D.Theusers01.dbfdatafilebackupexceedstheretentioncriteria.E.Thelastbackupoftheusers01.dbfdatafilefailedandmustbererun.
Theonlineredologgroupconfigurationforyourdatabaseisasfollows:Whatwillhappeniftheonlineredologfile’ora02／oradata／redo02b.log’iscorruptedwhileworkingonthedatabase?() A.Thedatabasewillhang.B.Thedatabasewillbecrashed.C.Thedatabasewillbeshutdown.D.TheLGWRprocesswritesredologentriestotheotherredologmemberoftheGroup2group
Youhavethefollowingonlineredologconfiguration：GroupMember1’/disk1/oradata/redo01a.log’2’/disk2/oradata/redo02a.log’3’/disk3/oradata/redo03a.log’Youdecidetomultiplextheonlineredologgroupsforrecoveryofredologfilesincaseofanydisaster.WhichtwostatementswillyouNOTissuetomultiplextheonlineredologfiles？（）A.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo01b.log’TOGROUP1；B.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo01b.log’TOGROUP1；C.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo02b.log’TOGROUP2；D.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo02b.log’TOGROUP2；E.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo3b.log’TOGROUP3；F.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo3b.log’TOGROUP3；
Viewthisparametersettinginyourdatabase：DB_CREATE_FILE_DEST=’D：\oracle\product\10.2.0\oradata\oracle’Youcreatedatablespacebyusingthiscommand：CREATETABLESPACEUSERS；WhichtwostatementsaretrueabouttheUSERStablespace？（）A.Thetablespacehastwodatafiles.B.Anerrorisreportedandtablespacecreationfails.C.Datafilesarecreatedwithnamesgeneratedbytheinstance.D.Thetablespacecanbeextendedwithoutspecifyingthedatafile.E.DatafilesbelongingtotheUSERStablespacecannotberenamed.
Williamspecifiedthefollowinginitializationparametersettingsinthepfile：BACKGROUND_DUMP_DEST=’u01\oradata\dir_A’USER_DUMP_DEST=’u01\oradata\dir_B’DB_CREATE_FILE_DEST=’u01\oradata\dir_C’DB_CREATE_ONLINE_LOG_DEST_n=’u01\oradata\dir_D’Williamenabledthechange-trackingfeaturebecausehedoesnotwanttoscantheentiredatafileduringbackup.Whatisthedefaultstoragelocationforthechangetrackingfile？（）A.’u01\oradata\dir_A’B.’u01\oradata\dir_B’C.’u01\oradata\dir_C’D.’u01\oradata\dir_D’
Whileworkingonthedatabase，youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’YoudecidetorecoverthecorrupteddatablockbyusingtheBlockMediaRecoveryfeature.WhichoptionisNOTadisadvantageofusingblockmediarecovery？（）A.BlockMediaRecoverymustbeusedwithRMAN.B.Youmustperformcompleterecoveryofindividualblocks.C.YoumusthaveafullRMANbackup，notanincrementalbackup.D.YoumustusetheDBVERIFYutilitybeforeusingtheBlockMediaRecoveryfeature.
Exhibit：YouareworkingonadatabasecreatedwiththeOracleDatabase10gsoftwareinwhichtheinitializationparameterCOMPATIBLEissetto10.0.0.Thehr_tbstablespaceinthedatabaseiscreatedasfollows：CREATETABLESPACEhr_tbsDATAFILE’/oracle/oradata/hr_tbs.dbf’SIZE50M；ViewtheExhibittoseethepropertiesofthedatabase.Whichstatementiscorrectinthisscenario？（）A.hr_tbsisabigfiletablespace.B.hr_tbsisadictionary-managedtablespace.C.Allthetablespacesinthedatabasewillbelocallymanagedbydefault.D.Allthetablespacesinthedatabasemustbeofthesmallfiletablespacetype.E.Thetablespacetypebigfileorsmallfilemustbementionedinthecommand.
Youexecutedthefollowingcommand:RMANRECOVERCOPYOFDATAFILE’／u01／app／oracle／oradata／orcl／users01.dbf’;Whichstatementregardingtheabovecommandiscorrect?() A.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromtheimagecopy.B.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromthelastincrementalbackup.C.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafileareupdatedwithallchangesuptoincrementalbackupSCN.D.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafilearerecoveredusingtheabovecommandifdatafilerecoveryfails.
ExaminetheRMANcommand:SWITCHDATAFILE’／DISK3／user_data01.dbf’;Whichcommanddoyouneedtoissuebeforeyouissuetheabovecommand,sothatRMANfindsthefileintherestoredlocationof’DISK2／user_data01.dbf’?() A.RESTOREDATAFILE’/DISK2/user_data01.dbf’B.RESTOREDATAFILE’/DISK3/user_data01.dbf’C.SETNEWNAMEFOR’/DISK3/user_data01.dbf’TO’/DISK2/user_data01.dbf’D.SETNEWNAMEFOR’/DISK2/user_data01.dbf’TO’/DISK3/user_data01.dbf’
Examinethefollowingparametersettingsfromaninitialization（init.ora）file：DB_CREATE_FILE_DEST=’/u01/oradata/’DB_CREATE_ONLINE_LOG_DEST_1=’/u02/oradata/’DB_CREATE_ONLINE_LOG_DEST_2=’/u03/oradata/’IfyoucreateanOracleManagedFiles（OMF）databaseusingthesesettings，whatistheresult？（）A.AB.BC.CD.D
YouissuethefollowingcommandinOracle:CREATETABLESPACEDAT_TBSDATAFILE"dat_tbs.dbf"SIZE2M;.Laterqueriesagainstthedatabaserevealthatthetablespaceislocatedinthe/u01/oradata/oracledirectory.WhichofthefollowingchoicesidentifieshowOraclelikelydeterminedwhatdirectorytoplacedat_tbs.dbffilein?（）A.DB_CREATE_FILE_DESTB.DB_CREATE_ONLINE_LOG_1C.DB_CREATE_ONLINE_LOG_2D.Thedirectoryisanoperatingsystem-specificdefaultvalueinOraclethatcanneigherbespecifiedmanuallynorchanged
You executed the following command: RMAN RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）A、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copyB、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backupC、 Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbfD、Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails
You have the following online redo log configuration： Group Member 1 ’/disk1/oradata/redo01a.log’ 2 ’/disk2/oradata/redo02a.log’ 3 ’/disk3/oradata/redo03a.log’ You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files？（）A、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1；B、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1；C、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2；D、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2；E、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3；F、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3；
You have lost all your online redo logs. As a result， your database has crashed. You have tried to restart the database and clear the online redo log files， but when you try to open the database you get the following error. SQL startup ORACLE instance started. Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted. ORA-00313： open failed for members of log group 2 of thread 1 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 SQL alter database clear logfile group 2； alter database clear logfile group 2 * ERROR at line 1： ORA-01624： log 2 needed for crash recovery of instance orcl （thread 1） ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log What steps must you take to resolve the error？（） a. Issue the recover database redo logs command. b. Issue the Startup Mount command to mount the database. c. Restore the last full database backup. d. Perform a point-in-time recovery， applying all archived redo logs that are available. e. Restore all archived redo logs generated during and after the last full database backup. f. Open the database using the alter database open resetlogs command. g. Issue the alter database open command.A、b， a， fB、e， b， a， fC、e， b， a， gD、b， a， gE、c， e， b， d， f
The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（） A、 The database will hang.B、 The database will be crashed.C、 The database will be shut down.D、 The LGWR process writes redo log entries to the other redo log member of the Group2 group
单选题You executed the following command： RMAN RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’； Which statement regarding the above command is correct？（）A The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.B The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.C Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.D Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.
单选题You executed the following command: RMAN RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）AThe '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copyBThe '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backupC Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbfDImage copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails
单选题The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（）A The database will hang.B The database will be crashed.C The database will be shut down.D The LGWR process writes redo log entries to the other redo log member of the Group2 group
单选题William specified the following initialization parameter settings in the pfile： BACKGROUND_DUMP_DEST = ’u01/oradata/dir_A’ USER_DUMP_DEST = ’u01/oradata/dir_B’ DB_CREATE_FILE_DEST = ’u01/oradata/dir_C’ DB_CREATE_ONLINE_LOG_DEST_n = ’u01/oradata/dir_D’ William enabled the change-tracking feature because he does not want to scan the entire datafile during backup. What is the default storage location for the change tracking file？（）A ’u01/oradata/dir_A’B ’u01/oradata/dir_B’C ’u01/oradata/dir_C’D ’u01/oradata/dir_D’
单选题Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）ARESTORE DATAFILE ’/DISK2/user_data01.dbf’BRESTORE DATAFILE ’/DISK3/user_data01.dbf’CSET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’DSET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’
单选题You issue this SQL statement： ALTER DATABASE RENAME FILE ’/ORADATA/u02/user_data01.dbf’ TO ’/ORADATA/u04/user_data01.dbf’； What does this SQL statement do？（）AIt updates the control file with the new location of the data file. BIt updates only the data dictionary with the new location of the data file. CIt changes the location of the user_data01.dbf file in the operating system. DIt changes the location of the user_data01.dbf file in the operating system and updates the control file with the new location of the data file.