The following question is taken from DB2 9 Fundamentals Certification Study Guide, by Roger E. Sanders (copyright...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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