niusouti.com

单选题You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated 

题目
单选题
You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area.  Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）
A

perform point­in­time recovery

B

perform a Flashback Table operation to restore the table to the state it was in two days ago 

C

perform a Flashback Database operation to restore the database to the state it was in two days ago

D

perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery

相似考题

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 administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?（）A、Increase the value of the ASM_POWER_LIMIT parameter.B、Set the DISK_REPAIR_TIME disk attribute to a lower value.C、Specify the statement that adds the disk back to the disk group.D、Increase the number of ASMB processes.E、Increase the number of DBWR_IO_SLAVES in the ASM instance.

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 are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.You want the package to execute automatically each evening at 8:00 P.M. What should you do?A．Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.B．Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.C．Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system accountD．Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.

更多“You are working in an online transaction processing （OLTP） e”相关问题

  • 第1题：

    When a system has both online transaction processing as well as large batch processing， which of the following common procedures will best help to improve system performance？（）

    • A、 Boost the priority of batch jobs.
    • B、 Schedule batch runs to reduce contention with OLTP.
    • C、 Schedule OS maintenance such that it includes frequent application of PTFs.
    • D、 Perform incremental backups of transaction processing and full backups of batch processing.

    正确答案:B

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    You design a Business Intelligence （BI） solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services （SSAS） database. A cube in the database contains a large dimension named Customers. The database uses a data source that is located on a remote server. Each day， an application adds millions of fact rows and thousands of new customers. Currently， a full process of the cube takes several hours. You need to ensure that queries return the most recent customer data with the minimum amount of latency. Which cube storage model should you use？（）

    • A、 hybrid online analytical processing （HOLAP）
    • B、 relational online analytical processing （ROLAP）
    • C、 multidimensional online analytical processing （MOLAP）
    • D、 automatic multidimensional online analytical processing （automatic MOLAP）

    正确答案:A

  • 第5题：

    多选题
    You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?（）
    A

    Increase the value of the ASM_POWER_LIMIT parameter.

    B

    Set the DISK_REPAIR_TIME disk attribute to a lower value.

    C

    Specify the statement that adds the disk back to the disk group.

    D

    Increase the number of ASMB processes.

    E

    Increase the number of DBWR_IO_SLAVES in the ASM instance.


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

  • 第6题：

    单选题
    You are working on an online transaction processing （OLTP） system. You notice that a PL/SQL procedure got executed twice at 2） 00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2） 00 p.m.？（）
    A

    Perform point-in-time recovery to 2： 00 p.m.

    B

    Use Flashback Table feature to revert the changes.

    C

    Restore the entire database from the recent backup and open it.

    D

    Issue the rollback statement with system change number （SCN）.


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

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    You work as a database administrator at Certkiller .com. You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEEStable. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）
    A

     perform point-in-time recovery

    B

     perform a Flashback Table operation to restore the table to the state it was in two days ago

    C

     perform a Flashback Database operation to restore the database to the state it was in two days ago

    D

     perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery


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

  • 第9题：

    单选题
    You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）
    A

    Restore the backup control file and open the database with RESETLOGS option.

    B

    Perform point-in-time recovery because flashback cannot be performed again on this table

    C

    Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571

    D

    Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571


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

  • 第10题：

    单选题
    When a system has both online transaction processing as well as large batch processing， which of the following common procedures will best help to improve system performance？（）
    A

     Boost the priority of batch jobs.

    B

     Schedule batch runs to reduce contention with OLTP.

    C

     Schedule OS maintenance such that it includes frequent application of PTFs.

    D

     Perform incremental backups of transaction processing and full backups of batch processing.


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

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    In which situation would you use the Oracle Shared Server configuration？（）
    A

    when performing export and import using Oracle Data Pump

    B

    when performing backup and recovery operations using Oracle Recovery Manager

    C

    when performing batch processing and bulk loading operation in a data warehouse environment 

    D

    in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time


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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    You work as a database administrator at Certkiller .com. You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEEStable. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）

    • A、 perform point-in-time recovery
    • B、 perform a Flashback Table operation to restore the table to the state it was in two days ago
    • C、 perform a Flashback Database operation to restore the database to the state it was in two days ago
    • D、 perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery

    正确答案:D

  • 第16题：

    单选题
    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
    解析： 暂无解析

  • 第17题：

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


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

  • 第18题：

    单选题
    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
    解析： 暂无解析

  • 第19题：

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


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

  • 第20题：

    单选题
    You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：  a） No other user data in the database is affected.  b） The operation takes the minimum possible time.  Which option would you choose？（）
    A

    use the ROLLBACK command with SCN 663571

    B

    perform Flashback Transaction Query with SCN 663571

    C

    execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571

    D

    execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571


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

  • 第21题：

    单选题
    You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area.  Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）
    A

    perform point-in-time recovery

    B

    perform a Flashback Table operation to restore the table to the state it was in two days ago

    C

    perform a Flashback Database operation to restore the database to the state it was in two days ago

    D

    perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery


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

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：  a） No other user data in the database is affected.  b） The operation takes the minimum possible time.  Which option would you choose？（）
    A

     Use ROLLBACK command with SCN 663571.

    B

     Perform Flashback Transaction Query with SCN 663571.

    C

     Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.

    D

     Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.


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

  • 第24题：

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


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

相关内容