CPU能够直接访问的存储器是()
A.软盘
B.硬盘
C.RAM
D.CD-ROM
第1题
A. The Memory Advisor
B. The SQL Tuning Advisor
C. The Undo Advisor
D. The SQL Access Advisor
第2题
A.Youperformedrollbackaftercommit.
B.Ifalogswitchoccursinyourdatabase.
C.Thearchiverfailstogenerateanarchivedlogfile.
D.Instancerecoveryfailstofindoneoftheredologfiles.
E.Along-runningqueryisunabletogetread-consistentimage.
F.Ifyouperformmanualundomanagementoperationsinautomode.
第3题
A.Starttheinstanceandopenthedatabase,instancerecoveryautomaticallyrecoverscontrolfiles
B.Createafilebasedonthecontentsofthetracefileandsaveittothecontrolfilelocationsandstartthedatabase
C.Re-createthedatabase(Therecoveryofthecontrolfileisnotpossiblebecauseyouhavelostallthecontrolfiles.)
D.Starttheinstance,intheNOMOUNTstate,re-createthecontrolfileusingtheCREATECONTROLFILEcommandstoredinthetracefile.
E.StarttheinstanceandMOUNTthedatabase,thenre-createthecontrolfileusingtheCREATECONTROLFILEcommandstoredinthetracefile.
第4题
A. No transaction on the tablespace is allowed but you can perform queries.
B. The tablespace will automatically come out of backup mode when the file copy is complete.
C. The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
D. The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.
第5题
A.1-c,2-b,3-d,4-a
B.1-b,2-c,3-d,4-a
C.1-a,2-b,3-c,4-d
D.1-a,2-b,3-d,4-c
第6题
A. Create a table view.
B. Create a view in any schema.
C. Create a view in your schema.
D. Create a sequence view in any schema.
E. Create a view that is accessible by everyone.
F. Create a view only of it is based on tables that you created.
第7题
A.Enableinstancefailover
B.Configuresharedserver
C.Enabledatabasefailover
D.Enableconnect-timefailover
E.EnableTransparentApplicationFailover(TAF)
第8题
A. Segment Advisor
B. SQL Access Advisor
C. Optimizer statistics gathering
D. Automatic SQL Tuning Advisor
E. Automatic Database Diagnostics Monitor
第9题
A.Monitorthealert.logfile
B.Enableserver-sideSQLtracingforusersessions
C.Enablefine-grainedauditingforthecustomertable
D.EnableFine-GrainedAccessControl(FGAC)forthecustomertable
E.WriteadatabasetriggeronthecustomertableontheSELECTevent
第10题
A. You cannot roll back this statement.
B. All pending transactions are committed.
C. All views based on the DEPT table are deleted.
D. All indexes based on the DEPT table are dropped.
E. All data in the table is deleted, and the table structure is also deleted.
F. All data in the table is deleted, but the structure of the table is retained.
G. All synonyms based on the DEPT table are deleted.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!