Tag: databases

Which of the following isolation levels will lock all rows scanned to build a result data set?

What is the picture clause of the null indicator variable

A collection of named objects is called ______

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

To retrieve data from more than one table we could use

What is the restriction on using UNION in embedded SQL ?