0

databases Online Quiz - 82

Description: databases Online Quiz - 82
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which two parameters can be set to tell the Oracle to use OMF (Oracle Managed Files)?

  1. DB_CREATE_FILE_DEST

  2. DB_CREATE_ONLINE_LOG_n

  3. USER_DUMP_DEST

  4. LOG_ARCHIVE_DEST


Correct Option: A

Why is searching for large-table full-table scans critical to SQL tuning?

  1. They indicate an optimized execution plan.

  2. They may be able to be tuned to use an index

  3. The full-table scan should be normalized from the database design

  4. A full-table scan is always sub-optimal.


Correct Option: B

Which character is used to continue a statement in SQL*Plus?

  1. / '

    • '
    • '
  2. = '


Correct Option: C

Which Oracle access method is the fastest way for Oracle to retrieve a single row?

  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan


Correct Option: C

To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?

  1. 8

  2. 3

  3. 2

  4. 4


Correct Option: B
  1. Indexes are only used in special cases

  2. Indexes are used to make table storage more efficient

  3. Indexes rarely make a difference in SQL performance

  4. Indexes exist solely to improve query speed


Correct Option: D

Which is a major problem with SQL?

  1. SQL cannot support object-orientation

  2. The same query can be written in many ways, each with vastly different execution plans.

  3. SQL syntax is too difficult for non-computer professionals to use

  4. SQL creates excessive locks within the database


Correct Option: B

What was a problem with navigational data access languages?

  1. The user had to have knowledge of the table and index structures

  2. Navigational data access was far slower than declarative access.

  3. Navigational access languages required the coder to embed their queries inside a procedural language shell.

  4. Navigational languages were far slower then SQL


Correct Option: A

INTERVAL PARTITIONING IS NOT SUPPORTED FOR INDEX-ORGANIZED TABLES.

  1. True

  2. False


Correct Option: A
  1. FOR EACH ROW trigger on the EMP table

  2. Statement-level Trigger on the EMP table

  3. FOR EACH ROW trigger on the AUDIT_TABLE table

  4. Statement-level Trigger on the AUDIT_TABLE


Correct Option: A
  1. Trigger type

  2. Trigger body

  3. Trigger event

  4. Trigger Timing


Correct Option: A

Examine this code CREATE OR REPLACE TRIGGER SECURE_emp BEFORE LOGON ON EMP BEGIN ............. END WHAT TYPE OF TRIGGER IS IT ?

  1. DML trigger

  2. Invalid Trigger

  3. Application Trigger

  4. System Event trigger


Correct Option: B
- Hide questions