Oracle 10g Test Answer

Consider thie following SQL statement:
UPDATE employees SET first_name = 'John'
WHERE emp_id = 1009;
COMMIT;

What happens when a user issues the COMMIT in the above SQL statement?

a. The server process places the commit record in the redo log buffer

b. Log Writer (LGWR) writes the redo log buffer entries to the redo log files and data files

c. The user process notifies the server process that the transaction is complete

d. The user process notifies the server process that the resource locks can be released

Which of the following items are stored in the flash recovery area?

a. Datafiles

b. Undo segments

c. Datafile copies

d. Archived redo log files

Which of the following conditions must be met to make tablespace read-only?

a. The tablespace must contain an active rollback segments

b. The tablespace must be online

c. The tablespace must not contain any active rollback segments

d. The tablespace must not be involved in an open backup

e. The tablespace must be involved in an open backup

What happens when the DBA disables the flash recovery area?

a. The RMAN will continue to be able to access the files in the flash recovery area

b. The RMAN will be unable to access the files in the flash recovery area

c. The RMAN will be unable to access the automatic space management features of the flash recovery area

d. None of the above

What will happen if you set the value of the SGA_TARGET parameter higher than the value of the SGA_MAX_ SIZE parameter at instance startup?

a. The instance will not start

b. SGA_TARGET will become equal to the SGA_MAX_SIZE value

c. The database will ignore the SGA_TARGET parameter

d. SGA_MAX_SIZE is automatically raised, so it is equal to the SGA_TARGET value

Which of the following statements are correct for rebuilding an index?

a. The resulting index may contain deleted entries

b. A new index is built using an existing index as the data source

c. Queries cannot use the existing index while the new index is being built

d. During a rebuild, sufficient space is needed to accommodate both the old and new indexes in their respective tablespaces

Which of the following sets of tablespaces is mandatory for any Oracle 10g database?

a. SYSTEM, SYSAUX, and UNDOTBS

b. SYSTEM and UNDOTBS

c. SYSAUX and UNDOTBS

d. SYSTEM and SYSAUX

What does the ARBn background process do in an ASM instance?

a. Coordinates disk activity

b. Performs disk rebalance work

c. Coordinates disk rebalance work

d. Manages the RBAL process

Which of the following views provides the names of all the data dictionary views?

a. DBA_NAMES

b. DBA_TABLES

c. DICTIONARY

d. DBA_DICTIONARY

You want to find the following information about a user:
- The expiry date of the user's account
- The user's default tablespace name
- The user's profile name

Which data dictionary view should be queried for the purpose?

a. DBA_USERS only

b. DBA_USERS and DBA_PROFILES

c. DBA_USERS and DBA_TABLESPACES

d. DBA_USERS, DBA_TS_QUOTAS, and DBA_PROFILES

Which of the following constitute the functions of an ASM instance?

a. Managing disk groups and communicating file metadata to the Oracle database using
ASM files

b. Managing database files and communicating file metadata to the ASM instance using
ASM files

c. Managing disk groups and communicating file metadata to the RMAN

d. Protecting disk groups

Which background process performs a checkpoint in the database by writing modified blocks from the database buffer cache in the SGA to the data files?

a. LGWR

b. SMON

c. DBWn

d. CKPT

Which of the following commands are used to apply incremental backups?

a. RECOVER BACKUP OF DATABASE

b. RECOVER DATAFILE

c. RECOVER COPY OF DATAFILE

d. RECOVER COPY OF DATABASE

What are two main advantages of using bitmap indexes?

a. Bitmap indexes use less storage space

b. Bitmap segments are updated upon COMMIT, at the end of the transaction

c. Bitmap indexes work very fast with multiple predicates that are combined with AND, OR, and NOT operators

d. None of  the above

The RMAN CATALOG command:

a. Helps create the image copies of datafiles

b. Helps create the image copies of current control files

c. Helps catalog the new files that are not a part of the recovery catalog

d. Helps catalog only the old files

Evaluate the following SQL:

CREATE USER sam IDENTIFIED BY sam;
GRANT

CREATE ANY MATERIALIZED VIEW,
CREATE ANY DIMENSION, DROP ANY DIMENSION, QUERY REWRITE, GLOBAL QUERY REWRITE
TO dw_manager
WITH ADMIN OPTION;
GRANT dw_manager TO sam WITH ADMIN OPTION;

Which of the following actions is the user SAM able to perform?

a. Select from a table

b. Create and drop a materialized view

c. Alter a materialized view that you created

d. Grant and revoke the role to and from other users

e. Enable the role and exercise any privileges in the role's privilege domain

Which tablespace is used as a temporary tablespace if  'TEMPORARY TABLESPACE' is not specified for a user?

