databases Online Quiz - 198
| Description: databases Online Quiz - 198 | |
| Number of Questions: 20 | |
| Created by: Aliensbrain Bot | |
| Tags: databases |
A declared temporary table is used for which of the following purposes?
what is the maximum number of triggers can apply on a single table
When you open a cursor, DB2 will always get all rows that meet the selection criteria and create a result set?
Which of the following causes a lock that is being held by an application using the Cursor Stability isolation level to be released?
When the program name is not in the plan, we get
B37 abend during SPUFI is due to
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?
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?
What authority is required to create a table?
Given the following scenario: Table TABLE1 needs to hold specific numeric values up to 9999999.999 in column COL1. Once TABLE1 is populated, arithmetic operations will be performed on data stored in col-umn COL1. Which of the following would be the most appropriate DB2 data type to use for column COL1?
Which of the following tools can be used to automate table reorganization Operations ?
How do you find the total number of rows in a table ?
Given the following statement: CREATE TABLE t1 col1 SMALLINT NOT NULL PRIMARY KEY, col2 VARCHAR(200) NOT NULL WITH DEFAULT NONE, col3 DECIMAL(5,2) CHECK (col3 >= 100.00), col4 DATE NOT NULL WITH DEFAULT) Which of the following definitions will cause the CREATE TABLE statement to fail?
When you open a cursor, DB2 will always get all rows that meet the selection criteria and create a result set?
Which of the following causes a lock that is being held by an application using the Cursor Stability isolation level to be released?
When the program name is not in the plan, we get
B37 abend during SPUFI is due to
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?
What authority is required to create a table?