Oracle Database 11g Online Test From Dbalounge

Reviewed by Editorial Team

The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.

Learn about Our Editorial Process

| By Dbalounge

Dbalounge

Community Contributor

Quizzes Created: 1 | Total Attempts: 2,277

| Attempts: 2,277

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Easy First Hard First Sequential

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

1/6 Questions

Which of the following parameters is used to enable resumable for an instance?
- RESUMABLE_NAME
- RESUMABLE_TIMEOUT
- RESUMABLE_SESSION
- RESUMABLE

About This Quiz

Test your knowledge on Oracle Database 11g by taking the Online Examination on 11g DBA.
The Exam requires FREE Registration.

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
Correct Answer

A. The SQL Access Advisor

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.

Rate this question:

1
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
Correct Answer

A. DBMS_SCHEDULAR.LOGGING_ON

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.

Rate this question:
4.

Which of the following procedures is used to prioritize the jobs in a schedule?
- CREATE_JOB
- SET_ATTRIBUTE
- SET_SCHEDULE
- CREATE_JOB_CLASS
Correct Answer

A. SET_ATTRIBUTE

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.

Rate this question:

1
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
Correct Answer

A. LOG_ARCHIVE_MIN_SUCCEED_DEST

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.

Rate this question:
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
Correct Answer

A. V$NLS_VALID_VALUES

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.

Rate this question:

Quiz Review Timeline (Updated): Mar 20, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 20, 2023

Quiz Edited by
ProProfs Editorial Team
Feb 17, 2012

Quiz Created by
Dbalounge

Oracle Database 11g Online Test From Dbalounge

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

Quiz Preview

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

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

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

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?

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