A.SharedSQLAreawillbeallocatedinthesharedpool.
B.SharedSQLAreawillbeallocatedwhenasessionstarts.
C.SharedSQLAreawillbeallocatedinthelargepoolalways.
D.ThewholeofPrivateSQLAreawillbeallocatedintheProgramGlobalArea(PGA)always.
E.SharedSQLAreaandPrivateSQLAreawillbeallocatedinthePGAorlargepool.
F.ThenumberofPrivateSQLAreaallocationsisdependentontheOPEN_CURSORSparameter.
第1题
llectedduringthisperiodsothattheycanbeusedforcomparisonwhileanalyzingtheperformanceofthedatabaseinthefuture.Whatactionwouldyoutaketoachievethistask?()
A.SettheSTATISTICS_LEVELinitializationparametertoALL.
B.Createabaselineonapairofsnapshotsthathavethestatisticsofthepeakloadperiodinthedatabase.
C.DecreasethesnapshotintervalintheAWRtocollectmorenumberofsnapshotsduringthepeakloadperiod.
D.SetthesnapshotretentionperiodintheAutomaticWorkloadRepository(AWR)tozerotoavoidtheautomaticpurgingofthesnapshots.
第2题
rvepoorperformancebetween10a.m.and11a.m.inthemiddleoftheweek.Howwouldyouidentifythechangesinconfigurationsettings,workloadprofile,andstatisticstodiagnosethepossiblecausesoftheperformancedegradation?()
A.byusingtheSQLaccessadvisor
B.byusingtheAutomaticWorkloadRepositoryreport
C.byrunningtheAutomaticDatabaseDiagnosticMonitor(ADDM)
D.byusingtheAutomaticWorkloadRepositoryComparePeriodreport
E.byanalyzingtheoutputoftheV$ACTIVE_SESSION_HISTORYview
第3题
ELOGmodeandtheLOG_ARCHIVE_DEST_1parameterisnotset.Whatwillbetheimplicationsonthearchivingandthelocationofarchiveredologfiles()
A.Archivingwillbedisabledbecausethedestinationfortheredologfilesismissing.
B.Thedatabaseinstancewillshutdownandtheerrordetailswillbeloggedinthealertlogfile.
C.ArchivingwillbeenabledandthedestinationforthearchivedredologfilewillbesettotheFlashRecoveryAreaimplicitly.
D.Archivingwillbeenabledandthelocationforthearchiveredologfilewillbecreatedinthedefaultlocation$ORACLE_HOME/log.
第4题
plementation of add(0, object), but does NOT need to support quick random access. What supports these requirements?()
A.java.util.Queue
B.java.util.ArrayList
C.java.util.LinearList
D.java.util.LinkedList
第5题
A.largepool
B.streamspool
C.keepbuffercache
D.recyclebuffercache
第6题
A. CREATE TABLE EMP9$# AS (empid number(2));
B. CREATE TABLE EMP*123 AS (empid number(2));
C. CREATE TABLE PACKAGE AS (packid number(2));
D. CREATE TABLE 1EMP_TEST AS (empid number(2));
第7题
A.recovertablespaceusersuntiltime,,10/06/2008:22:42:00auxiliary,,c\oracle\auxiliary
B.recovertablespaceuserstime,,10/06/2008:22:42:00auxiliarydestination,,c:\oracle\auxiliary;time,,10/06/2008:22:42:00auxiliarydestination,,c\oracle\auxiliary
C.recovertablespaceuserstopoint-in.
D.recovertablespaceusersexcepttime,,10/06/2008:22:42:00auxiliarydestination,,c:\oracle\auxiliary
E.recovertablespaceusersuntiltime,,10/06/2008:22:42:00auxiliarydestination,,c:\oracle\auxiliary
第8题
e.2. Choose columns from a table3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities? ()
A. difference, projection, join
B. selection, projection, join
C. selection, intersection, join
D. intersection, projection, join
E. difference, projection, product
第9题
A. It is loaded with the FIXED status.
B. It is loaded with the ACCEPTED status.
C. It is not loaded with the ENABLED status.
D.It is not loaded with the ACCEPTED status.
第10题
A.Committingatransaction
B.Flashingbackatransaction
C.Recoveringafailedtransaction
D.Runningaread-consistentquery
E.ChangingatablespacestatusfromREADONLYtoREADWRITE
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!