网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?()
A

Database replay

B

SQL Tuning Advisor

C

SQL Access Advisor

D

SQL Performance Analyzer

E

Automatic Workload Repository compare reports


参考答案

参考解析
解析: 暂无解析
更多 “单选题Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?()A Database replayB SQL Tuning AdvisorC SQL Access AdvisorD SQL Performance AnalyzerE Automatic Workload Repository compare reports” 相关考题
考题 Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this?()A. Database replayB. SQL Tuning AdvisorC. SQL Access AdvisorD. SQL Performance AnalyzerE. Automatic Workload Repository compare reports

考题 You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature?()A、 You must use automatic undo management in the database.B、 You must configure OMF in your database.C、 You must configure ASM for storing the datafiles.D、 You must multiplex the online redo log file.

考题 You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database.  What should you do?()A、Implement a stored procedure that writes data about schema changes to a log table.B、Implement DDL AFTER triggers that write user and schema information to a log table.C、Implement a DML INSTEAD OF trigger that writes data about schema changes to a log table.D、Implement a DML AFTER trigger that writes data about schema changes to a log table.

考题 In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance?()A、heap tableB、object tableC、external tableD、clustered tableE、global temporary tableF、index­organized table (IOT)

考题 While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following:  a) high availability of data  b) faster primary key access to the table data  c) compact storage for the table  Which type of tables would you use to achieve these objectives?()A、heap tablesB、object tablesC、partitioned tablesD、index­organized tables (IOTs)

考题 Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache. What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?()A、Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.B、Run the Automatic Workload Repository Monitor (ADDM).C、Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.D、Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

考题 You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()A、 VERSIONS_STARTSCNB、 VERSIONS_STARTTIMEC、 VERSIONS_XIDD、 VERSIONS_OPERATION

考题 You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?()A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

考题 In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance?()A、heap tableB、object tableC、external tableD、clustered tableE、global temporary tableF、index-organized table (IOT)

考题 Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?()A、Database replayB、SQL Tuning AdvisorC、SQL Access AdvisorD、SQL Performance AnalyzerE、Automatic Workload Repository compare reports

考题 In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective?()A、REBUILDB、CASCADEC、TRUNCATED、ROW MOVEMENTE、SHRINK SPACE COMPACTF、SHRINK SPACE CASCADE

考题 At 10:30 A.M., you ran a batch job by mistake, which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11:10 A.M., you stopped the batch job. Now, you want to identify the changes made to the database tables by the batch job. Which view will you query?()A、 DBA_PENDING_TRANSACTIONSB、 DBA_AUDIT_STATEMENTC、 V$FLASHBACK_DATABASE_STATSD、 FLASHBACK_TRANSACTION_QUERY

考题 单选题At 10:30 A.M., you ran a batch job by mistake, which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11:10 A.M., you stopped the batch job. Now, you want to identify the changes made to the database tables by the batch job. Which view will you query?()A  DBA_PENDING_TRANSACTIONSB  DBA_AUDIT_STATEMENTC  V$FLASHBACK_DATABASE_STATSD  FLASHBACK_TRANSACTION_QUERY

考题 单选题You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()A  VERSIONS_STARTSCNB  VERSIONS_STARTTIMEC  VERSIONS_XIDD  VERSIONS_OPERATION

考题 单选题You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?()A Use the CREATE DATABASE .. command to create the database with Oracle-managed files. B Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. E Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

考题 单选题In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective?()A  REBUILDB  CASCADEC  TRUNCATED  ROW MOVEMENTE  SHRINK SPACE COMPACTF  SHRINK SPACE CASCADE

考题 单选题Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?()A Database replayB SQL Tuning AdvisorC SQL Access AdvisorD SQL Performance AnalyzerE Automatic Workload Repository compare reports

考题 单选题You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature?()A  You must use automatic undo management in the database.B  You must configure OMF in your database.C  You must configure ASM for storing the datafiles.D  You must multiplex the online redo log file.

考题 单选题You create a Web application. The Web application enables users to change fields in their personal profiles. Some of the changes are not persisting in the database. You need to raise a custom event to track each change that is made to a user profile so that you can locate the error. Which event should you use? ()A WebAuditEventB WebEventManagerC WebBaseEventD WebRequestEvent

考题 单选题In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance?()A  Heap tableB  Object tableC  External tableD  Clustered tableE  Global temporary tableF  Index-organized table (IOT)

考题 单选题You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database.  What should you do?()A Implement a stored procedure that writes data about schema changes to a log table.B Implement DDL AFTER triggers that write user and schema information to a log table.C Implement a DML INSTEAD OF trigger that writes data about schema changes to a log table.D Implement a DML AFTER trigger that writes data about schema changes to a log table.

考题 单选题Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?()A Database replayB SQL Tuning AdvisorC SQL Access AdvisorD SQL Performance AnalyzerE Automatic Workload Repository compare reports

考题 单选题In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance?()A heap tableB object tableC external tableD clustered tableE global temporary tableF index­organized table (IOT)

考题 单选题In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance?()A heap tableB object tableC external tableD clustered tableE global temporary tableF index-organized table (IOT)

考题 单选题While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following:  a) high availability of data  b) faster primary key access to the table data  c) compact storage for the table  Which type of tables would you use to achieve these objectives?()A heap tablesB object tablesC partitioned tablesD index-organized tables (IOTs)

考题 单选题Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache. What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?()A Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.B Run the Automatic Workload Repository Monitor (ADDM).C Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.D Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

考题 单选题In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective?()A REBUILDB CASCADEC TRUNCATED ROW MOVEMENTE SHRINK SPACE COMPACTF SHRINK SPACE CASCADE

考题 单选题While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following:  a) high availability of data  b) faster primary key access to the table data  c) compact storage for the table  Which type of tables would you use to achieve these objectives?()A  heap tablesB  object tablesC  partitioned tablesD  index-organized tables (IOTs)