网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 recoveryB perform a Flashback Table operation to restore the table to the state it was in two days agoC perform a Flashback Database operation to restore the database to the state it was in two days agoD perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery” 相关考题
考题
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 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 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.
考题
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、indexorganized table （IOT）
考题
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.
考题
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）
考题
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
考题
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 recoveryB、 perform a Flashback Table operation to restore the table to the state it was in two days agoC、 perform a Flashback Database operation to restore the database to the state it was in two days agoD、 perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
考题
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）
考题
单选题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.
考题
多选题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?（）AIncrease the value of the ASM_POWER_LIMIT parameter.BSet the DISK_REPAIR_TIME disk attribute to a lower value.CSpecify the statement that adds the disk back to the disk group.DIncrease the number of ASMB processes.EIncrease the number of DBWR_IO_SLAVES in the ASM instance.
考题
单选题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）
考题
单选题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）.
考题
单选题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
indexorganized tables （IOTs）
考题
单选题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， 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
考题
单选题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 recoveryB
perform a Flashback Table operation to restore the table to the state it was in two days agoC
perform a Flashback Database operation to restore the database to the state it was in two days agoD
perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
考题
单选题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 663571B
perform Flashback Transaction Query with SCN 663571C
execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D
execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
考题
单选题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 tableC
Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D
Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
考题
单选题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.
考题
单选题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 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.
考题
单选题In which situation would you use the Oracle Shared Server configuration？（）A
when performing export and import using Oracle Data PumpB
when performing backup and recovery operations using Oracle Recovery ManagerC
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
考题
单选题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
indexorganized table （IOT）
热门标签
最新试卷
