Tag: databases

Questions Related to databases

If there are frequent updates in tables, then which utility to use?

  1. BTEQ

  2. TPUMP

  3. FASTEXPORT

  4. MULTILOAD


Correct Option: B
  1. Not NULL

  2. Primary key

  3. Foreign key

  4. Composite primary keys


Correct Option: D
  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan


Correct Option: C
  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Undefined


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. Simplifies code reuse, code standardization and code maintenance

  2. Controlled access to other database objects

  3. Improving application performance

  4. DB2 Stored Procedures can be written only in SQL.


Correct Option: D