C2090-610 Exam Questions

Given the SQL statement: CREATE ALIAS total_sales FOR sales Which statement is valid?

Which DB2 object limits the user's ability to retrieve data from a table by defining a SQL statement in the object?

A table named EMPLOYEES was created as follows: What will be the results?

Which two DB2 objects can a view be derived from? (Choose two.)

Which protocol provides applications the ability to connect to and update multiple DB2 databases within the same transaction?

Which statement about bitemporal tables is valid?

Which object can a buffer pool be assigned to?

Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?

What needs to be defined in order to track changes made to a system-period temporal table over time?

Which object is used to cache table and index data as it is read from disk?

Which statement about large object (LOB) locators is true?

Which DB2 product is a database cluster solution for non-mainframe platforms and is best suited for Online Transaction Processing (OLTP) workloads?

What type of large object (LOB) is used to store LOB data together with the formatted rows on data pages, instead of in a separate LOB storage object?

A user invoking a user-defined function requires which DB2 privilege?

Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?

Which of the following privileges permits a user to update the comment on a sequence?

Which of the following is NOT true about schemas?

What is the lowest privilege and/or authority required to execute the following SQL statement? CREATE VIEW view1 AS SELECT * FROM table1 WHERE STATE = 'TX'

Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?

A table named STATES has the following columns: STATE_CD, REGION_CD, and STATE_NAME. Which SQL statement will return the number of states in each region, ordered by number of state...

What is a function of a table check constraint?

Which statement about foreign keys is true?

Which type of table is best suited for recording results from application data manipulation that is not required to be persistent?

Which statement regarding referential integrity constraints is true?

Which database object provides an alternative way of describing data that exists in one or more base tables?

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

Which type of constraint can be used to tell the DB2 Optimizer that a parent-child relationship exists between two tables, but that the relationship is not enforced?

Which event will NOT cause a trigger to be fired?

What is the primary purpose for using the INCLUDE clause with a CREATE UNIQUE INDEX statement?

What are INSTEAD OF triggers used for?

User USER1 wants to store part numbers and part descriptions in a table named PARTS; user USER1 also wants to ensure that any comparisons of part descriptions that are made will be...

What mechanism is typically used to automatically update other tables, generate or transform values for inserted or updated rows, and perform tasks such as issuing alerts?

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

User USER1 wants to define a required relationship between two tables named TAB1 and TAB2 in such a way that whenever a record is deleted from table TAB1, any related records are d...

Which statement about a deadlock is true?

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?

What is the act of releasing a large number of row-level locks that an application holds on a single table to acquire a table-level lock known as?

When is an INTENT EXCLUSIVE (IX) lock required?

The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of the following?

What factor influences lock conversion/promotion?

Application APP_A is performing updates to table TAB1 using the read stability (RS) isolation level. Which isolation level will allow application APP_B to retrieve all rows from ta...

If no isolation level is specified, what is the default isolation level used?

What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?

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

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?

Which DB2 object can be used to improve the execution performance of qualified SELECT statements?

When is it appropriate to use a sequence?

Which clause should be included in a ALTER TABLE statement to update a table definition with a new column?

Which object is a stored procedure defined into?

Which action needs to be performed in order to complete the definition of an application-period temporal table?