C2090-610 Online Practice Questions and Answers

Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes to increase the size of the ITEM column, which SQL statement needs to be used?

A. ALTER TABLE sales ADD COLUMN item CHAR(40);

B. ALTER TABLE sales ALTER COLUMN item CHAR(40);

C. ALTER TABLE sales MODIFY COLUMN item CHAR(40);

D. ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);

What is the primary function of an Online Transaction Processing (OLTP) workload?

A. To combine data from multiple sources.

B. To discover hidden relationships in data.

C. To analyze large amounts of data to find patterns.

D. To make changes to a small number of records within a single transaction.

Which operation normally does NOT require an exclusive lock?

A. BIND

B. DROP

C. GRANT

D. SELECT

If a table named MY_TAB contains 100 rows and the following statement is executed:

What will happen?

A. The last 5 rows in the table will be deleted.

B. The first 5 rows in the table will be deleted.

C. The statement will fail because a subquery cannot be used with a DELETE statement.

D. The statement will fail because a table name was not specified with the DELETE statement.

If a user has been granted SYSCTRL authority, which activities can they perform?

A. Load operations

B. Backup/copy table spaces

C. Create and drop databases

D. Monitor database performance

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.

What is the primary purpose of a view?

A. To enable uniqueness.

B. To ensure data clustering.

C. To combine data from multiple tables.

D. To optimize queries ran against multiple tables.

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

Given the following statements:

What will be the result?

A. Joe Smith

B. Joe Smith

C. Joe Smith>DB2

D. Joe Smith

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.