databases Online Quiz - 122

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

For auto-increment in oracle,sql command is written with the keyword?

  1. auto_increment

  2. sequence

  3. identity

  4. increment

Correct Option: B

Memo is an sql data type in oracle.

  1. True

  2. False

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

Which of the following events will NOT cause a trigger to be activated?

  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 is a valid DB2 data type?



  3. NUM

  4. BYTE

Correct Option: C

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

What command eliminates the duplicates.

  1. union

  2. union all

  3. inner join

  4. outer join

Correct Option: B

What is the utility used to check the performance of the DB2 SQL query

  1. Explain

  2. Xpeditor

  3. Alchemist

  4. Abendaid

Correct Option: A

A plan is a collection of

  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

The utility used to rearrange the space in the tables is

  1. Reorg

  2. Runstats

  3. Rebinds

  4. Load

Correct Option: A

Which is not a type of constraint

  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

Constraints are defined at which level

  1. row, column

  2. row, table

  3. column, table

  4. all of above

Correct Option: C
- Hide questions