a. TEMP

b. DATA

c. SYSTEM

d. ROLLBACK

The utility SQL*Loader should not  be used:

a. While loading selected rows into each table

b. While loading data from an export dump file

c. While loading data from disk, tape, or named pipes

d. While the data is NOT being inserted from a flat file

Which of the following statements are correct with regard to Rebuilding Indexes?

a. The ALTER INDEX REBUILD command is used to change the storage characteristics of an index

b. Using the ALTER INDEX REBUILD is usually faster than dropping and recreating an index because it uses the fast full scan feature

c. Oracle8i allows the creation of an index or re-creation of an existing index while allowing concurrent operations on the base table

d. When building an index, the NOLOGGING and UNRECOVERABLE keywords can be used concurrently to reduce the time it takes to rebuild

_____________ is mandatory for using the easy connect naming method.

a. Host name

b. Database name

c. Service name

d. Port number

ASM disk groups provide:

a. Redundancy through striping

b. Performance through mirroring.

c. Redundancy through mirroring

d. Performance through striping

Which of the following constitute the types of segments?

a. Only LOBS

b. Only nested tables

c. Only index-organized tables

d. Only LOBS and index-organized tables

e. Nested tables, LOBS, index-organized tables, and boot straps

Which of the following statements is correct with regard to LOG_BUFFER initialization parameter?

a. The LOG_BUFFER parameter can be changed dynamically

b. The minimum value for the LOG_FILE parameter is 512KB

c. The LOG_BUFFER parameter value must be a multiple of the database block size

d. The LOG_BUFFER parameter value must be a multiple of the operating system block size

Which of the following types of commands is used to copy ASM files?

a. RMAN Commands

b. OMF Commands

c. Operating System Commands

d. Logical Volume Manager Commands

What is the purpose of the flashback technology in Oracle Database 10g?

a. Recovery from physical corruption of a data file

b. Recovery from physical and logical corruption of a data file

c. Recovery from logical corruption of a data file

d. Recovery from a problem brought on by a damaged disk drive

Which of the following is a new initialization parameter for Oracle Database 10g?

a. UNDO_SUPPRESS_ERRORS

b. PARALLEL_AUTOMATIC_TUNING

c. RESUMABLE_TIMEOUT

d. SHARED_SERVER

The initialization parameter UNDO_RETENTION is used:

a. To specify the length of time for which Oracle must retain undo data in the undo tablespace

b. To specify the length of time for which Oracle must retain undo data in the flash recovery area

c. To specify the length of time for which Oracle must retain undo data in the data files

d. To specify the length of time for which Oracle will retain undo data in the flashback database logs

Which of the following commands revokes the ROLE_DATA role from all the users?

a. REVOKE role_data FROM ALL;

b. REVOKE role_data FROM PUBLIC;

c. REVOKE role_data FROM default;

d. REVOKE role_data FROM ALL_USERS;

Which of the following statements is correct with regard to index clusters?

a. Index clusters can only be used for tables with low cardinality columns

b. Index clusters are generally well suited for tables that have many full table scans

c. Normal B-Tree indexes do not store null key values, whereas cluster indexes store null keys

d. A cluster index always takes up much more storage space than a normal index for the same set of key values

Which of the following data dictionary views should be used to get a list of object privileges for all the database users?

a. DBA_TAB_PRIVS

b. ALL_TAB_PRIVS

c. USER_TAB_PRIVS

d. ALL_TAB_PRIVS_MADE

What should you confirm before changing the CURSOR_SPACE_FOR_TIME parameter (in your initialization file) to TRUE?

a. The TIMED_STATISTICS parameter is set to TRUE

b. The hit percentage in the buffer cache is at least 95%

c. The OPEN_CURSOR parameter is set to at least twice the default value

d. The value in the RELOADS column of V$LIBRARYCACHE is consistently zero

Which DBMS_LOGMNR feature facilitates the automatic addition of the redo log files for mining?

a. REMOVE_LOGFILE

b. CONTINUOUS_MINE

c. NO_ROWID_IN_STMT

d. AUTOMATIC_LOGFILE

Which of the following statements are correct for using the RESETLOGS option?

a. You don't need to back up the database

b. You must back up the database right away

c. You can use archive redo logs from an older incarnation of the database

d. You cannot use archive redo logs from an older incarnation of the database

What is the default value for the OPTIMIZER_MODE initialization parameter?

a. FIRST_ROWS

b. ALL_ROWS

c. CHOOSE

d. COST

Which of the following helps you identify your statement in the DBA_TUNE_MVIEW view?

a. The STATEMENT variable

b. The STATEMENT_ID column

c. The VIEW_ID column

d. The TASK_NAME variable