Quick DBA Test - Oracle 10g

As a database administrator, you are required to implement a backup plan that has been documented as follows:

a) Full backups every Saturday night
b) Cumulative backups every Wednesday to back up everything since the last full backup
C) Daily incremental backups for the rest of the days of the week

The database has to be available 24 hours a day, 7 days a week, and can therefore not be shutdown at any time.

Referring to the scenario above, how do you implement this backup plan using RMAN?

a.) 1. Saturdays - Level 0 Backups2. Wednesdays - Level 1 Backups3. Sundays, Mondays, Tuesdays, Thursdays, Fridays - Level 2 Backups
b.) 1. Saturdays - Level 1 Backups2. Wednesdays - Level 2 Backups3. Sundays, Mondays, Tuesdays, Thursdays, Fridays - Level 3 Backups
c.) 1. Saturdays - Level 2 Backups2. Wednesdays - Level 1 Backups3. Sundays, Mondays, Tuesdays, Thursdays, Fridays - Level 0 Backups
d.) 1. Saturdays - Cold Backups2. Wednesdays - Level 1 Backups3. Sundays, Mondays, Tuesdays, Thursdays, Fridays - Level 2 Backups
e.) 1. Saturdays - Level 0 Backups2. Wednesdays - Level 1 Backups3. Sundays, Mondays, Tuesdays, Thursdays, Fridays - Level 1 Backups


Rob has been asked to look into the execution plans from an application which is working very slowly.

Based on the scenario above, at which one of the following does Rob first look when performing SQL statement tuning?

a.) Outer joins
b.) Inner joins
c.) Index range scans
d.) Full table scans
e.) Hash joins

Which one of the following do you execute to ensure that the control file is automatically backed up using Recovery Manager?

a.) CONFIGURE CONTROLFILE AUTOBACKUP ON;
b.) CONFIGURE CONTROLFILE BACKUP AUTO;
c.) CONFIGURE CONTROL FILE AUTOBACKUP;
d.) CONFIGURE CONTROL BACKUP AUTO;
e.) CONFIGURE CONTROL AUTO BACKUP;

Which one of the following background processes coordinates the rebalancing of disks in Automatic Storage Management?

a.) J000
b.) ORB1
c.) RECO
d.) RBAL
e.) CJQ0

You want to have the same statistics in your TEST database as the ones in your PRODUCTION database.

Referring to the above, how do you accomplish the requirements stated above?

a.) Run the GATHER_SCHEMA_STATS on TEST and PRODUCTION at the same time.
b.) Run the GATHER_DATABASE_STATS on TEST and PRODUCTION at the same time.
c.) EXPORT statistics from PRODUCTION and IMPORT to TEST using the DBMS_STATS package procedures.
d.) RESTORE statistics from PRODUCTION to TEST using the DBMS_STATS package procedures.
e.) RESTORE the PRODUCTION tables and data on TEST.

1. In Oracle 10g, how is the scheduler implemented?

a.) As a separate daemon which runs under root privileges
b.) As a separate thread under the SMON daemon which wakes up at a pre-defined interval to check for job schedules
c.) As a collection of functions and procedures in the DBMS_SCHEDULER package
d.) As a collection of functions, procedures, and packages in the DBMS_JOB_SCHEDULER package
e.) As a command-line tool named "schedjob" which interfaces with the OS scheduler

2. Which one of the following is a valid DDL statement to create a Bigfile tablespace?

