IBM DB2 9 Fundamentals certification (Exam 730): Sample question No. 2

Answer this sample question from the IBM DB2 9 Fundamentals certification exam (Exam 730) to test your knowledge of DB2 9. Then, read an explanation of the correct answer.

The following question is taken from DB2 9 Fundamentals Certification Study Guide, by Roger E. Sanders (copyright 2007) and is reprinted here with permission from MC Press.

Test your knowledge of DB2 9 by answering the question below, which is from a real, previous DB2 9 Fundamentals exam (Exam 730). When you are finished, check your answer and read an explanation using the answer key.

IBM DB2 9 Fundamentals certification exam study guide

 

If the following SQL statements are executed in the order shown:

 

CREATE TABLE orders

(order_num INTEGER NOT NULL, buyer_name VARCHAR(35), amount NUMERIC(5,2));

CREATE UNIQUE INDEX idx_orderno ON orders(order_num);

 

Which of the following describes the resulting behavior?

 

A. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows should be displayed in order of increasing ORDER_NUM values

B. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows will be displayed in no particular order

C. Duplicate ORDER_NUM values are allowed; no other index can be created for the ORDERS table that reference the ORDER_NUM column

D. Every ORDER_NUM value entered must be unique; no other index can be created for the ORDERS table that reference the ORDER_NUM column

 

•           Read the answer and explanation

•           Go back to the list of exam questions

Dig Deeper on Data management jobs, training and certification

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSQLServer

Close