0

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

  4. VARCHAR2


Correct Option: D

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

  1. COMMIT

  2. UPDATE

  3. SAVEPOINT

  4. 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 AVG function returns an average of all rows from a select column including any NULL values.

  1. True

  2. False


Correct Option: B

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?

  1. DB2 UDB WSUE

  2. DB2 UDB PE

  3. DB2 UDB WSE

  4. DB2 UDB ESE


Correct Option: B
  1. SQL statements

  2. Views

  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