databases Online Quiz - 197
Description: databases Online Quiz - 197 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
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 isolation levels will lock all rows scanned to build a result data 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?
What is the restriction on using UNION in embedded SQL ?
Which of the following is a NOT a valid reason for defining a view on a table?
A declared temporary table is used for which of the following purposes?
We can declare DB2 host variables in a COBOL copybook