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

Which of the following is used to indicate a column will not accept NULL values and can be referenced in another table's foreign key specification?

  1. Check constraint

  2. Default constraint

  3. Unique constraint

  4. Informational constraint


Correct Option: C

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

Which of the following causes a lock that is being held by an application using the Cursor Stability isolation level to be released?

  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

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

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 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 peta byte =

  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

Which one of these files stores the location of disk components....?

  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

which one is the function in SQL...?

  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