Tag: databases

Questions Related to databases

INTERVAL PARTITIONING IS A PARTITIONING TECHNIQUE USED IN
technology databases

  1. ORACLE 11G

  2. ORACLE 10G

  3. ORACLE 9I

  4. ORACLE 9G

  5. ORACLE 11I

  6. ORACLE 8I

Show answer
Correct Option: A

MIXED NOTATION IS A FUNCTIONALITY USED IN
technology databases

  1. ORACLE 11G

  2. ORACLE 10G

  3. ORACLE 9I

  4. ORACLE 9G

  5. ORACLE 11I

  6. ORACLE 8I

Show answer
Correct Option: A

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

  1. DB_CREATE_FILE_DEST

  2. DB_CREATE_ONLINE_LOG_n

  3. USER_DUMP_DEST

  4. LOG_ARCHIVE_DEST

Show answer
Correct Option: A

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

  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.

Show answer
Correct Option: B

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

  1. / '

    • '
    • '

  4. = '

Show answer
Correct Option: C

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

technology databases

  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan

Show answer
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?

technology databases

  1. 8

  2. 3

  3. 2

  4. 4

Show answer
Correct Option: B

What best describes the relationship between indexes and SQL performance?

technology databases

  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

Show answer
Correct Option: D

Which is a major problem with SQL?
technology databases

  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

Show answer
Correct Option: B

What was a problem with navigational data access languages?
technology databases

  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

Show answer
Correct Option: A