by using the SQL access advisor
by using the Automatic Workload Repository report
by running the Automatic Database Diagnostic Monitor (ADDM)
by using the Automatic Workload Repository Compare Period report
by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
第1题:
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?()
第2题:
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?()
第3题:
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?()
第4题:
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?()
第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?()
第6题:
incomplete recovery
complete recovery
recovery using the Flashback Database feature
recovery using the export/import utility
第7题:
Flashback Drop
Flashback Table
Flashback Database
Flashback Version Query
Flashback Transaction Query
第8题:
Create a manual incremental online database backup.
Back up all the archived redo logs generated since the 8 a.m. backup.
Create a brand-new backup after all the changes have been applied.
There is no way to make the changes recoverable based on the 8 a.m. backup.
Perform an online backup of the tablespace(s) that contained changed data.
第9题:
time-based recovery
log sequence recovery
cancel-based recovery
change-based recovery
第10题:
Window
Program
Job_Class
Window group
第11题:
restore all the data files from last Sunday’s backup, and then perform a timebased recovery
restore all the data files from last Sunday’s backup, and then perform a cancelbased recovery
restore all the data files from last Sunday’s backup, and then perform a changebased recovery
restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup, and then perform a complete recovery
第12题:
timebased recovery
log sequence recovery
cancelbased recovery
changebased recovery
第13题:
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?()
第14题:
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?()
第15题:
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?()
第16题:
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?()
第17题:
第18题:
at 9:00 a. m. on 7th December
at 11:00 a.m. on 7th December
at 9:00 a.m. on 7th September
at 11:00 a. m. on 7th September
第19题:
RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE
RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE
RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE
RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE
第20题:
by using the SQL access advisor
by using the Automatic Workload Repository report
by running the Automatic Database Diagnostic Monitor (ADDM)
by using the Automatic Workload Repository Compare Period report
by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
第21题:
Flashback Drop
Flashback Table
Flashback Database
Flashback Version Query
Flashback Transaction Query
第22题:
Restore all the data files from last Sunday’s backup, and then perform a time-based recovery.
Restore all the data files from last Sunday’s backup, and then perform a cancel-based recovery.
Restore all the data files from last Sunday’s backup, and then perform a change-based recovery.
Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup, and then perform a complete recovery.
第23题:
Database replay
SQL Tuning Advisor
SQL Access Advisor
SQL Performance Analyzer
Automatic Workload Repository compare reports
第24题:
DBA_PENDING_TRANSACTIONS
DBA_AUDIT_STATEMENT
V$FLASHBACK_DATABASE_STATS
FLASHBACK_TRANSACTION_QUERY