Question 1

For auto-increment in oracle,sql command is written with the keyword?

technology databases

auto_increment
sequence
identity
increment

Answer

Correct Option: B

Question 2

Memo is an sql data type in oracle.

technology databases

True
False

Answer

Correct Option: B

Question 3

Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?

technology databases

Task Center
Command Editor
Design Advisor
Command Line Processor

Answer

Correct Option: B

Question 4

Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?

technology databases

DB2 Express Edition
DB2 Personal Edition
DB2 Workgroup Server Edition
DB2 Enterprise Server Edition

Answer

Correct Option: C

Question 5

Which of the following is NOT a valid method of authentication that can be used by DB2 9?

technology databases

SERVER
SERVER_ENCRYPT
CLIENT
DCS

Answer

Correct Option: D

Question 6

An alias can be an alternate name for which of the following DB2 objects?

technology databases

Sequence
View
Trigger
Schema

Answer

Correct Option: B

Question 7

Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?

technology databases

Sequence
Identity column
Trigger
Table function

Answer

Correct Option: A

Question 8

Which of the following events will NOT cause a trigger to be activated?

technology databases

A select operation
An insert operation
An update operation
A delete operation

Answer

Correct Option: A

Question 9

Which of the following DB2 objects is NOT considered executable using SQL?

technology databases

Routine
Function
Procedure
Trigger

Answer

Correct Option: D

Question 10

Which of the following is a valid DB2 data type?

technology databases

NUMBER
INTERVAL
NUM
BYTE

Answer

Correct Option: C

Question 11

Which of the following DB2 data types can NOT be used to create an identity column?

technology databases

SMALLINT
INTEGER
DOUBLE
NUMERIC

Answer

Correct Option: C

Question 12

Which of the following actions will NOT cause a trigger to be fired?

technology databases

ALTER
INSERT
DELETE
UPDATE

Answer

Correct Option: A

Question 13

What command eliminates the duplicates.

technology databases

union
union all
inner join
outer join

Answer

Correct Option: B

Question 14

What is the utility used to check the performance of the DB2 SQL query

technology databases

Explain
Xpeditor
Alchemist
Abendaid

Answer

Correct Option: A

Question 15

A plan is a collection of

technology databases

Binds
DBRMs
Packages
Collections

Answer

Correct Option: C

Question 16

The number of levels of subqueries we could use in the SQL is

technology databases

13
255
78
15

Answer

Correct Option: D

Question 17

The utility used to rearrange the space in the tables is

technology databases

Reorg
Runstats
Rebinds
Load

Answer

Correct Option: A

Question 18

Which is not a type of constraint

technology databases

primary key
unique
null
check

Answer

Correct Option: C

Question 19

Oracle server generates a name by using which format

technology databases

sys_cn
ora_cn
tab_cn
col_cn

Answer

Correct Option: A

Question 20

Constraints are defined at which level

technology databases

row, column
row, table
column, table
all of above

Answer

Correct Option: C

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

databases Online Quiz - 122

Find more quizzes from top tags