A. Top SQL
B. snapshots
C. SQL Tuning sets
D. index access path
E. optimizer statistics
F. materialized view logs
您可能感兴趣的试卷
你可能感兴趣的试题
A. One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.
B. One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.
C. One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.
D. One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.
You execute the following command to enable a session in resumable mode：
SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60；
What is the impact of a timeout on the statements being suspended？（）
A. The statements remain suspended for at least 60 seconds.
B. The statements are suspended for 60 seconds and then they are executed.
C. The suspended statements error out if the problem is not rectified within 60 seconds.
D. The statements are automatically suspended 60 seconds after an error is received， and then attempt to execute normally again.
A. by setting the SQL_TRACE parameter to FALSE in the parameter file
B. by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
C. by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
D. by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：
SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）；
Which two statements are true？ （）
A. SYSDATE should not be used with TIMESTAMP.
B. The database must have multiplexed redo log files.
C. The database must be in the MOUNT state to execute the command.
D. The database must be opened with the RESETLOGS option after the flashback operation.
E. The entire database needs to be restored from the most recent backup before the flashback operation.
A. clear the redo log group
B. perform redo log file import
C. perform an incomplete recovery
D. perform a redo log recovery using Recovery Manager （RMAN）
E. shut down the database and open the database in the NOARCHIVELOG mode
A. Flashback Drop
B. Flashback Table
C. Flashback Database
D. Flashback Version Query
E. Flashback Transaction Query
A. modify the HASH_AREA_SIZE initialization parameter
B. modify the PGA_AGGREGATE_TARGET initialization parameter
C. modify the WORK_AREASIZE_POLICY initialization parameter
D. increase the value of the SGA_TARGET initialization parameter
E. increase the value of the SGA_MAX_SIZE initialization parameter
F. increase the value of the SORT_AREA_SIZE initialization parameter
A. A window must have been created with the WEEKEND_PLAN resource plan.
B. A program must have been created with the WEEKEND_PLAN resource plan.
C. A job class must have been created with the WEEKEND_PLAN resource plan.
D. A window group must have been created with the WEEKEND_PLAN resource plan.
You decided to change the location of the flash recovery area. You executed the following command：
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’；
Which statement is true？（）
A. The location can be changed only if the flash recovery area is empty.
B. After executing the command， all new flash recovery area files will be created in the new location.
C. The command will generate an error because you cannot change the flash recovery area while the database is open.
D. All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.
A. The backup would be retained on the media for 31 days.
B. The backup would be maintained in the recovery catalog for 31 days.
C. The backup metadata would be retained in the control file for 31 days.
D. The backup metadata would be maintained in the recovery catalog for 31 days.
E. Automatic backups of the control file will be retained in the flash recovery area for 31 days.
最新试题
You decided to change the location of the flash recovery area. You executed the following command： Which statement is true？（）
You lost the PRODSTD tablespace， which was read/write. The tablespace was readonly when the last backup was performed. How would you recover the tablespace？（）
You disabled the Flashback Database feature by using the following command： SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs？（）
You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）
You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）
View the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？"） in the Flashback Database architecture.（）
You lost the index tablespace in your database. You decided to recreate the index tablespace and the indexes in the tablespace. What methods can you use to recreate the indexes？（）
Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived， and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery： RMAN> RUN { 2> SET UNTIL SEQUENCE 230 THREAD 1; 3> ALTER DATABASE MOUNT; 4> RESTORE DATABASE; 5> RECOVER DATABASE; 6> ALTER DATABASE OPEN RESETLOGS;7> }; With reference to this scenario， which statement is true？（）
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？（）
View the Exhibit. One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9：00 a.m. You noticed this at 11：00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true？（）