0

databases Online Quiz - 211

Description: databases Online Quiz - 211
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. The database is in mount state.

  2. One of the tablespaces is offline.

  3. One of the tablespaces is read only.

  4. The database operates in ARCHIEVELOG mode.

  5. The database operates in NOARCHIEVELOG mode.


Correct Option: E

Which statement regarding the contents of the V$PARAMETER view is true?

  1. Displays only the list of default values

  2. Displays only the list of all basic parameters

  3. Displays the currently in effect parameter values

  4. Displays only the list of all advanced parameters

  5. Displays the list of all the parameter files of a database

  6. Displays the current contents of the server parameter file.


Correct Option: C
  1. Hot backup

  2. Online backup

  3. consistent backup

  4. incremental backup

  5. inconsistent backup


Correct Option: C
  1. When an entire index is scanned to locate rows we call it as index scan

  2. When only part of the index is scanned to locate rows we call it as index scan

  3. When all the rows are scanned we call it as index scan

  4. None of the above


Correct Option: A

What does SPUFI stands for

  1. SQL Programming Using File Input

  2. SQL Processing Using File Input

  3. SQL Processor Using File Input

  4. Sequence Processing Using File Input


Correct Option: C
  1. Complex Key

  2. Secondary Key

  3. Composite Key

  4. Foreign Key


Correct Option: C

For which database object can a lock be obtained

  1. a database directory

  2. a database tablespace

  3. a database bufferpool

  4. a database column


Correct Option: B
  1. define the name of the package

  2. provide an alias for the package

  3. define the schema of the package

  4. define the database of the package


Correct Option: C
  1. Removes all the statements in source code

  2. Replaces all the SQL statements into corresponding host language CALL statements

  3. Replaces SQL statements into corresponding host language statements

  4. None of the above


Correct Option: B
  1. BIND

  2. REBIND

  3. Both A & B

  4. None of the above


Correct Option: C

A Package is

  1. A single, bound DBRM

  2. A Multi bound DBRM with optimised access paths

  3. A Single bound DBRM with optimised access paths

  4. A Multi bound DBRM


Correct Option: C
  1. Edited form of the SQL statements with some additional information

  2. Complied version of SQL statements

  3. Complied version of source code

  4. None of the above


Correct Option: A

Which is the system that DB2 uses for locking

  1. LOCK Manager

  2. Resource Manager

  3. IRLM

  4. None of the above


Correct Option: C

A Plan

  1. Is an executable module containing access path logic provided by the DB2 optimiser

  2. In an non executable module containing access path logic provide by the DB2 optimiser

  3. Is just a module containing access path to DB2 optimiser

  4. Is a module containing access path


Correct Option: A

What will the FREE command do to a plan

  1. It will drop the existing plan

  2. It will delete the existing plan

  3. Both a & b

  4. None of the above


Correct Option: C

Can a UNION and a JOIN be used in the same SELECT statement

  1. YES

  2. NO

  3. Cant say

  4. Depends on the query


Correct Option: B

Bind component Produces

  1. Only Package

  2. Only application plan

  3. Both A & B

  4. None of the above


Correct Option: C
- Hide questions