Question 1

Which one is not the output of the LOAD utility

technology databases

Loaded table or partition
Discard file of rejected records
Summary report of errors encountered
Updated system catalog table stats

Answer

Correct Option: D

Question 2

Which utility is used to insert bulk amount of data in to a table.

technology databases

LOAD
UNLOAD
INSERT
RUNSTATS

Answer

Correct Option: A

Question 3

Which utility is used to reclaim fragmented space

technology databases

LOAD
UNLOAD
REORG
RUNSTATS

Answer

Correct Option: C

Question 4

Which utility is used to update the data related to tablespaces & indexes in system catalog tables

technology databases

LOAD
UNLOAD
REORG
RUNSTATS

Answer

Correct Option: D

Question 5

Which one is the correct option for taking unload from the table EMPTAB

technology databases

UNLOAD TABLE DSN1DB04.EMPTABSP
UNLOAD TABLESPACE DSN1DB04.EMPTABSP
UNLOAD DATABASE DSN1DB04.EMPTABSP
UNLOAD DATABASE DSN1DB04 EMPTABSP

Answer

Correct Option: B

Question 6

) While doing loading, data is sorted and then loaded into table (True or False)

technology databases

True
False

Answer

Correct Option: B

Question 7

While doing loading , indexes are built automatically(True or False)

technology databases

True
False

Answer

Correct Option: A

Question 8

No need to use RUNSTATS when

technology databases

a table is unloaded
a table is loaded
an index is created
a table is reorganized

Answer

Correct Option: A

Question 9

Which utility should be used for maintaining referential integrity between two tables

technology databases

LOAD
CHECK
REORG
RUNSTATS

Answer

Correct Option: B

Question 10

Which utility should be used for maintaining consistency for list of tablespaces

technology databases

QUIESCE
CHECK
REORG
RUNSTATS

Answer

Correct Option: A

Question 11

Which utility should be used to restore DB2 tablespaces and indexes to a specific instance

technology databases

QUIESCE
RECOVER
REORG
RUNSTATS

Answer

Correct Option: B

Question 12

Which utility should be used to obtain the access paths details?

technology databases

QUIESCE
EXPLAIN
REORG
RUNSTATS

Answer

Correct Option: B

Question 13

To create a trigger you need the following option

technology databases

Triggering Table
Triggering Event
Triggered Action
All the above

Answer

Correct Option: D

Question 14

Triggers can not be used for

technology databases

Validate input data
Automatically generate values for newly inserted rows
support alerts
To Implement Referential Integrity

Answer

Correct Option: D

Question 15

Choose the correct options on acquiring locks

technology databases

If transaction A holds X lock on row R, If transaction B requests for S lock, then B would go into wait state until A releases the lock
If transaction A holds S lock on row R, If transaction B requests for S lock, then B would be granted the lock
If transaction A holds X lock on row R, If transaction B requests for X lock,then B would be granted the lock.
If transaction A holds S lock on row R, If transaction B requests for X lock, then B would be granted the lock

Answer

Correct Option: A,B

Question 16

Choose the correct options on LOCKSIZE

technology databases

Database
Tablespace
Table
View

Answer

Correct Option: B,C

Question 17

Referential constraint is

technology databases

Designates the values that columns of a table can contain
The limiting of a set of foreign key values to a set of primary key values
The limiting of a set of Primary key values to a set of foreign key values
None of the above

Answer

Correct Option: B

Question 18

When acquiring Tablespace lock more data is restricted than page level Lock (True or False)

technology databases

True
False

Answer

Correct Option: A

Question 19

Triggers can be defined on a system catalog table (True or False)

technology databases

True
False

Answer

Correct Option: B

Question 20

MERGECOPY utility combines multiple incremental image copies into a full Image copy. ( True or False)

technology databases

True
False

Answer

Correct Option: A

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

databases Online Quiz - 177

Find more quizzes from top tags