IBM Assessment: DB2 10.1 Fundamentals - A2090-610 Exam Practice Test

A. Multiple primary keys can be defined for a table.

B. A primary key can be referenced by only one foreign key.

C. A foreign key can reference multiple primary keys.

D. Primary keys and foreign keys are used to define relationships.

A. Joe Smith

B. Joe Smith

C. Joe Smith>DB2

D. Joe Smith

A. The column mask must be enabled (column access control for the EMPLOYEE table will be activated automatically).

B. The EMPLOYEE table must be altered to activate column access control; row permission must be granted to everyone who needs to use thecolumn mask.

C. The EMPLOYEE table must be altered to activate column access control (the column mask will be enabled automatically).

D. The column mask must be enabled; the EMPLOYEE table must be altered to activate column access control.

A. It must be defined as UNIQUE WHERE NOT NULL.

B. It cannot be used in a referential constraint.

C. It must be defined with the UNIQUE attribute.

D. It must not contain more than one column.

A. Buffer space

B. Table size

C. Available real storage

D. Number of locks

A. Triggers can only be fired one time per statement irrespective of the number of rows affected.

B. Only one INSERT, UPDATE, or DELETE trigger can be defined per table.

C. Triggers cannot be modified, they must be dropped and recreated with new definitions.

D. Adding a trigger to a table that already has rows in it will cause triggered actions to be fired.

A. CREATE DISTINCT ALIAS canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

B. CREATE DISTINCT TYPE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

C. CREATE DISTINCT FUNCTION canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

D. CREATE DISTINCT PROCEDURE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

A. SELECT name, COUNT(*) AS transactions FROM sales GROUP BY name

B. SELECT name, COUNT(DISTINCT name) AS transactions FROM sales

C. SELECT DISTINCT name, COUNT(*) AS transactions FROM sales GROUP BY transactions

D. SELECT name, COUNT(*) AS transactions FROM sales

A. SELECT dept_info(dept_id, dept_name)

B. SELECT TABLE dept_id, dept_name FROM dept_info()

C. SELECT dept_id, dept_name FROM dept_info()

D. SELECT dept_id, dept_name FROM TABLE(dept_info()) AS results

A. SELECT * FROM employee
WHERE (hiredate < '1999-01-01' AND salary < 40000
AND (education = 'University')

B. SELECT * FROM employee
WHERE (hiredate < '1999-01-01') OR (salary < 40000)
OR (education = 'University')

C. SELECT * FROM employee
WHERE (hiredate < '1999-01-01' AND salary < 40000)
OR (education = 'University')

D. SELECT * FROM employee
WHERE (hiredate < '1999-01-01' OR (salary < 40000
AND (education = 'University')