The keyboard combination ALT + TAB is used to switch between open programs
True
False
The Function Key F10 activates Menu bar options...
CTRL+SHIFT+ESC key combination opens the Task Manager
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?
INTEGER
REAL
NUMERIC (7,3)
DECIMAL(10,3)
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?
The application must release the row-level Share lock it holds and acquire an Update lock on the row
The application must release the row-level Share lock it holds and acquire an Update lock on the table
The row-level Share lock will automatically be converted to a row-level Up-date lock
The row-level Share lock will automatically be escalated to a table-level Up-date lock
Which of the following is a NOT a valid reason for defining a view on a table?
Restrict users' access to a subset of table data
Ensure that rows inserted remain within the scope of a definition
Produce an action as a result of a change to a table
Provide users with an alternate view of table data
When you open a cursor, DB2 will always get all rows that meet the selection criteria and create a result set?
Yes
No
It Depends
None of the above
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?
VALUES degf_to_c(32)
SELECT date, degf_to_c(temp) AS temp_c FROM temp_data
CALL degf_to_c(32)
Both a and b
Which wildcard character is used for a single character replacement
%
&
_
What is the picture clause of the null indicator variable
S9 (4) COMP-3
S9 (4)
9 (4)
S9 (4) COMP