a.) CREATE BIGFILE TABLESPACE tbs_bf_fct_001DATAFILE 'tbs_bf_fct_001.dbf'SIZE 6G EXTENT MANAGEMENT DICTIONARY;
b.) CREATE BIGFILE TABLESPACE tbs_bf_fct_001DATAFILE 'tbs_bf_fct_001.dbf'SIZE 6G;
c.) CREATE BIGFILE TABLESPACE tbs_bf_fct_001DATAFILE 'tbs_bf_fct_001.dbf'SIZE 6G SEGMENT SPACE MANAGEMENT MANUAL;
d.) CREATE BIGFILE TABLESPACE tbs_bf_fct_001DATAFILE 'tbs_bf_fct_001.dbf'SIZE 6G SEGMENT SPACE MANAGEMENT MANUAL EXTENT MANAGEMENT DICTIONARY;
e.) CREATE BIGFILE TABLESPACE tbs_bf_fct_001DATAFILE 'tbs_bf_fct_001.dbf' SIZE 3GB, 'tbs_bf_fct_002.dbf' SIZE 3G;

3. Which one of the following do you query in order to access fine-grained audit information?

a.) DBA_FGA_AUDIT_INFO
b.) DBA_FGA_AUDIT_TRAIL
c.) DBA_FGA_AUDIT
d.) V$FGA_AUDIT_TRAIL
e.) V$FGA_AUDIT_INFO


4. Which one of the following describes the "Reset database to incarnation" command used by Recovery Manager?
a.) It performs point-in-time recovery when using Recovery Manager.
b.) It is used to undo the effect of a resetlogs operation by restoring backups of a prior incarnation of the database.
c.) It restores the database to a save point as defined by the version control number or incarnation number of the database.
d.) It restores the database to the initial state in which it was found when first backing it up via Recovery Manager.
e.) It performs a resynchronization of online redo logs to a given archive log system change number (SCN).


5.You have a multi-master replication setup. You need to add a DATE type column to the table GL_ENTRY.

Referring to the scenario above, which one of the following Oracle packages do you execute to ensure that this change is replicated to all the other sites?

a.) DBMS_REPCAT.ALTER_MASTER_OBJECT
b.) DBMS_REPCAT.EXECUTE_MASTER_DDL
c.) DBMS_REPCAT.ALTER_MASTER_DDL
d.) DBMS_REPCAT.REPLICATE_OBJECT_DDL
e.) DBMS_REPCAT.ALTER_MASTER_REPOBJECT



6. How many levels of CPU percentage can be specified when creating a resource plan directive for Database Resource Manager?
a.) 2
b.) 4
c.) 8
d.) 16
e.) 32


7. Which one of the following procedures do you use to analyze a single SQL statement?

a.) DBMS_ADVISOR.ADD_SQLWKLD_REF
b.) DBMS_ADVISOR.ADD_SQLWKLD_STATEMENT *
c.) DBMS_ADVISOR.QUICK_TUNE
d.) DBMS_ADVISOR.CREATE_TASK
e.) DBMS_ADVISOR.CREATE_SQLWKLD

8. Which one of the following components of Data Guard pulls archived redo logs from the primary site?

a.) MRP*
b.) FAL client
c.) FAL server
d.) ARCn
e.) LGWR


9.Which one of the following is a valid Data Availability Mode within Data Guard?

a.) Guaranteed protection mode
b.) Instant protection mode
c.) Rapid protection mode
d.) Maximum protection mode
e.) Delayed protection mode




10. Which one of the following do you access to find out what benefit you can expect to the system after a recommendation is carried out?

a.) DBA_ADVISOR
b.) DBA_ADVISOR_TASKS *
c.) DBA_ADVISOR_FINDINGS
d.) DBA_ADVISOR_RECOMMENDATIONS
e.) DBA_ADVISOR_LOG


11. Which one of the following is the default type of materialized view?

a.) Primary Key Materialized View*
b.) Object Materialized View
c.) ROWID Materialized View
d.) Complex Materialized View
e.) Hash Materialized View


12. One of your database developers is concerned about optimizer execution plan changes when other changes are made to the database.

Referring to the scenario above, how do you prevent this from occurring?

a.) Make no structural changes to the database.
b.) Use hints.
c.) Use optimizer plan stability.
d.) Set the optimizer mode to RULE.
e.) Set the optimizer mode to ALL_ROWS