0

databases Online Quiz - 177

Description: databases Online Quiz - 177
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Loaded table or partition

  2. Discard file of rejected records

  3. Summary report of errors encountered

  4. Updated system catalog table stats


Correct Option: D
  1. UNLOAD TABLE DSN1DB04.EMPTABSP

  2. UNLOAD TABLESPACE DSN1DB04.EMPTABSP

  3. UNLOAD DATABASE DSN1DB04.EMPTABSP

  4. UNLOAD DATABASE DSN1DB04 EMPTABSP


Correct Option: B
  1. a table is unloaded

  2. a table is loaded

  3. an index is created

  4. a table is reorganized


Correct Option: A

Which utility should be used for maintaining referential integrity between two tables

  1. LOAD

  2. CHECK

  3. REORG

  4. RUNSTATS


Correct Option: B

To create a trigger you need the following option

  1. Triggering Table

  2. Triggering Event

  3. Triggered Action

  4. All the above


Correct Option: D
  1. Validate input data

  2. Automatically generate values for newly inserted rows

  3. support alerts

  4. To Implement Referential Integrity


Correct Option: D
  1. If transaction A holds X lock on row R, If transaction B requests for S lock, then B would go into wait state until A releases the lock

  2. If transaction A holds S lock on row R, If transaction B requests for S lock, then B would be granted the lock

  3. If transaction A holds X lock on row R, If transaction B requests for X lock,then B would be granted the lock.

  4. If transaction A holds S lock on row R, If transaction B requests for X lock, then B would be granted the lock


Correct Option: A,B
  1. Database

  2. Tablespace

  3. Table

  4. View


Correct Option: B,C

Referential constraint is

  1. Designates the values that columns of a table can contain

  2. The limiting of a set of foreign key values to a set of primary key values

  3. The limiting of a set of Primary key values to a set of foreign key values

  4. None of the above


Correct Option: B
- Hide questions