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题

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

点击查看答案
第3题

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.

点击查看答案
第4题

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

点击查看答案
第5题

Whatdoestheoutputonthisreportindicate？（）RMAN>reportneedbackup；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.

点击查看答案
第6题

Whatistheimpactoftheresultsoftheoutputofthefollowingcommand？（）RMAN>reportunrecoverabledatabase；ReportoffilesthatneedbackupduetounrecoverableoperationsFileTypeofBackupRequiredName4fullorincrementalC：\ORACLE\ORADATA\ORCL\USERS01.DBFA.Therearenobackupsetswithanybackupsoftheusers01.dbfdatafile.B.Theusers01.dbfdatafilehashadunrecoverableoperationsoccurinit.Itwillneedtobebackeduporsomedatalossispossibleduringarecovery.C.Theusers01.dbfdatafileiscorrupted.D.Theusers01.dbfdatafilebackupexceedstheretentioncriteria.E.Thelastbackupoftheusers01.dbfdatafilefailedandmustbererun.

点击查看答案
第7题

Theonlineredologgroupconfigurationforyourdatabaseisasfollows:Whatwillhappeniftheonlineredologfile’ora02／oradata／redo02b.log’iscorruptedwhileworkingonthedatabase?()A.Thedatabasewillhang.B.Thedatabasewillbecrashed.C.Thedatabasewillbeshutdown.D.TheLGWRprocesswritesredologentriestotheotherredologmemberoftheGroup2group

点击查看答案

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

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容