网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?（）
A
set DB_FLASHBACK_RETENTION_TARGET=10800
B
create a new scheduler window for the time period of 24 hours and use the optimizer statistics
C
modify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings
D
specify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations
参考答案
参考解析
解析：
暂无解析
更多 “单选题The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?（）A set DB_FLASHBACK_RETENTION_TARGET=10800 B create a new scheduler window for the time period of 24 hours and use the optimizer statistics C modify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings D specify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations” 相关考题
考题
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?()
A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the databaseC. Create Flashback Data Archive in the tablespace where the tables are stored.D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables
考题
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）A. The collection level for the AWR should be set to BASICB. The moving window size must be less than Undo RetentionC. The moving window size should be greater than the Automatic Workload Repository (AWR) retention periodD. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
考题
You need to ensure that you can recover system configuration and data if your computer hard disk fails.What should you do?()
A.AB.BC.CD.D
考题
You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation.What should you do?（）A.AB.BC.CD.D
考题
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）A、The collection level for the AWR should be set to BASICB、The moving window size must be less than Undo RetentionC、The moving window size should be greater than the Automatic Workload Repository (AWR) retention periodD、The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
考题
The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?（）A、Create two custom ADDM tasks.B、Modify the AWR snapshot time interval to two hours.C、Create a new scheduler window for a time period of two hours.D、Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
考题
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、The retention period to support flashbackB、The expected length of the longest-running queryC、The number of undo tablespaces in the databaseD、The size of the Flash Recovery Area for the database instance
考题
You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）A、set SQL_TRACE=True B、set UNDO_RETENTION=14400 C、set FAST_START_MTTR_TARGET=240 D、set LOG_CHECKPOINT_INTERVAL=240 E、set DB_FLASHBACK_RETENTION_TARGET=14400 F、set the RETENTION GUARANTEE clause for the undo tablespace
考题
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task？（）A、 Enable supplemental logging for the database.B、 Specify undo retention guarantee for the databaseC、 Create Flashback Data Archive in the tablespace where the tables are stored.D、 Create Flashback Data Archive and enable Flashback Data Archive for specific tables
考题
You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task？（）A、 Enable Flashback Data Archive for the tables.B、 Specify undo retention guarantee for the database.C、 Enable supplemental logging for the database.D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.E、 Create Flashback Data Archive on the tablespace on which the tables are stored.
考题
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）A、Insert finding directives for ADDM tasks in the future.B、Create a baseline on a pair of snapshots spanning the peak-load period.C、Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots
考题
The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?（）A、set DB_FLASHBACK_RETENTION_TARGET=10800 B、create a new scheduler window for the time period of 24 hours and use the optimizer statistics C、modify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings D、specify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations
考题
You have a single Active Directory directory service domain. You have three Active Directorysites. Site replication is scheduled to occur during business hours only. You plan to make a schema change after business hours. You need to ensure that replication occurs for all sites during the schema change. What should you do？（）A、 Set the Ignore schedules setting for the IP transport.B、 Clear the Ignore schedules setting for the IP transport.C、 Enable the KCC for all site objects.D、 Disable the KCC for all site objects.
考题
Your network has 1，000 client computers that run Windows 7. You plan to deploy a new application. You need to ensure that the application deploys only during non-business hours. What should you do？（）A、Use Group Policy.B、Use Windows Deployment Services with a schedule cast.C、Use Microsoft System Center Configuration Manager.D、Use a logon script.
考题
You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation. What should you do？（）A、Create a System Restore point.B、Perform an Automated System Recovery （ASR） backup and restore.C、In the Backup and Restore Center window， click the Back up files button.D、In the Backup and Restore Center window， click the Back up computer button.
考题
单选题Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze theperformance of the database in the future. What action would you take to achieve this task（）A
Insert finding directives for ADDM tasks in the future.B
Create a baseline on a pair of snapshots spanning the peak-load period.C
Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.D
Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automatic purging of snapshots.
考题
单选题You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task？（）A
Enable Flashback Data Archive for the tables.B
Specify undo retention guarantee for the database.C
Enable supplemental logging for the database.D
Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.E
Create Flashback Data Archive on the tablespace on which the tables are stored.
考题
多选题Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）AThe retention period to support flashbackBThe expected length of the longest-running queryCThe number of undo tablespaces in the databaseDThe size of the Flash Recovery Area for the database instance
考题
单选题You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation. What should you do？（）A
Create a System Restore point.B
Perform an Automated System Recovery （ASR） backup and restore.C
In the Backup and Restore Center window， click the Back up files button.D
In the Backup and Restore Center window， click the Back up computer button.
考题
单选题The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?（）A
Create two custom ADDM tasks.B
Modify the AWR snapshot time interval to two hours.C
Create a new scheduler window for a time period of two hours.D
Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
考题
单选题You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?（）A
Enable supplemental logging for the database.B
Specify undo retention guarantee for the databaseC
Create Flashback Data Archive in the tablespace where the tables are stored.D
Create Flashback Data Archive and enable Flashback Data Archive for specific tables
考题
单选题Your network has 1，000 client computers that run Windows 7. You plan to deploy a new application. You need to ensure that the application deploys only during non-business hours. What should you do？（）A
Use Group Policy.B
Use Windows Deployment Services with a schedule cast.C
Use Microsoft System Center Configuration Manager.D
Use a logon script.
考题
单选题You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？ （）A
3 hoursB
6 monthsC
until last yearD
until last commitE
until the point when the undotablespacewas refreshedF
until the database is shut down and the memory erased
考题
单选题You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task？（）A
Enable supplemental logging for the database.B
Specify undo retention guarantee for the databaseC
Create Flashback Data Archive in the tablespace where the tables are stored.D
Create Flashback Data Archive and enable Flashback Data Archive for specific tables
考题
单选题You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）A
The collection level for the AWR should be set to BASICB
The moving window size must be less than Undo RetentionC
The moving window size should be greater than the Automatic Workload Repository (AWR) retention periodD
The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
考题
单选题The Automatic Database Diagnostic Monitor （ADDM） analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do？（）A
Create two custom ADDM tasks.B
Modify the AWR snapshot time interval to two hours.C
Create a new scheduler window for a time period of two hours.D
Modify the Automatic Workload Repository （AWR） snapshot retention period to two hours.
考题
单选题Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）A
Insert finding directives for ADDM tasks in the future.B
Create a baseline on a pair of snapshots spanning the peak-load period.C
Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.D
Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots
热门标签
最新试卷