Oracle Database 11g Online Test From Dbalounge

1. Which of the following parameters is used to enable resumable for an instance?

RESUMABLE_NAME

RESUMABLE_TIMEOUT

RESUMABLE_SESSION

RESUMABLE

RESUMABLE_TIMEOUT is the correct answer because it is a parameter used to enable resumable for an instance. Resumable timeout allows a database operation to be suspended and resumed later if it exceeds a certain time limit. By setting a value for RESUMABLE_TIMEOUT, the database will automatically suspend the operation if it exceeds the specified time, giving the opportunity to the user to decide whether to continue or terminate the operation.

Explanation

RESUMABLE_TIMEOUT is the correct answer because it is a parameter used to enable resumable for an instance. Resumable timeout allows a database operation to be suspended and resumed later if it exceeds a certain time limit. By setting a value for RESUMABLE_TIMEOUT, the database will automatically suspend the operation if it exceeds the specified time, giving the opportunity to the user to decide whether to continue or terminate the operation.

2. Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?

The SGA Tuning Advisor

The SQL Access Advisor

The SQL Tuning Advisor

The Memory Advisor

The SQL Access Advisor is the correct answer because it is specifically designed to identify and create indexes that will minimize the database time for a particular SQL statement. It analyzes the SQL statement and provides recommendations on index creation, partitioning, and materialized views to improve the performance of the statement. By following the advisor's recommendations, the database can optimize the access path and reduce the time needed to execute the SQL statement.

Explanation

The SQL Access Advisor is the correct answer because it is specifically designed to identify and create indexes that will minimize the database time for a particular SQL statement. It analyzes the SQL statement and provides recommendations on index creation, partitioning, and materialized views to improve the performance of the statement. By following the advisor's recommendations, the database can optimize the access path and reduce the time needed to execute the SQL statement.

3. Which of the following is not a valid setting for LOGGING_LEVEL Job Class parameter?

DBMS_SCHEDULAR.LOGGING_FULL

DBMS_SCHEDULAR.LOGGING_ON

DBMS_SCHEDULAR.LOGGING_OFF

DBMS_SCHEDULAR.LOGGING_RUN

The correct answer is DBMS_SCHEDULAR.LOGGING_ON because the correct spelling is DBMS_SCHEDULER.LOGGING_ON. The incorrect spelling of "SCHEDULER" makes this option invalid.

Explanation

The correct answer is DBMS_SCHEDULAR.LOGGING_ON because the correct spelling is DBMS_SCHEDULER.LOGGING_ON. The incorrect spelling of "SCHEDULER" makes this option invalid.

4. Which of the following procedures is used to prioritize the jobs in a schedule?

CREATE_JOB

SET_ATTRIBUTE

SET_SCHEDULE

CREATE_JOB_CLASS

The procedure used to prioritize jobs in a schedule is SET_ATTRIBUTE. This procedure allows attributes or priorities to be assigned to each job, which helps in determining the order in which the jobs should be executed. By setting attributes, the scheduler can prioritize certain jobs over others based on specific criteria or requirements.

Explanation

The procedure used to prioritize jobs in a schedule is SET_ATTRIBUTE. This procedure allows attributes or priorities to be assigned to each job, which helps in determining the order in which the jobs should be executed. By setting attributes, the scheduler can prioritize certain jobs over others based on specific criteria or requirements.

5. You work as a Database Administrator. The company uses an Oracle database. You want to specify a number of locations to which the redo logs should be archived before an error occurs. Which of the following initialization parameters should you use to accomplish this?

LOG_ARCHIVE_DEST_STATE_n

LOG_ARCHIVE_DEST_n

LOG_ARCHIVE_MIN_SUCCEED_DEST

LOG_ARCHIVE_DUPLEX_DEST

The initialization parameter LOG_ARCHIVE_MIN_SUCCEED_DEST should be used to specify a number of locations to which the redo logs should be archived before an error occurs. This parameter ensures that the redo logs are successfully archived to at least the specified number of destinations before the database can continue processing.

Explanation

The initialization parameter LOG_ARCHIVE_MIN_SUCCEED_DEST should be used to specify a number of locations to which the redo logs should be archived before an error occurs. This parameter ensures that the redo logs are successfully archived to at least the specified number of destinations before the database can continue processing.

6. Which of the following parameters is used to display an entire range of supported languages, as well as all other globalization options?

V$NLS_LANGUAGES

NLS_LANG

NLS_DATABASE_PARAMETERS

V$NLS_VALID_VALUES

NLS_INSTANCE_PARAMETERS

V$NLS_VALID_VALUES is the correct answer because it is a view in the Oracle database that provides information about the valid values for various globalization parameters, including language settings. It displays the entire range of supported languages and other globalization options that can be used in the database.

Explanation

V$NLS_VALID_VALUES is the correct answer because it is a view in the Oracle database that provides information about the valid values for various globalization parameters, including language settings. It displays the entire range of supported languages and other globalization options that can be used in the database.