0

databases Online Quiz - 221

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

What authority is required to create a table?

  1. ADMIN Privileges

  2. CREATETAB Privileges

  3. No Privileges

  4. USERTAB Privileges


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
  1. The cursor is moved to another row

  2. The row the cursor is on is deleted by the application

  3. The row the cursor is on is deleted by another application

  4. The row the cursor is on needs to be updated by another application


Correct Option: B

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

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
  1. Backup purposes

  2. Storing intermediate results

  3. Staging area for load operations

  4. Sharing result data sets between applications


Correct Option: B
  1. SELECT COUNT *

  2. SELECT COUNT(*)

  3. SELECT COUNT[*]

  4. SELECT COUNT(ALL)


Correct Option: B

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

To run abcd.sql Script, what is the syntax....?

  1. @abcd.sql

  2. @abcd

  3. get abcd.sql /

  4. all the above


Correct Option: D

which one is not the output of Desc ...?

  1. name

  2. null

  3. type

  4. null?


Correct Option: B
  1. 512 peta bytes

  2. 1024 peta byes

  3. 512 nano bytes

  4. 1024 giga bytes


Correct Option: A
  1. 1*1024 pow 3 bytes

  2. 1*1024 pow 4 bytes

  3. 1*1024 pow 5 bytes

  4. 1*1024 pow 6 byes


Correct Option: C
  1. parameter files

  2. control files

  3. redo logs

  4. data files


Correct Option: B

Which one is the SQL*PLUS command...?

  1. jump

  2. run

  3. walk

  4. sleep


Correct Option: B
  1. soundex

  2. lightex

  3. weightex

  4. lux


Correct Option: A

The function which gives the storage of x in bytes..?(X may be the column)

  1. usize(x)

  2. vsize(x)

  3. wsize(x)

  4. xsize(x)


Correct Option: B

which one is the Oracle function in SQL...?

  1. floor

  2. window

  3. door

  4. ground


Correct Option: A

which keyword can be placed in trim function...?

  1. tailoring

  2. travelling

  3. trailing

  4. trucking


Correct Option: C
- Hide questions