DB Creation   «Prev  Next»

Names, Domains, and Parameter File Settings - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which is a reasonable basis for an organization's DB_DOMAIN naming convention?
Select the best answer.
  A. The mandatory default value WORLD
  B. The organization's domain name, optionally with a departmental prefix
  C. The DBA's surname
  D. The database name alone

2. For a simple single-instance database with DB_NAME=PROD, which ORACLE_SID follows a matching-name convention?
Select the best answer.
  A. PRODSID
  B. PROD
  C. PRDI
  D. PROD_INSTANCE

3. Which OPTIMIZER_MODE setting is the default and targets best overall throughput for the complete SQL statement?
Select the best answer.
  A. FIRST_ROWS_1
  B. ALL_ROWS
  C. FIRST_ROWS_10
  D. FIRST_ROWS_1000

4. What does the COMPATIBLE initialization parameter control?
Select the best answer.
  A. Compatibility with Microsoft SQL Server syntax
  B. A list of applications certified to run on the database
  C. The database release-compatibility level that governs use of release-dependent features and formats
  D. The list of Oracle instances allowed to connect to the database