C2090-610 Online Practice Questions and Answers

If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database?

A. 4

B. 8

C. 16

D. 32

When is it appropriate to use a sequence?

A. When you want to control the order in which triggers are fired.

B. When you want to control the order in which stored procedures can be invoked.

C. When you want to automatically generate a numeric value that is not tied to any specific column or table.

D. When you want to automatically generate a numeric value for each row that is added to a specific table.

Which two activities indicate the need for a data warehouse? (Choose two.)

A. Confirm product inventory.

B. Monitor product availability.

C. Summarize sales by region.

D. Identify patterns for products sold in the last five years.

E. Associate one or more products with a purchase order.

Which two operations are allowed in the body of an SQL scalar user-defined function? (Choose two.)

A. CALL statements.

B. External file access.

C. Use of a scratch pad.

D. COMMIT statements.

E. SQL control statements.

What is the purpose of a role?

A. To define exactly what a specific user can do within a particular database once they have been authenticated.

B. To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users.

C. To establish a credible relationship between DB2 and an external entity, such as a database administrator or a middleware server.

D. To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges.

A table named EMPLOYEE was created as follows:

Which action will prevent unauthorized users from accessing SSN data?

A. Assign the SSN column to a restricted role that only authorized users can access.

B. Only grant ACCESSCTRL authority for the SSN column to users who need to access SSN data.

C. Alter the table definition so that SSN data is stored in a separate schema that only authorized users can access.

D. Create a view for the EMPLOYEE table that does not contain the SSN column and require unauthorized users to use the view.

Which statement is true about an index that is used to support a UNIQUE constraint?

A. It must not contain more than one column.

B. It cannot be used in a referential constraint.

C. It must be defined with the UNIQUE attribute.

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

Which statement is true regarding constraints?

A. A table can only have one unique key constraint.

B. A table can have multiple primary key constraints.

C. Informational constraints tell DB2 what rules the data conforms to, but the rules are not enforced.

D. Foreign key constraints are enforced on the values within the rows of a table, or between the rows of two tables, by a unique index on a foreignkey.

Which type of table should you use if you want to define specific time periods when data is valid?

A. Materialized query table

B. System-period temporal table

C. Declared global temporary table

D. Application-period temporal table

Which object can a buffer pool be assigned to?

A. Schema

B. Table space

C. Storage group

D. Stored procedure

Which DB2 product is NOT suitable for very large data warehouse applications?

A. DB2 for i

B. DB2 for AIX

C. DB2 for z/OS

D. DB2 for Linux

Which statement about roll back operations is correct?

A. When a ROLLBACK statement is executed, all locks held by the terminating transaction are released.

B. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the savepoint are released.

C. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the savepoint are released.

D. When a ROLLBACK statement is executed, all locks acquired for open cursors that were declared WITH HOLD, are held.

Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE?

A. SELECT * FROM employee WHERE salary < 100000

B. SELECT salary FROM employee WHERE salary > 100000

C. SELECT salary FROM employee WHERE salary > 100,000.00

D. SELECT * FROM employee WHERE salary GREATER THAN 100000

What are INSTEAD OF triggers used for?

A. To update data in other tables.

B. To perform insert, update, and delete operations against complex views.

C. To check or modify values before they are actually stored in a database.

D. To run non-database operations that are coded in user-defined functions.

Which data type should be used to store data in a column that represents money and accurately returns a two position scale?

A. BIGINT

B. BINARY

C. DOUBLE

D. DECIMAL