Question 1

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?

technology databases

Check constraint
Default constraint
Unique constraint
Informational constraint

Answer

Correct Option: C

Question 2

What authority is required to create a table?

technology databases

ADMIN Privileges
CREATETAB Privileges
No Privileges
USERTAB Privileges

Answer

Correct Option: B

Question 3

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

technology databases

CONNECT
CONTROL
SYSMAINT
EXECUTE

Answer

Correct Option: C

Question 4

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

technology databases

Uncommitted Read
Cursor Stability
Read Stability
Repeatable Read

Answer

Correct Option: D

Question 5

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

technology databases

The cursor is moved to another row
The row the cursor is on is deleted by the application
The row the cursor is on is deleted by another application
The row the cursor is on needs to be updated by another application

Answer

Correct Option: B

Question 6

What is the restriction on using UNION in embedded SQL ?

technology databases

It has to be in a CURSOR
cannot be used in Embedded SQL
No restrictions
None of the above

Answer

Correct Option: A

Question 7

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

technology databases

Uncommitted Read
Cursor Stability
Read Stability
Repeatable Read

Answer

Correct Option: D

Question 8

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

technology databases

Backup purposes
Storing intermediate results
Staging area for load operations
Sharing result data sets between applications

Answer

Correct Option: B

Question 9

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

technology databases

SELECT COUNT *
SELECT COUNT(*)
SELECT COUNT[*]
SELECT COUNT(ALL)

Answer

Correct Option: B

Question 10

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

technology databases

Uncommitted Read
Cursor Stability
Read Stability
Repeatable Read

Answer

Correct Option: D

Question 11

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

technology databases

@abcd.sql
@abcd
get abcd.sql /
all the above

Answer

Correct Option: D

Question 12

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

technology databases

name
null
type
null?

Answer

Correct Option: B

Question 13

How much data will be stored in oracle 9i Database..?

technology databases

512 peta bytes
1024 peta byes
512 nano bytes
1024 giga bytes

Answer

Correct Option: A

Question 14

1 peta byte =

technology databases

1*1024 pow 3 bytes
1*1024 pow 4 bytes
1*1024 pow 5 bytes
1*1024 pow 6 byes

Answer

Correct Option: C

Question 15

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

technology databases

parameter files
control files
redo logs
data files

Answer

Correct Option: B

Question 16

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

technology databases

jump
run
walk
sleep

Answer

Correct Option: B

Question 17

which one is the function in SQL...?

technology databases

soundex
lightex
weightex
lux

Answer

Correct Option: A

Question 18

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

technology databases

usize(x)
vsize(x)
wsize(x)
xsize(x)

Answer

Correct Option: B

Question 19

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

technology databases

floor
window
door
ground

Answer

Correct Option: A

Question 20

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

technology databases

tailoring
travelling
trailing
trucking

Answer

Correct Option: C

Description: databases Online Quiz - 221
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 221

Find more quizzes from top tags