C2090-610 - DB2 10.1 Fundamentals
Go back to IBM
If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database?
Which statement about UPDATE processing is FALSE?
When the UPDATE statement modifies parent key columns, the value of corresponding foreign key columns are also modified.
Which method for restricting data access relies on a SQL search condition that describes what set of rows a user has access to?
Row and column access control
When a COMMIT statement is executed, what happens?
The current transaction is terminated and a new transaction boundary is started.
When is it appropriate to use a sequence?
When you want to automatically generate a numeric value that is not tied to any specific column or table.
When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF?
A schema with the userid of the UDF definer.
Which type of temporal table can be used to store only time-sensitive data?
Which statement is valid about the Row and Column Access Control (RCAC) feature?
A row permission's access control rule is defined by an SQL search condition; a column mask's access control rule is defined by an SQL CASEexpression.
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?
When is a mask used to limit access to data in a table?
When row and column access control (RCAC) is used to protect the table.
Which type of stored procedure is not associated with an external application program?
A native SQL stored procedure.
What factor influences lock escalation?
Number of locks
Which event will NOT cause a trigger to be fired?
Execution of LOAD REPLACE operation.
Which object is a stored procedure defined into?
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 primary purpose of a view?
To combine data from multiple tables.
Which tool allows users to connect to a DB2 database using a wizard?
IBM Data Studio
Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE?
GRANT SELECT ON TABLE employee TO user1
Which database object provides an alternative way of describing data that exists in one or more base tables?
By default, where is the data stored for a column defined with an XML data type?
In an XML storage object that is separate from the table.
Which clause should be included in a ALTER TABLE statement to update a table definition with a new column?
When is an INTENT EXCLUSIVE (IX) lock required?
When a transaction intends to read or change data.
Which statement about INSERT operations is true?
Inserted values must satisfy the conditions of any check constraints defined on the table.
Which two operations are allowed in the body of an SQL scalar user-defined function? (Choose two.)
SQL control statements.
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?
Which SQL statement will give user USER1 the ability to assign a comment to a sequence named MYSEQ?
GRANT ALTER ON SEQUENCE myseq TO user1
Which statement about roll back operations is correct?
When a ROLLBACK statement is executed, all locks held by the terminating transaction are released.
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?
ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);
A column mask that is to be used for row and column access control (RCAC) was created with the DISABLE option specified. What must be done if this mask is to be used to restrict access to data stored in a table named EMPLOYEE?
The column mask must be enabled; the EMPLOYEE table must be altered to activate column access control.
Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?
SELECT job, MIN(salary), MAX(salary)FROM employeeGROUP BY job;
Which statement is true about an index that is used to support a UNIQUE constraint?
It must be defined with the UNIQUE attribute.
What type of mechanism is a simple token value that is used to refer to a much bigger large object (LOB)?
Which type of constraint can be used to ensure that an INTEGER column in a table will never be assigned more than one record that contains a NULL value?
What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?
Repeatable read (RR)
Which type of lock allows the lock owner and all concurrent applications to read, but not update, the locked data?
Which object is used to cache table and index data as it is read from disk?