Which three statements are true about Automatic Workload Repository (AWR)?() A. All AWR tables belong to the SYSTEM schema.B. The AWR data is stored in memory and in the database.C. The snapshots collected by AWR are used by the self-tuning components in the databaseD. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.E. AWR contains system wide tracing and logging information.
Which three statements are true about Automatic Workload Repository (AWR)?()
A. All AWR tables belong to the SYSTEM schema.
B. The AWR data is stored in memory and in the database.
C. The snapshots collected by AWR are used by the self-tuning components in the database
D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
E. AWR contains system wide tracing and logging information.
相关考题：
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）A. The collection level for the AWR should be set to BASICB. The moving window size must be less than Undo RetentionC. The moving window size should be greater than the Automatic Workload Repository (AWR) retention periodD. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
Inyourdatabase,theSTATISTICS_LEVELinitializationparameterissettoBASIC.Whatistheimpactofthissetting?() A.Theoptimizerstatisticsarecollectedautomatically.B.Onlythetimedoperatingsystem（OS）statisticsandplanexecutionstatisticsarecollected.C.TheOracleserverdynamicallygeneratesthenecessarystatisticsontablesaspartofqueryoptimization.D.ThesnapshotsfortheAutomaticWorkloadRepository（AWR）arenotgeneratedautomatically.E.SnapshotscannotbecollectedmanuallybyusingDBMS_WORKLOAD_REPOSITORYPACKAGE.
inyourdatabaseinstance,theSTATISTICS_LEVELinitializationparameterissettoBASIC.Whatistheimpactofthissetting() A.Optimizerstatisticsarecollectedautomatically.B.Onlytimedoperatingsystem（OS）statisticsandplanexecutionstatisticsarecollected.C.ThesnapshotsfortheAutomaticWorkloadRepository（AWR）arenotgeneratedautomatically.D.SnapshotscannotbecollectedmanuallybyusingtheDBMS_WORKLOAD_REPOSITORYpackage.E.TheOracleserverdynamicallygeneratesthenecessarystatisticsontablesaspartofqueryoptimization.
YouworkasadatabaseadministratorforSupportcenter.cn.YouhavesettheretentionperiodforAutomaticRepository（AWR）statisticstofourdaysandcollectionintervalto15minutes.YouwanttoviewthestatisticscollectedandstoredinAWRsnapshot.WhichtwomethodswouldyouusetoviewtheAWRstatistics？（）A.useenterprisemanagerB.useDBMS_SQLpackageC.useDBMS_AWRpackageD.usePRVT_WORKLOADpackageE.querytheAWRsnapshotrepositoryobjectsF.useDBMS_WORKLOAD_REPOSITORYpackage
Thefollowingcommandisexecutedtocreatethebaselinetemplate：SQLEXECUTEDBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE（START_TIME=TO_TIESTAMP（SYSDATE+2），END_TIME=TO_TIMESTAMP（SYSDATE+10），BASELINE_NAME=’Mybase4’，TEMPLATE_NAME=’Mytemp4’，EXPIRATION=NULL）；Whichstatementistrueabouttheeffectoftheabovecommand？（）A.Itcreatesabaselinetemplatethatneverexpires.B.Itproducesanerrorbecausenosnapshotinformationisprovidedtocreatethebaseline.C.ItcreatesabaselinetemplatethatexpiresaftertheAutomaticWorkloadRepository（AWR）retentionperiod.D.ItcreatesarepeatingbaselinetemplatethatrepeatsaftertheAutomaticWorkloadRepository （AWR）retentionperiod.
Youhavecreatedabaselinemetric，DISK_IO_BL，forthediskI/OmetricsinyourPRODdatabaseandyouhavebeengettingnotificationswheneverthedatabaseperformancedegrades.YouoptimizethedatabaseI/Otogaintheperformanceandyoudecidetoremovethebaselinemetrics.WhichmethodwouldyouusetoremovetheDISK_IO_BLbaselinemetrics？（）A.Thebaseline，oncecreated，cannotberemoved.B.DisablethebaselinemetricsintheDatabaseControlManageMetricspage.C.Thebaselinewillbeautomaticallyremovedoncethedatabaseperformancehasbeenoptimized.D.DropthebaselinemetricsbyusingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINEprocedure.
YouworkasadatabaseadministratorforCertkiller.com.YouhavesettheretentionperiodforAutomaticRepository（AWR）statisticstofourdaysandcollectionintervalto15minutes.YouwanttoviewthestatisticscollectedandstoredinAWRsnapshot.WhichtwomethodswouldyouusetoviewtheAWRstatistics？（）A.useenterprisemanagerB.useDBMS_SQLpackageC.useDBMS_AWRpackageD.usePRVT_WORKLOADpackageE.querytheAWRsnapshotrepositoryobjectsF.useDBMS_WORKLOAD_REPOSITORYpackage
oracle数据库中STATISTICS_LEVEL参数被设置为BASIC,此设置的影响?() A.只有操作系统的时间和执行计划执行的统计信息被收集B.手动无法执行DBMS_WORKLOAD_REPOSITORY生成snapshotC.数据库自动收集需要表的统计信息为优化器使用D.awr资料库的snapshot不会自动生成E.优化器自动收集统计信息
Despitethewonderfulactingandwell-developedplotthe_________moviecouldnotholdourattention.A)three-hoursB)three-hourC)three-hours’D)three-hour’s
Which functionality is required within an IP router that is situated at the boundary of an IPv4 network and an IPv6 network to allow communication between IPv6－ only and IPv4 － only nodes?() A. AutoconfigurationB. Automatic 6to4 TunnelC. Automatic 6to4 RelayD. Network Address Translator - Protocol Translator (NAT - PT)E. Intrasite Automatic T unnel Address Protocol (ISATAP)