0

databases Online Quiz - 197

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

Which of the following tools can be used to automate table reorganization Operations ?

  1. Control Center

  2. Command Center

  3. Command Line Processor

  4. Task Center


Correct Option: D

How do you find the total number of rows in a table ?

  1. SELECT COUNT *

  2. SELECT COUNT(*)

  3. SELECT COUNT[*]

  4. SELECT COUNT(ALL)


Correct Option: B

Which authority or privilege is granted by the DB2 Database Manager configuration file?

  1. CONNECT

  2. CONTROL

  3. SYSMAINT

  4. EXECUTE


Correct Option: C

Which of the following isolation levels will lock all rows scanned to build a result data set?

  1. Uncommitted Read

  2. Cursor Stability

  3. Read Stability

  4. Repeatable Read


Correct Option: D

What is the picture clause of the null indicator variable

  1. S9 (4) COMP-3

  2. S9 (4)

  3. 9 (4)

  4. S9 (4) COMP


Correct Option: D
  1. SYNONYM

  2. ALIAS

  3. All of the above

  4. None of the above


Correct Option: A

A collection of named objects is called ______

  1. Schema

  2. Table

  3. Alias

  4. Both a & b


Correct Option: A

The maximum number of tables that can be joined is _____________

  1. 20

  2. 10

  3. 15

  4. No Limit.


Correct Option: C
  1. Joins

  2. Unions

  3. Nested SELECT

  4. All of the above


Correct Option: D

What is the restriction on using UNION in embedded SQL ?

  1. It has to be in a CURSOR

  2. cannot be used in Embedded SQL

  3. No restrictions

  4. None of the above


Correct Option: A
  1. Restrict users' access to a subset of table data

  2. Ensure that rows inserted remain within the scope of a definition

  3. Produce an action as a result of a change to a table

  4. Provide users with an alternate view of table data


Correct Option: C

Which of the following isolation levels will lock all rows scanned to build a result data set?

  1. Uncommitted Read

  2. Cursor Stability

  3. Read Stability

  4. Repeatable Read


Correct Option: D

A declared temporary table is used for which of the following purposes?

  1. Backup purposes

  2. Storing intermediate results

  3. Staging area for load operations

  4. Sharing result data sets between applications


Correct Option: B

The identity value will be rolled back when the transaction that tried to insert the value into the table is not committed or rolled back

  1. True

  2. False


Correct Option: B
- Hide questions