Question 1:

Which authority or privilege is granted by the DB2 Database Manager configuration file?

A. CONNECT
B. CONTROL
C. SYSMAINT
D. EXECUTE

Answer 1:

The correct answer is C. The instance-level authorities available (SYSADM, SYSCTRL, SYSMAINT, and SYSMON) can only be given to a group of users and the names of the groups that have been given these authorities are recorded in the DB2 Database Manager configuration files that are associated with each instance.

Question 2:

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

Answer 2:

The correct answer is A. 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 occurrences of the same values in the set of columns that make up the index key. Furthermore, the creation of an index provides a logical ordering of the rows of a table so in this example, rows inserted into the ORDERS table will be ordered by ORDER_NUM values, in ascending order.