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.

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.

相关考题：

What's ( )job? Are ( ) British?A. your, yourB. you, yourC. your, you
查看答案
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’%
查看答案
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
查看答案
Youexecutedthefollowingcommandtostartthedatabase：SQLSTARTUPORACLEinstancestarted.TotalSystemGlobalArea281018368bytesFixedSize789000bytesVariableSize229635576bytesDatabaseBuffers50331648bytesRedoBuffers262144bytesORA-00205：errorinidentifyingcontrolfile，checkalertlogformoreinfoWhichviewwouldyouqueryatthisstagetoinvestigatethismissingcontrolfile？（）A.V$INSTANCEB.V$CONTROLFILEC.DBA_CONTROL_FILESD.V$DATABASE_PROPERTIESE.V$CONTROLFILE_RECORD_SECTION
查看答案
At10：30A.M.，youranabatchjobbymistake，whichexecutedatransactioninthedatabase.Thetransactionidentifierofthetransactionthatmadetothechangesinthedatabaseis0500A00627B000.At11：10A.M.，youstoppedthebatchjob.Now，youwanttoidentifythechangesmadetothedatabasetablesbythebatchjob.Whichviewwillyouquery？（）A.DBA_PENDING_TRANSACTIONSB.DBA_AUDIT_STATEMENTC.V$FLASHBACK_DATABASE_STATSD.FLASHBACK_TRANSACTION_QUERY
查看答案
YouworkasadatabaseadministratorforCertkiller.com.Inyourdevelopmentenvironmentenvironment，thedevelopersareresponsibleformodifyingthetablestructureaccordingtotheapplicationrequirements.However，youwanttokeeptrackoftheALTERTABLEcommandsbeingexecutedbydevelopers，soyouenableauditingtoachievethisobjective.Whichtwoviewswouldyourefertofindouttheauditinformation？（）A.DBA_AUDIT_TRAILB.DBA_AUDIT_SESSIONC.DBA_FGA_AUDIT_TRAILD.DBA_COMMON_AUDIT_TRAIL
查看答案
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 PFEC.The Routing Engine is hot-pluggable.D.The Routing Engine controls the PFE
查看答案
当需要查询段的详细信息,可以使用如下()数据字典视图。 A.DBA_SEGMENTSB.ALL_SEGMENTSC.USER_SEGMENTS
查看答案
当需要查询用户的表空间限额时,可以使用如下()数据字典视图。 A.DBA_USERSB.ALL_USERSC.DBA_TS_QUOTASD.USER_PASSWORD_LIMITS
查看答案
在Oracle数据字典视图中,()视图存储了数据库中所有对象的信息。 A.dba_*B.user_*C.all_*D.sys_*
查看答案
热门标签