DB2 9 Family Fundamentals (C2090-730) Free Practice Test

Question 1

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

A. Command Editor

B. Developer Workbench

C. Task Center

D. Command Line Processor

Correct Answer: A

Question 2

Which of the following DB2 data types can be used to store 1000 MB of single-byte character data?

A. CLOB

B. DBCLOB

C. GRAPHIC

D. BLOB

Correct Answer: A

Question 3

Which of the following is a valid DB2 data type?

A. BYTE

B. INTERVAL

C. NUM

D. NUMBER

Correct Answer: C

Question 4

A table contains a list of all seats available at a football stadium. A seat consists of a section number, a seat number, and whether or not the seat has been assigned. A ticket agent working at the box office generates a list of all unassigned seats. When the agent refreshes the list, it should only change if another agent assigns one or more unassigned seats. Which of the following is the best isolation level to use for this application?

A. Repeatable Read

B. Uncommitted Read

C. Read Stability

D. Cursor Stability

Correct Answer: D

Question 5

An index named EMPID_X exists for a table named EMPLOYEE. Which of the following will allow user USER1 to drop the EMPID_X index?

A. GRANT DROP ON INDEXempid_x TO user1

B. GRANT CONTROL ON INDEXempid_x TO user1

C. GRANT INDEX ON TABLE employee TO user1

D. GRANT DELETE ON INDEXempid_x TO user1

Correct Answer: B

Question 6

Which of the following is a valid wildcard character in a LIKE clause of a SELECT statement?

A. *

B. \

C. %

D. ?

Correct Answer: C

Question 7

Application A holds an Exclusive lock on table TAB1 and needs to acquire an Exclusive lock on table TAB2. Application B holds an Exclusive lock on table TAB2 and needs to acquire an Exclusive lock on table TAB1. If lock timeout is set to -1 and both applications are using the Read
Stability isolation level, which of the following will occur?

A. Applications A and B will cause a deadlock situation

B. Application B will read the copy of table TAB1 that was loaded into memory when Application A first read it

C. Application B will be placed in a lock-wait state until ApplicationA releases its lock

D. Application B will read the data in table TAB1 and see uncommitted changes made by Application A

Correct Answer: A

Question 8

Given the following statement:
CREATE TABLE tab1
(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?

A. COL3

B. COL1

C. COL2

D. COL4

Correct Answer: C

Question 9

An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?

A. IMAGE

B. GRAPHIC

C. BLOB

D. BINARY

Correct Answer: C

Question 10

When does a view get populated?

A. Any time an executable SQL statement references it

B. When it is referenced in an INSERT statement

C. The first time any executable SQL statement references it

D. When it is created

Correct Answer: A

Question 11

Which of the following will provide user USER1 and all members of the group GROUP1 with the ability to perform DML, but no other operations on table TABLE1?

A. GRANT ALL PRIVILEGES EXCEPT ALTER, INDEX, REFERENCES ON TABLE table1 TO USER user1, GROUP group1

B. GRANT CONTROL ON TABLE table1 TO user1 AND group1

C. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO USER user1, GROUP group1

D. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO user1 AND group1

Correct Answer: C

Question 12

Assuming table TAB1 contains 100 rows, which of the following queries will return only half of the rows available?

A. SELECT * FROM tab1 FIND FIRST 50 ROWS

B. SELECT * FROM tab1 MAXROWS 50

C. SELECT * FROM tab1 WHILE ROW_NUM < 50

D. SELECT * FROM tab1 FETCH FIRST 50 ROWS ONLY

Correct Answer: D

Welcome to TestSimulate

IBM DB2 9 Family Fundamentals (C2090-730) Free Practice Test