databases Online Quiz - 203

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

Which datatype you use to store a large block of text data having size around 3,500 characters in length ?

  1. CLOB

  2. BLOB

  3. BFILE


Correct Option: D

Which of the following are transactional control commands? A.COMMIT B.UPDATE C.SAVEPOINT D.SET TRANSACTIONS





Correct Option: A,C,D

The scale of a numeric value is the total length allowed for values.

  1. True

  2. False

Correct Option: B

A SAVEPOINT actually saves transactions after a specified amount of transactions have executed.

  1. True

  2. False

Correct Option: B

The HAVING clause tells the GROUP BY which groups to include.

  1. True

  2. False

Correct Option: A

Which of the following statements about roles are true?

  1. Roles can be granted to other roles

  2. Privileges can be granted to roles

  3. Roles can be granted to synonyms

  4. Roles can be granted to users

Correct Option: A,B,D

Which of the following methods should you use to increase the number of nullable columns for a table?

  1. Use the alter table statement

  2. Ensure that all column values are NULL for all rows

  3. First, increase the size of adjacent column datatypes, and then add the column

  4. Add the column, populate the column, and then add the not NULL constraint

Correct Option: A

Once defined, how long will a variable remain defined in SQL*Plus?

  1. Until the database is shut down

  2. Until the instance is shut down

  3. Until the statement completes

  4. Until the session completes

Correct Option: D

Which of the following product will not accept remote database request?


  2. DB2 UDB PE

  3. DB2 UDB WSE

  4. DB2 UDB ESE

Correct Option: B
  1. SQL statements


  3. DDL

  4. Database configuration parameter settings

Correct Option: D

What is the prefix key for executing an OS command in the DB2 CLP?

  1. &

  2. %

  3. !

  4. @

Correct Option: C

Which of the following tool allows you to display data of a table?

  1. Task Center

  2. Command Center

  3. Health Center

  4. All of above

Correct Option: B
- Hide questions