IBM DB2 9 Fundamentals certification (Exam 730): Answer key No. 2

Get the answer and a detailed explanation to a sample question from the IBM DB2 9 Fundamentals certification exam (Exam 730).

IBM DB2 9 Fundamentals certification exam study guide

 

The correct answer is 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.

 

If the UNIQUE clause is specified when the CREATE INDEX statement is executed, rows in the table associated with the index will not have two or more occurances of the same values in the set of columns that make up the index key.

Furthermore...

 

•           To read the rest of this question's explanation and to practice with more sample questions from the IBM DB2 9 Fundamentals exam (Exam 730), purchase the book at MC Press.

•           Go back to the list of sample exam questions.

 

This was first published in July 2007

Dig deeper on IBM DB2 management

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close