0

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?

  1. SMALLINT

  2. INTEGER

  3. DOUBLE

  4. NUMERIC


Correct Option: C

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

  1. ALTER

  2. INSERT

  3. DELETE

  4. UPDATE


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