单选题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 perfo

题目
单选题
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

相似考题

1.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

2. 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.

3. 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）

4.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.

更多“单选题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 perfo”相关问题

  • 第1题：

    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 tables
    • B、object tables
    • C、partitioned tables
    • D、index­organized tables （IOTs）

    正确答案:D

  • 第2题：

    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_STARTSCN
    • B、 VERSIONS_STARTTIME
    • C、 VERSIONS_XID
    • D、 VERSIONS_OPERATION

    正确答案:C

  • 第3题：

    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 table
    • B、object table
    • C、external table
    • D、clustered table
    • E、global temporary table
    • F、index-organized table （IOT）

    正确答案:A

  • 第4题：

    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、REBUILD
    • B、CASCADE
    • C、TRUNCATE
    • D、ROW MOVEMENT
    • E、SHRINK SPACE COMPACT
    • F、SHRINK SPACE CASCADE

    正确答案:E

  • 第5题：

    单选题
    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_TRANSACTIONS

    B

     DBA_AUDIT_STATEMENT

    C

     V$FLASHBACK_DATABASE_STATS

    D

     FLASHBACK_TRANSACTION_QUERY


    正确答案： C
    解析： 暂无解析

  • 第6题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第7题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    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

    WebAuditEvent

    B

    WebEventManager

    C

    WebBaseEvent

    D

    WebRequestEvent


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    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 table

    B

    object table

    C

    external table

    D

    clustered table

    E

    global temporary table

    F

    index­organized table （IOT）


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    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 tables

    B

    object tables

    C

    partitioned tables

    D

    index-organized tables （IOTs）


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    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

    REBUILD

    B

    CASCADE

    C

    TRUNCATE

    D

    ROW MOVEMENT

    E

    SHRINK SPACE COMPACT

    F

    SHRINK SPACE CASCADE


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:D

  • 第14题：

    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.

    正确答案:D

  • 第15题：

    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

    正确答案:E

  • 第16题：

    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_TRANSACTIONS
    • B、 DBA_AUDIT_STATEMENT
    • C、 V$FLASHBACK_DATABASE_STATS
    • D、 FLASHBACK_TRANSACTION_QUERY

    正确答案:D

  • 第17题：

    单选题
    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_STARTSCN

    B

     VERSIONS_STARTTIME

    C

     VERSIONS_XID

    D

     VERSIONS_OPERATION


    正确答案： A
    解析： 暂无解析

  • 第18题：

    单选题
    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

     REBUILD

    B

     CASCADE

    C

     TRUNCATE

    D

     ROW MOVEMENT

    E

     SHRINK SPACE COMPACT

    F

     SHRINK SPACE CASCADE


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    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 table

    B

     Object table

    C

     External table

    D

     Clustered table

    E

     Global temporary table

    F

     Index-organized table （IOT）


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    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 table

    B

    object table

    C

    external table

    D

    clustered table

    E

    global temporary table

    F

    index-organized table （IOT）


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    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 tables

    B

     object tables

    C

     partitioned tables

    D

     index-organized tables （IOTs）


    正确答案： B
    解析： 暂无解析

相关内容