A.produced
B.staged
C.presented
D.released
第1题
A. Building the SQL profile
B. Recommending optimization of materialized views
C. Checking query objects for missing and stale statistics
D. Recommending bitmap, function-based, and B-tree indexes
E. Recommending restructuring SQL queries that are using bad plans
第2题
A.CONFIGUREDEFAULTDEVICETYPETOTAPEMEDIA
B.CONFIGUREDEFAULTDEVICETYPETOTAPE
C.CONFIGUREDEFAULTDEVICETYPETOSBT
D.CONFIGUREDEFAULTDEVICETYPETOSBT_TAPE
第3题
A.Thedatabaseautomaticallydeterminestheextent-sizingpolicyforthetablespace.
B.Thesegmentsareautomaticallyshrunkwhenthecontentsareremovedfromthem.
C.Theallocationofextentswithinthetablespaceismanagedthroughthedictionarytables.
D.Thespaceutilizationdescriptionofthedatablocksinsegmentsisrecordedinbitmapblocks.
E.Thespaceutilizationdescriptionofthedatablocksinsegmentsismanagedthroughfreelists.MANUAL
第4题
A.byusingOracleEnterpriseManager
B.byissuingtheFLASHBACKTABLEstatementattheRMANprompt
C.byissuingtheFLASHBACKTABLEstatementattheSQLprompt
D.byissuingtheFLASHBACKTABLEstatementattheLSNRCTLprompt
第5题
A.Comparethecontentsoftheinstall.logfilewiththeresponsefile.
B.RefertothecontentsoftheoraInst.locfiletoverifythestepsperformedbyOUI.
C.ComparethecontentsoftheinstallActions.logfilewiththatoftheresponsefile.
D.RefertothealertlogfileforinformationregardingtheactionsperformedbyOUIduringinstallation.
第6题
A.Channelfailover
B.Restartablebackups
C.Rescheduablebackups
D.Automaticbackuprecovery
E.Channelrecovery
第7题
A.Youmustuseautomaticundomanagementinthedatabase.
B.YoumustconfigureOMFinyourdatabase.
C.YoumustconfigureASMforstoringthedatafiles.
D.Youmustmultiplextheonlineredologfile.
第8题
A.Thetracefileisinbinaryformat.
B.ThetracefilehasaSQLscripttore-createthecontrolfile.
C.Thetracefileisabackupsetcreatedduringthebackupofthecontrolfile.
D.Thetracefilecontainstheinstructionstomanuallyre-createthecontrolfile.
E.Thetracefileisanimagecopyofthecontrolfilecreatedduringthebackupofthecontrolfile.
第9题
SELECToperation,undo_sql,logon_user
FROMFLASHBACK_TRANSACTION_QUERYWHERExid=
HEXTORAW(’0100043E23456’);
where’0100043E23456’isthetransactionIDofthetransactionthatdeletedtherow.Beforeissuingtheabovestatement,whichtaskdidWilliamperformtoidentifythetransactionIDofthetransactionthatdeletedtherow?()
第10题
A.
B.
C.
D. The query fails because the subquery returns more than one row.
E. The query fails because the outer query and the inner query are using different tables.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!