A2090-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

What type of mechanism is a simple token value that is used to refer to a much bigger large object (LOB)?

A. locator

B. pointer

C. address

D. reference

Which statement will prevent concurrent application processes from performing anything other than read-only operations against a table named TAB1?

A. LOCK TABLE tab1 IN READ MODE

B. LOCK TABLE tab1 IN SHARE MODE

C. LOCK TABLE tab1 IN EXCLUSIVE MODE

D. LOCK TABLE tab1 IN READ-ONLY MODE

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.

Which SQL statement will give user USER1 the ability to assign a comment to a sequence named MYSEQ?

A. GRANT ALTER ON SEQUENCE myseq TO user1

B. GRANT USAGE ON SEQUENCE myseq TO user1

C. GRANT SELECT ON SEQUENCE myseq TO user1

D. GRANT COMMENT ON SEQUENCE myseq TO user1

Which privilege is required to invoke a user defined function?

A. CALL

B. USAGE

C. EXECUTE

D. REFERENCES

When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF?

A. The SYSIBM schema.

B. The SYSFUN schema.

C. A schema with the name of the UDF.

D. A schema with the userid of the UDF definer.

Which statement about UPDATE processing is FALSE?

A. The UPDATE statement logs the before and after value of every column it modifies.

B. A searched UPDATE is used to update one or more rows and a positioned UPDATE is used to update exactly one row.

C. When the UPDATE statement modifies parent key columns, the value of corresponding foreign key columns are also modified.

D. The UPDATE statement modifies the values of specified columns in the rows of a table, view, or underlying table(s) of a specified fullselect.

The WITH CHECK OPTION clause of the CREATE VIEW statement allows you to do which of the following?

A. Define a view on one or more tables or views.

B. Revalidate all invalid objects that are referenced on a view's fullselect.

C. Ensure that any inserted or updated rows conform to the definition of the view.

D. Define a view that only consists of columns that have check constraints defined.

Which statement about a deadlock is true?

A. The victim will be rolled back.

B. The victim will read through the lock.

C. Both victim and holder are rolled back.

D. The victim must wait until the holder releases the lock.