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

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 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

Which of the following is NOT a valid method of authentication that can be used by DB2 9?

  1. SERVER

  2. SERVER_ENCRYPT

  3. CLIENT

  4. DCS


Correct Option: D

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?

  1. NUMBER

  2. INTERVAL

  3. NUM

  4. BYTE


Correct Option: C

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

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