databases Online Quiz - 222
|Description: databases Online Quiz - 222|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
What is a view config spec
What are the key products of IBM ClearCase Family
What are the different clear case Roles
What are the responsilibities of a Developer
What is the Lost and Found Directory
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?
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 a NOT a valid reason for defining a view on a table?
When you open a cursor, DB2 will always get all rows that meet the selection criteria and create a result set?
Given the following table: TEMP_DATA TEMP DATE _____________ 45 12/25/2006 51 12/26/2006 67 12/27/2006 72 12/28/2006 34 12/29/2006 42 12/30/2006 And the following SQL statement: TE FUNCTION degf_to_c (temp INTEGER) RETURNS INTEGER LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC BEGIN ATOMIC DECLARE newtemp INTEGER; SET newtemp = temp - 32; SET newtemp = newtemp * 5; RETURN newtemp / 9; END Which two of the following SQL statements illustrate the proper way to invoke the calar function DEGF_TO_C?
Which wildcard character is used for a single character replacement
What is the picture clause of the null indicator variable
_____ is dropped when the table or tablespace is dropped
A collection of named objects is called ______
The maximum number of tables that can be joined is _____________
When the program name is not in the plan, we get
B37 abend during SPUFI is due to
To retrieve data from more than one table we could use
Which of the following tools can be used to automate table reorganization Operations ?
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?