A. DROP emp_dept_uv;
B. DELETE emp_dept_uv;
C. REMOVE emp_dept_uv;
D. DROP VIEW emp_dept_uv;
E. DELETE VIEW emp_dept_uv;
F. REMOVE VIEW emp_dept_uv;
第1题
A. It can be set at the system, session, or table level.
B. It is used only across statements in the same session.
C. It can store the results from normal as well as flashback queries.
D. It can store the results of queries based on normal, temporary, and dictionary tables.
第2题
A.Line 5
B.Line 6
C.Line 7
D.Line 8
E.Line 9
F.Line 10
第3题
venbelowarethestepstoaccomplishthetaskinrandomorder:1.Shutdowntheinstance.2.ExecutetheALTERDATABASEARCHIVELOGcommand.3.Startuptheinstanceandmountthedatabase.4.SettheDB_RECOVERY_FILE_DESTinitializationparameterto$ORACLE_HOME/dest_1.5.Openthedatabase.Whichisthecorrectsequenceofstepsforaccomplishingthetask()
A.4,1,3,2,5
B.1,3,4,5,2
C.1,3,2,5;4notrequired
D.4,1,5,2;3notrequired
E.1,3,4,5;2notrequired
第4题
A. It produces less accurate results of the comparison analysis.
B. It automatically calls the SQL Tuning Advisor for recommendations.
C. It shortens the time of execution and reduces the impact on system resources.
D. Only the changes in the execution plan, and not performance regression, are detected.
第5题
oshrinktheTRANStableexistingontheUSERStablespace:SQL>ALTERTABLEtransSHRINKSPACECASCADE;Whichobjectswouldbeaffectedbythiscommand?()
A.theTRANStable
B.theB*TreeindexesontheTRANStable
C.thematerializedviewslogoftheTRANStable
D.thematerializedviewsbasedontheTRANStable
E.thelargeobject(LOB)segmentsoftheTRANStable
第6题
setto900seconds.Youexecutedthefollowingcommandtoenableretentionguarantee:SQL>ALTERTABLESPACEundotbs1RETENTIONGUARANTEE;Whateffectwouldthiscommandhaveonthedatabase()
A.Theextentsintheundotablespaceretaindatauntilthenextfulldatabasebackup.
B.Theextentscontainingcommittedundointheundotablespacearenotoverwrittenforatleast15minutes.
C.Theextentscontainingcommitteddataintheundotablespacearenotoverwrittenuntiltheinstanceisshutdown.
D.TheextentscontainingcommittedundointheundotablespacearetransferredtoFlashRecoveryAreabeforebeingoverwritten
第7题
se. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?()
A.Every SQL statement in the STS is considered only once for execution
B.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics
C.The execution plan and execution statistics are computed for each SQL statement in the STS
D.The effects of DDL and DML are considered to produce the execution plan and execution statistics
第8题
ndstocompetethistask?()a.restorecontrolfileuntiltime`09/30/2008:18:00:00’b.restoredatabaseuntiltime`09/30/2008:18:00:00’c.restorespfileuntiltime`09/30/2008:18:00:00’d.recoverdatabaseuntiltime`09/30/2008:18:00:00’e.alterdatabaseopenresetlogsf.alterdatabaseopen
A.b,d,e
B.b,d,f
C.c,a,b,d,e
D.c,a,b,d,f
E.a,b,d,e
第9题
atabaseinstanceisstartedanddatabaseisopened:1.SGAisallocated.2.Controlfileisread.3.Redologfilesareopened.4.Instancerecoveryisstarted.5.Backgroundprocessesarestarted.6.Datafileheadersarecheckedforconsistency.7.Serverparameterfileortheinitializationparameterfileisread.Whichoptionhasthecorrectorderinwhichthesestepsoccur()
A.7,1,5,2,3,6,4
B.1,5,7,2,3,6;step4isnotrequired
C.7,1,5,2,3,6;step4isnotrequiredThisdocumentwasdownloadedfrom=>>http://www.amaderforum.com
D.1,2,3,5,6,4;step7isnotrequired
第10题
A. The RDBMSs connected will shutdown abort too
B. CLUSTER SERVICE will shutdown
C. ASM wil do instance recovery after startup
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!