Question 1

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 2

what is the maximum number of triggers can apply on a single table

technology databases

4
no limit
24
12

Answer

Correct Option: D

Question 3

When you open a cursor, DB2 will always get all rows that meet the selection criteria and create a result set?

technology databases

Yes
No
It Depends
None of the above

Answer

Correct Option: B

Question 4

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 5

When the program name is not in the plan, we get

technology databases

-810
-801
-805
-825

Answer

Correct Option: C

Question 6

B37 abend during SPUFI is due to

technology databases

Space Issues
Data Issues
No records found while querying the table
Both a & b

Answer

Correct Option: A

Question 7

An application has acquired a Share lock on a row in a table and now wishes to update the row. Which of the following statements is true?

technology databases

The application must release the row-level Share lock it holds and acquire an Update lock on the row
The application must release the row-level Share lock it holds and acquire an Update lock on the table
The row-level Share lock will automatically be converted to a row-level Up-date lock
The row-level Share lock will automatically be escalated to a table-level Up-date lock

Answer

Correct Option: C

Question 8

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 9

What authority is required to create a table?

technology databases

ADMIN Privileges
CREATETAB Privileges
No Privileges
USERTAB Privileges

Answer

Correct Option: B

Question 10

Given the following scenario: Table TABLE1 needs to hold specific numeric values up to 9999999.999 in column COL1. Once TABLE1 is populated, arithmetic operations will be performed on data stored in col-umn COL1. Which of the following would be the most appropriate DB2 data type to use for column COL1?

technology databases

INTEGER
REAL
NUMERIC (7,3)
DECIMAL(10,3)

Answer

Correct Option: D

Question 11

Which of the following tools can be used to automate table reorganization Operations ?

technology databases

Control Center
Command Center
Command Line Processor
Task Center

Answer

Correct Option: D

Question 12

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 13

Given the following statement: CREATE TABLE t1 col1 SMALLINT NOT NULL PRIMARY KEY, col2 VARCHAR(200) NOT NULL WITH DEFAULT NONE, col3 DECIMAL(5,2) CHECK (col3 >= 100.00), col4 DATE NOT NULL WITH DEFAULT) Which of the following definitions will cause the CREATE TABLE statement to fail?

technology databases

COL1
COL2
COL3
COL4

Answer

Correct Option: B

Question 14

When you open a cursor, DB2 will always get all rows that meet the selection criteria and create a result set?

technology databases

Yes
No
It Depends
None of the above

Answer

Correct Option: B

Question 15

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 16

When the program name is not in the plan, we get

technology databases

-810
-801
-805
-825

Answer

Correct Option: C

Question 17

B37 abend during SPUFI is due to

technology databases

Space Issues
Data Issues
No records found while querying the table
Both a & b

Answer

Correct Option: A

Question 18

An application has acquired a Share lock on a row in a table and now wishes to update the row. Which of the following statements is true?

technology databases

The application must release the row-level Share lock it holds and acquire an Update lock on the row
The application must release the row-level Share lock it holds and acquire an Update lock on the table
The row-level Share lock will automatically be converted to a row-level Up-date lock
The row-level Share lock will automatically be escalated to a table-level Up-date lock

Answer

Correct Option: C

Question 19

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 20

What authority is required to create a table?

technology databases

ADMIN Privileges
CREATETAB Privileges
No Privileges
USERTAB Privileges

Answer

Correct Option: B

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

databases Online Quiz - 198

Find more quizzes from top tags