C2090-610 Online Practice Questions and Answers

You have a business need to query DB2 10 and DB2 9 databases and you want to write an application that can run on most platforms unchanged. Which interface would you use to achieve your goal?

A. CLI

B. XML

C. JDBC

D. RUBY

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.

What factor influences lock escalation?

A. Table size

B. Buffer space

C. Number of locks

D. Available real storage

A table named STATES was created as follows:

What will happen?

A. An error will be returned and the operation will fail.

B. A warning will be returned and the unique index INDX1 will become the index for the primary key.

C. The primary key will be successfully added and the unique index INDX1 will be dropped and recreated as the primary key index.

D. The primary key will be successfully added, the unique index INDX1 will be dropped, and a new index will be created for the primary key.

Which statement about BEFORE triggers is FALSE?

A. A BEFORE trigger can be used to perform validation of input data.

B. A BEFORE trigger can be used to automatically generate values for newly inserted rows.

C. A BEFORE trigger is fired for each row in the set of affected rows before the trigger event executes.

D. A BEFORE trigger is fired for each row in the set of affected rows instead of executing the trigger event.

Which method for restricting data access relies on a SQL search condition that describes what set of rows a user has access to?

A. Authentication

B. Authorities and privileges

C. Label-based access control

D. Row and column access control

Which SQL statement will give a user named USER1 the ability to run an embedded SQL application named BENEFITS that calls a package named CORPDATA.PKGA?

A. GRANT EXECUTE ON APPLICATION benefits TO user1

B. GRANT EXECUTE ON PACKAGE corpdata.pkga TO user1

C. GRANT EXECUTE ON APPLICATION PACKAGE corpdata.pkga TO user1

D. GRANT EXECUTE ON APPLICATION benefits USING PACKAGE corpdata.pkga TO user1

A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL statement will produce the desired results?

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

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

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

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

Which event will NOT cause a trigger to be fired?

A. Execution of an INSERT statement.

B. Execution of LOAD REPLACE operation.

C. Execution of an INSERT operation of a MERGE statement.

D. Execution of an UPDATE operation of a MERGE statement.

What takes place when a process accesses a data object on which it already holds a lock, and the access mode requires a more restrictive lock than the one currently held?

A. Lock wait

B. Lock timeout

C. Lock escalation

D. Lock conversion