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

This was last published in July 2007

Dig Deeper on Data management jobs, training and certification

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSQLServer

Close