文稿062-题库解析181

1、201908chooseSMDisasmallfilelocallymanagedtablespacewithmanualsegmentspace201908chooseSMDisasmallfilelocallymanagedtablespacewithmanualsegmentspaceTheSHuserreceivesthefollowingerrorwhileinsertingotheSALESineORA-01653:unabletoextendtableSH.SALESbyWhichthreeactionscanbetakentoenablethe usertoinsertA)ad

2、dingadatafiletotheSMDtablespace, providedthetablespacehas notreachedits number of filesB) increasing the space quota on the SMD tablespace for the SH user, provided the files have yetreachedumchangingsegmentspacemanagementfortheSMDtablespacetoresizing the data file ted with the SMD tablespace to mak

3、e it larger, provided all fileshavenotyetreachedE)alteringthedatafileumtedwiththeSMDtablespacetogrowchooseWhichtwoementsaretrueaboutthe(PMON)backgroundsinOracleDatabaseA)chooseWhichtwoementsaretrueaboutthe(PMON)backgroundsinOracleDatabaseA)ItrecordshecontrolB)ItfreesheldbyabnormallyterminatedC) It r

4、egisters database with all local and remote listeners known to the D)ItfreesunusedtemporaryE)It killsstexceedidle（ chooseYou want to distribute a set of structured o yourchooseYou want to distribute a set of structured o your customers who egrate this otheirexistingdatabasesirrespectiveoftheethodpro

5、videsthefastestwayofachievingusingtheDBVERIFY usingusingRMANtransportabletablespace（ chooseInyourdatabaseinstance,theUNDO_RETENTIONparameterissetto1000chooseInyourdatabaseinstance,theUNDO_RETENTIONparameterissetto1000andundoretention is not guaranteed for the fixed size undo tablespace.Whichementist

6、rueabout undoA.Inactivesretainedeast1000secondsiffreeundospaceisB.C.esexpiredobsoleteafter1000s heUNDOtablespacefor1000seconds,andthenmovedtothetablespacetoprovidereadD.Inactivesretainedfor1000seconds evenifnewionsfall duetolackofspace theundo（chooseWhichthreeementschooseWhichthreeementsaretrueabout

7、 riseManager DatabaseThesameportnumberisusedfor multipleDatabaseExpressconfigurationsonthesameItcanusetheHTTPItcanbeusedtoperformdatabasebackupItcanusetheHTTPS Itisavailableonlywhenthe databaseis( chooseYourdatabaseisrunninginNOARCHIVINGmode.ExaminethefollowingYouexecutethedchooseYourdatabaseisrunni

8、nginNOARCHIVINGmode.ExaminethefollowingYouexecutethed WhichementistrueabouttheexecutionofA.Itcsfullyandsets$ORACLE_HOME/dbsasthedefaultarchiveB.ItfailsandreturnsanerroraboutLOG_ARCHIVE_DESTnotbeingC.ItD.Itexecute ccsfullyandsetstheFastRecoveryArea asthelocalarchive sfullyandesawarningtosetLOG_ARCHIV

9、E_DESTwhileopening（chooseWhichementistrueaboutredologfiles duringinstancechooseWhichementistrueaboutredologfiles duringinstanceA)Allcurrent,active,andinactiveredologsarerequiredtocompleteinstanceAllredo log entries Allredologhe current log are d to data files until the ition hecurrentandactivelogsar

10、edtodatafilestoreconstructmadeafterthemostrecentD)Allcurrent, online,andarchivedredologsarerequiredtocompleteinstance（ chooseWhichtaskis performedbya backgroundschooseWhichtaskis performedbya backgroundsina databaseA.CopyingonlineredologfilestoofflineB.Connectingna ntsanda C.ExecutingPL/SQLD.Creatin

11、gdedicatedserveronline redologchooseWhatshouldyouchooseWhatshouldyoudototajobstored minimaljobmetadataandruntime dataonanduses onlyexistingPL/SQLCreatealightweightCreateanevent-basedUseajobSpecifythejobasamemberofajob（ chooseAnapplicationrepeatedlysessmalllookuptables,causingchooseAnapplicationrepea

12、tedlysessmalllookuptables,causingalot ofphysicalI/OWhatdomendtominimizeA.Configurethenonstandardbuffercachebufferbuffersizenthesize oftheB.ConfiguretheuffercacheandalterthetablestousetheRECYCLEC.ConfiguretheKEEPbuffercacheandalterthetablestousetheKEEPD.Increasethesizeoftheshared （16. Examine the str

13、ucture of the sales table, which is stored in a locally managed tablespacewithAutomaticSegmentSpaceManagement(ASSM)YouwanttoperformYouwanttoperform 16. Examine the structure of the sales table, which is stored in a locally managed tablespacewithAutomaticSegmentSpaceManagement(ASSM)YouwanttoperformYo

14、uwanttoperform gmentshrinktoreclaim fragmentedgmentshrinktoreclaim fragmentedfreespacebelow thehighwaterWhatshouldyouensurebeforethestartoftheA.RowmovementisB.egritysforthetableareC.NoqueriesarerunningonthisD.Extradisk spaceequivalenttothesizeof thesegmentisE.NopendingAnswer:ionexists onthe toupgrad

15、easingle-instanceOracle11gR2databasetoOracleDatabaseA.shuttingdownthedatabaset isbeingB.executingthecatctl.plscripttoruntheupgradeC.runningthePre-UpgradeInformationsesinD.copyingthelistener.orafiletothenewAnswer:（18.YourdatabaseisopenandthelistenerLISTNENERised:LSNRCTLWhatistheeffectofreloadonstwere

16、originallyestablishedbyOnlysbasedoniclistenerregistrationsareExisting connections are not disconnected; however, they cannot perform operations until thelistenercompletesthere-registrationofthedatabaseinstanceandserviceC.ThesarenotaffectedandcontinuetofunctionD.Allthes areterminatedand activeAnswer:

17、ionsarerolled（ementistrueregardingD.Allthes areterminatedand activeAnswer:ionsarerolled（ementistrueregardingthestartupofadatabaseA. The instance does not start up normally and requires manual media recovery after a shutdown using the abort option.mitted ions are rolled back during the startup of the

18、 database afterashutdownusingtheimmediateC.ThereisnoheunderlyingmechanicsofthestartupwhethertheisshutdownbyusingtheimmediateoptionortheabortD. Media recovery is required when the database is shut down by using either the immediate option or the abort option.E. Instance recovery is not required if the database instance was shut down b