DB2 9 Family Fundamentals - 000-730 Exam Practice Test

Question 1

Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?

A. REVOKE CONNECT ON DATABASE FROM USER tom

B. REVOKE ACCESS ON DATABASE FROM USER bob

C. REVOKE tom FROM ACCESS ON DATABASE BY USER bob

D. REVOKE tom FROM CONNECT ON DATABASE BY USER bob

Correct Answer: A

Question 2

What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?

A. Range

B. Check

C. Informational

D. Referential

Correct Answer: B

Question 3

Given the following table:
CURRENT_EMPLOYEES
EMPID INTEGER NOT NULL NAME CHAR(20) SALARY DECIMAL(10,2) PAST_EMPLOYEES
EMPID INTEGER NOT NULL
NAME CHAR(20)
SALARY DECIMAL(10,2)
Assuming both tables contain data, which of the following statements will NOT successfully add
data to table CURRENT_EMPLOYEES?

A. INSERT INTOcurrent_employees SELECT empid, name, salary FROM past_employees WHERE empid = 20

B. INSERT INTOcurrent_employees (name, salary) VALUES (SELECT name, salary FROM past_employees WHERE empid = 20)

C. INSERT INTOcurrent_employees (empid) VALUES (10)

D. INSERT INTOcurrent_employees VALUES (10, 'JAGGER', 85000.00)

Correct Answer: B

Question 4

A table called DEPARTMENT has the following columns: DEPT_ID DEPT_NAME MANAGER Which of the following statements will ONLY allow user USER1 to modify the DEPT_NAME column?

A. GRANT ALTER (dept_name) ON TABLE department TO user1

B. GRANT ALTER ON TABLE department TO user1

C. GRANT UPDATE (dept_name) ON TABLE department TO user1

D. GRANT UPDATE ON TABLE department TO user1

Correct Answer: C

Question 5

Which of the following CREATE TABLE statements will NOT be successful?

A. CREATE TABLE t1 (c1 XML CHECK (c1 IS VALIDATED), c2 INT)

B. CREATE TABLE t1 (c1 XML, c2 XML)

C. CREATE TABLE t1 (c1 XML NOT NULL UNIQUE, c2 INT)

D. CREATE TABLE t1 (c1 XML NOT NULL, c2CHAR(20))

Correct Answer: C

Question 6

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

A. Trigger

B. Sequence

C. Schema

D. Table

E. View

Correct Answer: D,E

Question 7

Which type of key is defined on the child table to implement a referential constraint?

A. Unique key

B. Composite key

C. Foreign key

D. Primary key

Correct Answer: C

Question 8

Which of the following database objects can be used to raise an error if a table is updated?

A. Trigger

B. Package

C. Stored Procedure

D. Informational Constraint

Correct Answer: A

Question 9

Which of the following is a valid DB2 data type?

A. BYTE

B. NUMBER

C. NUM

D. INTERVAL

Correct Answer: C

Question 10

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

A. Cursor Stability

B. Uncommitted Read

C. Repeatable Read

D. Read Stability

Correct Answer: C

Question 11

Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?

A. BLOB

B. Rows and columns

C. Hierarchically

D. CLOB

Correct Answer: C

Question 12

Which of the following can NOT be used to restrict specific values from being inserted into a column in a particular table?

A. Default constraint

B. Index

C. Check constraint

D. Referential constraint

Correct Answer: A

Question 13

Given the following two tables:
NAMES
NAME NUMBER
Wayne Gretzky 99 Jaromir Jagr 68 Bobby Orr 4 Bobby Hull 23 Brett Hull 16 Mario Lemieux 66 Mark Messier 11
POINTS
NAME POINTS
Wayne Gretzky 244 Jaromir Jagr 168 Bobby Orr 129 Brett Hull 121 Mario Lemieux 189 Joe Sakic 94
Which of the following statements will display the player name, number, and points for all players that have scored points?

A. SELECT p.name,n.number, p.points FROM names n RIGHT OUTER JOIN points p ON n.name = p.name

B. SELECT p.name,n.number, p.points FROM names n INNER JOIN points p ON n.name = p.name

C. SELECT p.name,n.number, p.points FROM names n FULL OUTER JOIN points p ON n.name = p.name

D. SELECT p.name,n.number, p.points FROM names n LEFT OUTER JOIN points p ON n.name = p.name

Correct Answer: A

IBM DB2 9 Family Fundamentals - 000-730 Exam Practice Test

Latest Update

Useful Links

Contact Us