You are connected to a pluggable database (PDB) as a common user with DBA privileges.The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;Which is true about the

题目

You are connected to a pluggable database (PDB) as a common user with DBA privileges.The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;Which is true about the result of this command?（）

A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.

B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.

C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.

D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

相似考题

1.What's ( )job? Are ( ) British?A. your, yourB. you, yourC. your, you

2.Which Scheduler view(s) can be queried to see which jobs are currently executing? ()A. DBA_SCHEDULER_JOB_RUN_DETAILSB. DBA_SCHEDULER_RUNNING_JOBS DBAC. DBA_SCHEDULER_CURRENT_JOBSD. DBA_SCHEDULER_JOBS DBAE. DBA_SCHEDULER_EXECUTING_JOBS

3.Youexecutedthefollowingcommandtostartthedatabase：SQL>STARTUPORACLEinstancestarted.TotalSystemGlobalArea281018368bytesFixedSize789000bytesVariableSize229635576bytesDatabaseBuffers50331648bytesRedoBuffers262144bytesORA-00205：errorinidentifyingcontrolfile，checkalertlogformoreinfoWhichviewwouldyouqueryatthisstagetoinvestigatethismissingcontrolfile？（）A.V$INSTANCEB.V$CONTROLFILEC.DBA_CONTROL_FILESD.V$DATABASE_PROPERTIESE.V$CONTROLFILE_RECORD_SECTION

4.Everypageofyourwebsitemustincludeacommonsetofnavigationmenusatthetopofthepage.ThismenuisstaticHTMLandchangesfrequently，soyouhavedecidedtouseJSP’sstaticimportmechanism.WhichJSPcodesnippetaccomplishesthisgoal？（）A.<%@importfile=’/common/menu.html’%>B.<%@pageimport=’/common/menu.html’%>C.<%@importpage=’/common/menu.html’%>D.<%@includefile=’/common/menu.html’%>E.<%@pageinclude=’/common/menu.html’%>

更多“You are connected to a pluggable database (PDB) as a common user with DBA privileges.The S ”相关问题

  • 第1题：

    At10：30A.M.，youranabatchjobbymistake，whichexecutedatransactioninthedatabase.Thetransactionidentifierofthetransactionthatmadetothechangesinthedatabaseis0500A00627B000.At11：10A.M.，youstoppedthebatchjob.Now，youwanttoidentifythechangesmadetothedatabasetablesbythebatchjob.Whichviewwillyouquery？（）

    A.DBA_PENDING_TRANSACTIONS

    B.DBA_AUDIT_STATEMENT

    C.V$FLASHBACK_DATABASE_STATS

    D.FLASHBACK_TRANSACTION_QUERY


    参考答案：D

  • 第2题：

    Which two statements regarding JUNOS architecture are correct?()

    A.The Routing Engine handles all exception traffic.

    B.The Routing Engine synchronizes the route table with the PFE

    C.The Routing Engine is hot-pluggable.

    D.The Routing Engine controls the PFE


    参考答案：C, D

  • 第3题：

    当需要查询用户的表空间限额时,可以使用如下()数据字典视图。

    A.DBA_USERS

    B.ALL_USERS

    C.DBA_TS_QUOTAS

    D.USER_PASSWORD_LIMITS


    参考答案：C

  • 第4题：

    YouworkasadatabaseadministratorforCertkiller.com.Inyourdevelopmentenvironmentenvironment，thedevelopersareresponsibleformodifyingthetablestructureaccordingtotheapplicationrequirements.However，youwanttokeeptrackoftheALTERTABLEcommandsbeingexecutedbydevelopers，soyouenableauditingtoachievethisobjective.Whichtwoviewswouldyourefertofindouttheauditinformation？（）

    A.DBA_AUDIT_TRAIL

    B.DBA_AUDIT_SESSION

    C.DBA_FGA_AUDIT_TRAIL

    D.DBA_COMMON_AUDIT_TRAIL


    参考答案：A, C

  • 第5题：

    当需要查询段的详细信息,可以使用如下()数据字典视图。

    A.DBA_SEGMENTS

    B.ALL_SEGMENTS

    C.USER_SEGMENTS


    参考答案：A, B, C

  • 第6题：

    在Oracle数据字典视图中,()视图存储了数据库中所有对象的信息。

    A.dba_*

    B.user_*

    C.all_*

    D.sys_*


    参考答案：A

相关内容