网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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?（）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
考题
单选题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’？ （）A
RESTORE DATAFILE ’/DISK2/user_data01.dbf’B
RESTORE DATAFILE ’/DISK3/user_data01.dbf’C
SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’D
SET 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？（）A
It updates the control file with the new location of the data file. B
It updates only the data dictionary with the new location of the data file. C
It changes the location of the user_data01.dbf file in the operating system. D
It 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.
热门标签
最新试卷