Which of the following is a NOT a valid reason for defining a view on a table?
Restrict users' access to a subset of table data
Ensure that rows inserted remain within the scope of a definition
Produce an action as a result of a change to a table
Provide users with an alternate view of table data
Which of the following isolation levels will lock all rows scanned to build a result data set?
Uncommitted Read
Cursor Stability
Read Stability
Repeatable Read
A declared temporary table is used for which of the following purposes?
Backup purposes
Storing intermediate results
Staging area for load operations
Sharing result data sets between applications
what is the maximum number of triggers can apply on a single table
4
no limit
24
12
When you open a cursor, DB2 will always get all rows that meet the selection criteria and create a result set?
Yes
No
It Depends
None of the above
Which of the following causes a lock that is being held by an application using the Cursor Stability isolation level to be released?
The cursor is moved to another row
The row the cursor is on is deleted by the application
The row the cursor is on is deleted by another application
The row the cursor is on needs to be updated by another application
When the program name is not in the plan, we get
-810
-801
-805
-825
B37 abend during SPUFI is due to
Space Issues
Data Issues
No records found while querying the table
Both a & b
An application has acquired a Share lock on a row in a table and now wishes to update the row. Which of the following statements is true?
The application must release the row-level Share lock it holds and acquire an Update lock on the row
The application must release the row-level Share lock it holds and acquire an Update lock on the table
The row-level Share lock will automatically be converted to a row-level Up-date lock
The row-level Share lock will automatically be escalated to a table-level Up-date lock
Which of the following is used to indicate a column will not accept NULL values and can be referenced in another table's foreign key specification?
Check constraint
Default constraint
Unique constraint
Informational constraint