多选题Which three statements are true about Automatic Workload Repository (AWR)?()AAll AWR tables belong to the SYSTEM schema.BThe AWR data is stored in memory and in the database.CThe snapshots collected by AWR are used by the self-tuning components in the databaseDAWR 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.EAWR 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.


参考解析

解析: 暂无解析

相关考题:

Which two statements about workload capture and replay operations are true?() A. The clients must be created manually on the test machines to perform more realistic testing.B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

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 two statements about NTP version 4 are true?()A、It supports fast synchronization at starting and before network failuresB、It supports automatic server discoveryC、It uses a fixed-point arithmetionD、It supports the "nanokernel" kernel implementationE、It does not support Public-Key Cryptography

Which of these statements is true about ssids configured in cisco adu?()A、ssids are not case-sensitive.B、ssids must be listed in the same order in the adu as they are in the access point.C、a maximum of three ssids may be configured.D、ssids may have a maximum of 16 characters.

Which three statements about Label-Switched Paths (LSPs) are true? ()A、 LSPs are bidirectional.B、 LSPs are unidirectional.C、 LSPs can be signaled by CAC.D、 LSPs can be configured explicitly.E、 LSPs can be configured dynamically.

Which three statements are true about terms in a policy?()A、The order of the terms in a policy is irrelevantB、The action is specified in a then statementC、Ters are optional in a policyD、The match condition can be identified with a from statementE、Every policy must contain at least one term

Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)()A、The ADDM requires at least four AWR snapshots for analysis.B、The ADDM runs after each AWR snapshot is collected automatically by MMON.C、The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR).D、The ADDM analysis provides only diagnostic information but does not provide recommendations.E、The ADDM calls other advisors if required, but does not provide recommendations about the advisors.

Which three statements about performance analysis by SQL Performance Analyzer are true? ()A、It detects changes in SQL execution plans.B、It produces results that can be used to create the SQL plan baseline.C、The importance of SQL statements is based on the size of the objects accessed.D、It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.E、It shows only the overall impact on workload and not the net SQL impact on workload.

Which three statements about performance analysis by SQL Performance Analyzer are true? ()(Choose three.)A、It detects changes in SQL execution plans.B、It produces results that can be used to create the SQL plan baseline.C、The importance of SQL statements is based on the size of the objects accessed.D、It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.E、It shows only the overall impact on workload and not the net SQL impact on workload.

Which three statements are true about terms in a policy?()A、The order of the terms in a policy is irrelevant.B、The action is specified in a then statement.C、Terms are optional in a policy.D、The match condition can be identified with a from statement.E、A from statement is mandatory in a term.

Which three statements are true about EIGRP operation?()A、When summarization is configured, the router will also create a route to null 0.B、The summary route remains in the route table, even if there are no more specific routes to the network.C、Summarization is configured on a per- interface level.D、The maximum metric for the specific routes is used as the metric for the summary route.E、Automatic summarization across major network boundaries is enabled by default.

Which three statements are true about Source Specific Multicast?()A、Is best suited for applications that are in the one-to-many category.B、SSM uses shortest path trees only.C、The use of SSM is recommended when there are many sources and it is desirable to keep the amount of mroute state in the routers in the network to a.D、There are no RPs to worry about.

Which IBM Tivoli Workload Scheduler report will provide the job  history?()A、 rep2B、 rep3C、 rep7D、 rep8

Which two statements are true about the Automatic Workload Repository (AWR)()A、All AWR tables belong to the SYSTEM schema.B、The AWR contains systemwide tracing and logging information.C、The snapshots collected by the AWR are accessible through data dictionary views.D、The snapshots collected by the AWR are used by self-tuning components in the database.

Which two statements about Automatic Storage Management (ASM) are true?()A、ASM provides mirroring on file by file basis.B、ASM provides automatic load balancing across all ASM disks.C、ASM supports the Oracle database and operating system files.D、ASM can be used to store trace files, alert log files, and the server parameter file (SPFILE).

Which three statements about subqueries are true? ()A、Asinglerowsubquerycanretrieveonlyonecolumnandonerow.B、Asinglerowsubquerycanretrieveonlyonerowbutmanycolumns.C、Amultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.D、Amultiplerowsubquerycanbecomparedusingthe";;";operator.E、AsinglerowsubquerycanusetheINoperator.F、Amultiplerowsubquerycanusethe";=";operator.

多选题Which three statements about Label-Switched Paths (LSPs) are true? ()ALSPs are bidirectional.BLSPs are unidirectional.CLSPs can be signaled by CAC.DLSPs can be configured explicitly.ELSPs can be configured dynamically.

多选题Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)()AThe ADDM requires at least four AWR snapshots for analysis.BThe ADDM runs after each AWR snapshot is collected automatically by MMON.CThe results of the ADDM analysis are stored in the Automatic Workload Repository (AWR).DThe ADDM analysis provides only diagnostic information but does not provide recommendations.EThe ADDM calls other advisors if required, but does not provide recommendations about the advisors.

多选题Which of the following statements about variables and scope are true?()ALocal variables defined inside a method are destroyed when the method is exited.BLocal variables are also called automatic variables.CVariables defined outside a method are created when the object is constructed.DA method parameter variable continues to exist for as long as the object is needed in which the method is defined.

单选题Which IBM Tivoli Workload Scheduler report will provide the job  history?()A rep2B rep3C rep7D rep8

单选题Which of these statements is true about ssids configured in cisco adu?()Assids are not case-sensitive.Bssids must be listed in the same order in the adu as they are in the access point.Ca maximum of three ssids may be configured.Dssids may have a maximum of 16 characters.

多选题Which three statements are true about terms in a policy?()AThe order of the terms in a policy is irrelevantBThe action is specified in a then statementCTers are optional in a policyDThe match condition can be identified with a from statementEEvery policy must contain at least one term

多选题Which three statements about performance analysis by SQL Performance Analyzer are true? ()(Choose three.)AIt detects changes in SQL execution plans.BIt produces results that can be used to create the SQL plan baseline.CThe importance of SQL statements is based on the size of the objects accessed.DIt generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.EIt shows only the overall impact on workload and not the net SQL impact on workload.

多选题Which three statements about subqueries are true? ()AAsinglerowsubquerycanretrieveonlyonecolumnandonerow.BAsinglerowsubquerycanretrieveonlyonerowbutmanycolumns.CAmultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.DAmultiplerowsubquerycanbecomparedusingthe;;;operator.EAsinglerowsubquerycanusetheINoperator.FAmultiplerowsubquerycanusethe;=;operator.

多选题Which two statements about NTP version 4 are true?()AIt supports fast synchronization at starting and before network failuresBIt supports automatic server discoveryCIt uses a fixed-point arithmetionDIt supports the nanokernel kernel implementationEIt does not support Public-Key Cryptography

多选题Which three statements about performance analysis by SQL Performance Analyzer are true? ()AIt detects changes in SQL execution plans.BIt produces results that can be used to create the SQL plan baseline.CThe importance of SQL statements is based on the size of the objects accessed.DIt generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.EIt shows only the overall impact on workload and not the net SQL impact on workload.

多选题Which two statements about workload capture and replay operations are true?()AThe clients must be created manually on the test machines to perform more realistic testing.BRestart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.CRestart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.DThe application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

多选题Which two statements are true about the Automatic Workload Repository (AWR)()AAll AWR tables belong to the SYSTEM schema.BThe AWR contains systemwide tracing and logging information.CThe snapshots collected by the AWR are accessible through data dictionary views.DThe snapshots collected by the AWR are used by self-tuning components in the database.