1、
If you create your database using Oracle Managed Files (OMF), what is true?
A. You must use Oracle predefined names to identify raw partitions that will hold
OMF structures.
B. You must define directories for two online redo log groups and three copies of the
control file.
C. If your CREATE DATABASE command fails, any OMF database files that have
already been created will be dropped automatically.
D. You must use only OMF data files when adding new tablespaces or data files to
your database in the future.
2、
The CURSOR_SHARING parameter is set to SIMILAR at the instance level and
you issue these SELECT statements in the order shown below:
SELECT * FROM employees WHERE department _id=50;
SELECT * FROM employees WHERE department_id=70;
There is an index on the DEPARTMENT ID column of the 1,000,000 row
EMPLOYEES table. Ninety percent of the employees are part of
DEPARTMENT_ID 50.
In which two scenarios will Oracle9i share the corresponding cursors for the two
statements? (Choose two.)
A. You are using the rule-based optimizer.
B. You are using the cost-based optimizer with up-to-date statistics but with no
histograms.
C. You are using the cost-based optimizer with up-to-date statistics and histograms
computed for the DEPARTMENT_ID column.
D. You are using the cost-based optimizer with up-to-date statistics and histograms
computed for the DEPARTMENT_ID column and system statistics gathered.
3、Consider this RMAN command:
RMAN> CONFIGURE RETENTION POLICY
2> TO RECOVERY WINDOW OF 7 DAYS;
What does the command accomplish?
A. Establishes the fixed number of backups that must be kept for media recovery
B. Establishes the fixed number of backups required to perform media recovery
within 7 days
C. Sets the fixed number of days that backups are held for media recovery
D. Ensures that sufficient backups and logs will be kept so that a point-in-time
recovery to any time in the last 7 days is possible