单选题 You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）
recycle buffer cache
keep buffer cache
redo log buffer
单选题 You want to estimate the size of a table by using the Oracle Enterprise Manager. On which data is the size of the table NOT based？（）
column data types
projected number of row
单选题 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？（）
The location can be changed only if the flash recovery area is empty.
After executing the command， all new flash recovery area files will be created in the new location.
The command will generate an error because you cannot change the flash recovery area while the database is open.
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.
单选题 You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）： SORT_AREA_SIZE = 150M HASH_AREA_SIZE = 150M BITMAP_MERGE_AREA_SIZE = 150M CREATE_BITMAP_AREA_SIZE = 150M WORKAREA_SIZE_POLICY = AUTO You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G. What is the total PGA memory allocated across all database server processes？（）
单选题 While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）
SQL Tuning Advisor
多选题 You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN> BACKUP TABLESPACE DETTBS； Under which conditions would this command execute successfully？ （）
The database is in NOMOUNT state.
The database is in NOARCHIVELOG mode and the tablespace is online.
The database is in NOARCHIVELOG mode and the tablespace is offline.
The database is in ARCHIVELOG mode and the tablespace is offline.
The database is in ARCHIVELOG mode and the tablespace is online.
单选题 The loss of the control file forced you to re/x7fcreate the control file. After re/x7fcreating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a five/x7fdigit number starting with 0. What could be the possible reason？（）
These are the data files that are corrupted.
There is no SYSAUX tablespace in your database
There is a readonly tablespace in your database.
These are the data files that cannot be recovered.
多选题 You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）
Flashback logs are not archived.
Flashback logs are maintained in redo log files.
Flashback logs are maintained in the Flash Recovery Area.
Flashback logs are used to maintain Flashback Database related errors.
Flashback logs need to be cleared manually after you disable Flashback Database.
单选题 You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery. Which datafiles will you recover？（）
all the datafiles in the database
the datafiles associated with the SYSTEM tablespace
the datafiles associated with the DATA1 tablespace
all the datafiles in the database except those associated with the DATA1 tablespace
单选题 You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to？（）
FREQ = MONTHLY； BYDAY = 2FRI；
FREQ = MONTHLY； BYDAY = FRI（2）；
FREQ = MONTHLY； BYDAY = FRI2；
FREQ = MONTHLY； BYDAY = -2FRI；