databases Online Quiz - 122

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

Memo is an sql data type in oracle.

  1. True

  2. False

Correct Option: B

Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?

  1. Task Center

  2. Command Editor

  3. Design Advisor

  4. Command Line Processor

Correct Option: B

Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?

  1. DB2 Express Edition

  2. DB2 Personal Edition

  3. DB2 Workgroup Server Edition

  4. DB2 Enterprise Server Edition

Correct Option: C

An alias can be an alternate name for which of the following DB2 objects?

  1. Sequence

  2. View

  3. Trigger

  4. Schema

Correct Option: B

Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?

  1. Sequence

  2. Identity column

  3. Trigger

  4. Table function

Correct Option: A
  1. A select operation

  2. An insert operation

  3. An update operation

  4. A delete operation

Correct Option: A

Which of the following DB2 objects is NOT considered executable using SQL?

  1. Routine

  2. Function

  3. Procedure

  4. Trigger

Correct Option: D

Which of the following DB2 data types can NOT be used to create an identity column?





Correct Option: C

Which of the following actions will NOT cause a trigger to be fired?

  1. ALTER




Correct Option: A
  1. union

  2. union all

  3. inner join

  4. outer join

Correct Option: B
  1. Binds

  2. DBRMs

  3. Packages

  4. Collections

Correct Option: C

The number of levels of subqueries we could use in the SQL is

  1. 13

  2. 255

  3. 78

  4. 15

Correct Option: D
  1. primary key

  2. unique

  3. null

  4. check

Correct Option: C

Oracle server generates a name by using which format

  1. sys_cn

  2. ora_cn

  3. tab_cn

  4. col_cn

Correct Option: A
  1. row, column

  2. row, table

  3. column, table

  4. all of above

Correct Option: C
- Hide questions