Tag: databases

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

To retrieve data from more than one table we could use