WhichcomponentoftheSGAstoresparsedSQLstatementsisusedfo-找考题网

单项选择题Managementhasdecidedthatthedatabasemustbeavailable24hoursaday，7daysaweek.Giventhisrequirement，whichtypeofbackupisrequired？（）

A.user-managedbackups.
B.partialdatabasebackups.
C.consistentdatabasebackups.
D.inconsistentdatabasebackups.

单项选择题OnswitchR1youissuethe udldenable globalcommand.Whatdoesthiscommandaccomplish？（）

A.Enablesallfiber-opticLANportsforUnidirectionalLINKDetection（UDLD）
B.EnablesallcoppermediaLANportsUnidirectionalLinkDetection（UDLD）
C.OverridesthedefaultUDLSsettingforallports
D.GloballyenablesallportsonthedeviceforUnidirectionalLinkDetection（UDLS）
E.Noneoftheotheralternativesapply

单项选择题Whiledesigningyourdatabase，youhavecreatedtheEMPLOYEEStableasanindex-organizedtable（IOT）.YouwanttocreateabitmapindexontheJOB_IDcolumntomakequeriesfaster.Whichtaskmusthavebeencompletedsothatyouareabletocreatethebitmapindex？（）A.Aprimarykeymusthavebeencreated.B.Amappingtablemusthavebeencreated.C.Anoverflowtablespacemusthavebeenspecified.D.ThePCTTHRESHOLDoptionmusthavebeenspecified.

A.YouwanttocreateabitmapindexontheJOB_IDcolumntomakequeriesfaster.Whichtaskmusthavebeencompletedsothatyouareabletocreatethebitmapindex？（）
A.Aprimarykeymusthavebeencreated.
B.Amappingtablemusthavebeencreated.
C.Anoverflowtablespacemusthavebeenspecified.
D.ThePCTTHRESHOLDoptionmusthavebeenspecified.

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

A.DBF
A.Therearenobackupsetswithanybackupsoftheusers01.dbfdatafile.
B.Theusers01.dbfdatafilehashadunrecoverableoperationsoccurinit.Itwillneedtobebackeduporsomedatalossispossibleduringarecovery.
C.Theusers01.dbfdatafileiscorrupted.
D.Theusers01.dbfdatafilebackupexceedstheretentioncriteria.
E.Thelastbackupoftheusers01.dbfdatafilefailedandmustbererun.

单项选择题WhichofthefollowingisaprerequisiteforrunningDBMS_TDB.CHECK_DBtoasuccessfulcompletion？（）

A.Thedatabasemustbeinread-writemode.
B.Thedatabasemusthavenoexternalfiles.
C.Thedatabasemustopeninread-onlymode.
D.Thedatabasemustbemountedbutnotopened.

WhichcomponentoftheSGAstoresparsedSQLstatementsisusedforprocesssharing?（）