网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）
A
by using the SQL access advisor
B
by using the Automatic Workload Repository report
C
by running the Automatic Database Diagnostic Monitor （ADDM）
D
by using the Automatic Workload Repository Compare Period report
E
by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
参考答案
参考解析
解析：
暂无解析
更多 “单选题The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）A by using the SQL access advisorB by using the Automatic Workload Repository reportC by running the Automatic Database Diagnostic Monitor （ADDM）D by using the Automatic Workload Repository Compare Period reportE by analyzing the output of the V$ACTIVE_SESSION_HISTORY view” 相关考题
考题
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 perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?（）A、RMAN BACKUP DURATION 2:00 MINIMIZE LOAD DATABASEB、RMAN BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASEC、RMAN BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE D、RMAN BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE
考题
Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（） A、 WindowB、 ProgramC、 Job_ClassD、 Window group
考题
You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）A、 Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.B、 Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.C、 Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.D、 Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete 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
考题
The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）A、by using the SQL access advisorB、by using the Automatic Workload Repository reportC、by running the Automatic Database Diagnostic Monitor （ADDM）D、by using the Automatic Workload Repository Compare Period reportE、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
考题
The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）A、 time-based recoveryB、 log sequence recoveryC、 cancel-based recoveryD、 change-based recovery
考题
On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use？（）A、Flashback DropB、Flashback TableC、Flashback DatabaseD、Flashback Version QueryE、Flashback Transaction Query
考题
The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）A、timebased recoveryB、log sequence recoveryC、cancelbased recoveryD、changebased recovery
考题
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command？（）A、 UNTIL SEQUENCEB、 UNTIL SCNC、 UNTIL CHANGED、 UNTIL CANCEL
考题
You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）A、 incomplete recoveryB、 complete recoveryC、 recovery using the Flashback Database featureD、 recovery using the export/import utility
考题
You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon. Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup？（） A、 Create a manual incremental online database backup.B、 Back up all the archived redo logs generated since the 8 a.m. backup.C、 Create a brand-new backup after all the changes have been applied.D、 There is no way to make the changes recoverable based on the 8 a.m. backup.E、 Perform an online backup of the tablespace（s） that contained changed data.
考题
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 want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?（）A
RMAN BACKUP DURATION 2:00 MINIMIZE LOAD DATABASEB
RMAN BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASEC
RMAN BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE D
RMAN BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE
考题
单选题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
考题
单选题The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）A
time-based recoveryB
log sequence recoveryC
cancel-based recoveryD
change-based recovery
考题
问答题Femi，Martin and James catch trains to go to the same destination. Femi catches the 8∶15 a.m. train. Martin’s train journey takes twice as long as James’. Martin leaves 15 minutes before Femi and arrives at noon. James catches the 11∶30 a.m. trains. What time does James arrive at the destination?
考题
单选题On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup.Which flashback feature would you use？（）A
Flashback DropB
Flashback TableC
Flashback DatabaseD
Flashback Version QueryE
Flashback Transaction Query
考题
单选题You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）A
incomplete recoveryB
complete recoveryC
recovery using the Flashback Database featureD
recovery using the export/import utility
考题
单选题ou can visit Galloway Wildlife Conservation Park ______A
at 9:00 a. m. on 7th DecemberB
at 11:00 a.m. on 7th DecemberC
at 9:00 a.m. on 7th SeptemberD
at 11:00 a. m. on 7th September
考题
单选题You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon. Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup？（）A
Create a manual incremental online database backup.B
Back up all the archived redo logs generated since the 8 a.m. backup.C
Create a brand-new backup after all the changes have been applied.D
There is no way to make the changes recoverable based on the 8 a.m. backup.E
Perform an online backup of the tablespace（s） that contained changed data.
考题
单选题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
考题
单选题The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）A
by using the SQL access advisorB
by using the Automatic Workload Repository reportC
by running the Automatic Database Diagnostic Monitor （ADDM）D
by using the Automatic Workload Repository Compare Period reportE
by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
考题
单选题On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use？（）A
Flashback DropB
Flashback TableC
Flashback DatabaseD
Flashback Version QueryE
Flashback Transaction Query
考题
单选题Your database operates in ARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an archivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8：30 a.m. With reference to this scenario， what would you do to recover the database？（）A
restore all the data files from last Sunday’s backup， and then perform a timebased recoveryB
restore all the data files from last Sunday’s backup， and then perform a cancelbased recoveryC
restore all the data files from last Sunday’s backup， and then perform a changebased recoveryD
restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery
考题
单选题The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）A
timebased recoveryB
log sequence recoveryC
cancelbased recoveryD
changebased recovery
考题
单选题Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（）A
WindowB
ProgramC
Job_ClassD
Window group
考题
单选题You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）A
Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.B
Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.C
Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.D
Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.
热门标签
最新试卷