Which statement about triggers is true?
Answer : D
If a table named MY_TAB contains 100 rows and the following statement is executed:
Answer : A
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?
Answer : C
What are two valid objects that can be created in DB2?(Choose two.)
Answer : C,E
When is an INTENT EXCLUSIVE (IX) lock required?
Answer : A
By default, a column defined as a TIMESTAMP includes which attributes?
Answer : B
Which function can be used to obtain values from XML documents that are to be inserted into one or more tables?
Answer : A
Which SQL statement should be used to select the minimum and maximum salaries
(SALARY), by job code (JOB), from a table EMPLOYEE?
Answer : A
Which statement will prevent concurrent application processes from performing anything other than read-only operationsagainst 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
Answer : B Topic 2, Volume B
What are INSTEAD OF triggers used for?
Answer : B
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?
Answer : A
Which SQL statement would be used to retrieve only salaries that are greater than
$100,000.00 from a table named EMPLOYEE?
Answer : B
If no isolation level is specified, what is the default isolation level used?
Answer : A
Which statement about UPDATE processing is FALSE?
Answer : C
User USER1 wants to define arequired 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 deleted from table TAB2. What must user USER1 do to accomplish this?
Answer : A