Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the

nimportanttableresidinginhisschema.Thetablewaspurgedsometimebetween10：00P.M.and10：30P.M.Thenextday，youdecidetoflashbackthedatabase.Beforeyouflashbackthedatabase，youwanttoensurethatyouhaveallthenecessaryflashbackdata.Whichdynamicperformanceviewmustyouusetodeterminewhetheryouhavetherequiredflashbackdatatorecoverthepurgedtable？（）

A.V$DATABASE

B.V$UNDOSTAT

C.V$FLASHBACK_DATABASE_LOG

D.V$FLASHBACK_DATABASE_STAT

ksinthediskgroupbecomesunavailablebecauseofpowerfailure.YouissuedthefollowingcommandtochangetheDISK_REPAIR_TIMEattributefrom3.6hoursto5hours：ALTERDISKGROUPdg01SETATTRIBUTE’disk_repair_time’=’5h’；Towhichdisksinthediskgroupwillthenewvaluebeapplicable？（）

A.alldisksinthediskgroup

B.alldisksthatarecurrentlyinOFFLINEmode

C.alldisksthatarenotcurrentlyinOFFLINEmode

D.alldisksinthediskgrouponlyifallofthemareONLINE

A.It rejects statements that try to insert out-of-range values

B.It rejects invalid dates

C.It limits the operations that the server can perform

D.It rejects queries that produce out-of-range values

E.It rejects dates with zero day or month values

rvepoorperformancebetween10a.m.and11a.m.inthemiddleoftheweek.Howwouldyouidentifythechangesinconfigurationsettings，workloadprofile，andstatisticstodiagnosethepossiblecausesoftheperformancedegradation？（）

A.byusingtheSQLaccessadvisor

B.byusingtheAutomaticWorkloadRepositoryreport

C.byrunningtheAutomaticDatabaseDiagnosticMonitor（ADDM）

D.byusingtheAutomaticWorkloadRepositoryComparePeriodreport

E.byanalyzingtheoutputoftheV$ACTIVE_SESSION_HISTORYview

A.Thecommandfailsasatransactionisstillpending.

B.ThetransactioninScott’ssessionisrolledbackandthetablespacebecomesread-only.

C.ThecommandwaitsandtheuserSCOTTcanexecutedatamanipulationlanguage（DML）statementsonlyaspartofthecurrenttransaction.

D.Thecommandhangsuntilalltransactionsontheobjectsinthetablespacecommitorrollback，andthenthetablespaceisplacedinread-onlymode.

A. The SELECT statement is syntactically accurate.

B. The SELECT statement does not work because there is no HAVING clause.

C. The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.

D. The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.

Animportanttablespaceofyourdatabaseisdroppedbymistake.YouusetheFlashbackDatabasefeaturetoretrievethetablespace.Youperformthefollowingstepstoretrievethetablespace：

1.YoulogontoEnterpriseManagerasSYSDBA.

2.Youselectthemaintenancescreen.

3.YouchoosePerformRecoveryoptiononthemaintenancescreen.

4.YouchooseWholeDatabaseintheObjectTypedrop-downlistPerformRecovery：Typescreen.5.YouchooseRecovertoCurrentTimefromtheOperationTypeonthePerformRecovery：Typescreen.

6.YouprovidetheHostCredentialsforadatabaseuser.onthePerformRecovery：Typescreen.

7.Youclickthecontinuebutton.

Aninformationscreenappearssayingthatthedatabaseisunavailable.Whatisthisinformationscreen？（）

A.ThecommandmustbeissuedinMOUNTstate.

B.Thecommandsucceedsonlyifthedatafileisoffline.

C.Thecommandmustbeissuedwhenthedatabaseisinthearchivelogmode.

D.Thecommandsucceedsifnoextentinthetablespaceiscurrentlyallocatedabovethe150MBboundaryofthefile.

A.theportusedbythelistener

B.theprotocolusedbythelistener

C.theservernamewherethelistenerruns

D.thelogfileandtracefiledestinationforthelistener

E.thedatabaseservicestoberegisteredwiththelistener

A.whenatableisdroppedandyourestoreitfromtheRecycleBin

B.whenauser’sschemaisdroppedandyourecovertheuser’sschema

C.whensomeincorrectdataisinsertedinthetableandyouretrievethetabletoastatethatwasatacertaintimestamp

D.whenarowofatableisupdatedfrequentlyandcommitted，andyouviewalltheversionsoftherowwithinaspecificduration