YouissuethisSQLstatement:ALTERDATABASERENAMEFILE’／ORADATA／u02／user_data01.dbf’TO’／ORADATA／u04／user_data01.dbf’;WhatdoesthisSQLstatementdo?()A.Itupdatesthecontrolfilewiththenewlocationofthedatafile.B.Itupdatesonlythedatadictionarywiththenewlocationofthedat

题目
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.

相似考题

1.Youhavelostallyouronlineredologs.Asaresult，yourdatabasehascrashed.Youhavetriedtorestartthedatabaseandcleartheonlineredologfiles，butwhenyoutrytoopenthedatabaseyougetthefollowingerror.SQL>startupORACLEinstancestarted.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：3SQL>alterdatabaseclearlogfilegroup2；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.

2.AuserexecutesaqueryontheEMPtable，whichcontainsthousandsofrows，togetdetailsaboutemployeesinoneofthedepartments.Theuserreceivesthefollowingerror：SQL>SELECTenameFROMempWHEREdeptno=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.

3.ExaminethecommandsexecutedinaDBAsession：SQL>CREATEBIGFILETABLESPACEMRKT2DATAFILE’/u01/app/oracle/oradata/orcl/mrkt.dbf’size10MLOGGING3EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO；Tablespacecreated.SQL>ALTERDATABASEDEFAULTTABLESPACEMRKT；Databasealtered.WhichtwostatementsaretrueregardingtheMRKTtablespace（）A.Nomoredatafilescanbeaddedtothetablespace.B.Segmentspaceismanagedbyfreelistsinthetablespace.C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit

4.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？（）

更多“YouissuethisSQLstatement:ALTERDATABASERENAMEFILE’／ORADATA／u02／user_data01.dbf’TO’／ORADATA／u04／user_data01.dbf’;WhatdoesthisSQLstatementdo?() ”相关问题

  • 第1题：

    Whatdoestheoutputonthisreportindicate？（）RMAN>reportneedbackup；RMANretentionpolicywillbeappliedtothecommandRMANretentionpolicyissettoredundancy1Reportoffileswithlessthan1redundantbackupsFilebkpsName50C：\ORACLE\ORADATA\ORCL\MY_DATA_01.DBF

    A.Themy_data_01.dbfdatafileiscorruptedandneedstoberestored.

    B.Themy_data_01.dbfdatafilehasnotyetbeenbackedup.Thisreportdoesnotimplythatthedatainthedatafilecannotberecovered.

    C.Themy_data_01.dbfdatafilehasnotyetbeenbackedup.Thisreportimpliesthatthedatainthedatafilecannotberecovered.

    D.Themy_data_01.dbfdatafilenolongermeetstheretentioncriteriaforbackups.

    E.Datafile5ismissing.


    参考答案：B

  • 第2题：

    Theonlineredologgroupconfigurationforyourdatabaseisasfollows:Whatwillhappeniftheonlineredologfile’ora02／oradata／redo02b.log’iscorruptedwhileworkingonthedatabase?()

    A.Thedatabasewillhang.

    B.Thedatabasewillbecrashed.

    C.Thedatabasewillbeshutdown.

    D.TheLGWRprocesswritesredologentriestotheotherredologmemberoftheGroup2group


    参考答案：D

  • 第3题：

    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.


    参考答案：C, D

  • 第4题：

    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.


    参考答案：D

  • 第5题：

    Youexecutedthefollowingcommand:RMAN>RECOVERCOPYOFDATAFILE’／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.


    参考答案：C

  • 第6题：

    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.A

    B.B

    C.C

    D.D


    参考答案：D

  • 第7题：

    电网零序电压的表达方式写为（）。

    • A、IE=100IR/U02
    • B、U02=U12*IR/IE
    • C、IE=U02*IR/100
    • D、U02=100IR/IE 

    正确答案:A

  • 第8题：

    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；

    正确答案:A,C

  • 第9题：

    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

    正确答案:D

  • 第10题：

    单选题
    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. '/ u01/app/oracle/oradata/orcl/users01.dbf

    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


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    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’


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第13题：

    Whatistheimpactoftheresultsoftheoutputofthefollowingcommand？（）RMAN>reportunrecoverabledatabase；ReportoffilesthatneedbackupduetounrecoverableoperationsFileTypeofBackupRequiredName4fullorincrementalC：\ORACLE\ORADATA\ORCL\USERS01.DBF

    A.Therearenobackupsetswithanybackupsoftheusers01.dbfdatafile.

    B.Theusers01.dbfdatafilehashadunrecoverableoperationsoccurinit.Itwillneedtobebackeduporsomedatalossispossibleduringarecovery.

    C.Theusers01.dbfdatafileiscorrupted.

    D.Theusers01.dbfdatafilebackupexceedstheretentioncriteria.

    E.Thelastbackupoftheusers01.dbfdatafilefailedandmustbererun.


    参考答案：D

  • 第14题：

    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；


    参考答案：A, C

  • 第15题：

    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’


    参考答案：C

  • 第16题：

    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.


    参考答案：C

  • 第17题：

    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’


    参考答案：C

  • 第18题：

    YouissuethefollowingcommandinOracle:CREATETABLESPACEDAT_TBSDATAFILE"dat_tbs.dbf"SIZE2M;.Laterqueriesagainstthedatabaserevealthatthetablespaceislocatedinthe/u01/oradata/oracledirectory.WhichofthefollowingchoicesidentifieshowOraclelikelydeterminedwhatdirectorytoplacedat_tbs.dbffilein?（）

    A.DB_CREATE_FILE_DEST

    B.DB_CREATE_ONLINE_LOG_1

    C.DB_CREATE_ONLINE_LOG_2

    D.Thedirectoryisanoperatingsystem-specificdefaultvalueinOraclethatcanneigherbespecifiedmanuallynorchanged


    参考答案：A

  • 第19题：

    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. '/ u01/app/oracle/oradata/orcl/users01.dbf
    • 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

    正确答案:C

  • 第20题：

    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， f
    • B、e， b， a， f
    • C、e， b， a， g
    • D、b， a， g
    • E、c， e， b， d， f

    正确答案:E

  • 第21题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    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’


    正确答案： D
    解析： 暂无解析

相关内容