Tag: technology

Questions Related to technology

The keyboard combination ALT + TAB is used to switch between open programs
technology operating systems

  1. True

  2. False

Show answer
Correct Option: A

The Function Key F10 activates Menu bar options...
technology web technology

  1. True

  2. False

Show answer
Correct Option: A

CTRL+SHIFT+ESC key combination opens the Task Manager
technology operating systems

  1. True

  2. False

Show answer
Correct Option: A

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?

technology databases

  1. INTEGER

  2. REAL

  3. NUMERIC (7,3)

  4. DECIMAL(10,3)

Show answer
Correct Option: D

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?
technology databases

  1. The application must release the row-level Share lock it holds and acquire an Update lock on the row

  2. The application must release the row-level Share lock it holds and acquire an Update lock on the table

  3. The row-level Share lock will automatically be converted to a row-level Up-date lock

  4. The row-level Share lock will automatically be escalated to a table-level Up-date lock

Show answer
Correct Option: C

Which of the following is a NOT a valid reason for defining a view on a table?

technology databases

  1. Restrict users' access to a subset of table data

  2. Ensure that rows inserted remain within the scope of a definition

  3. Produce an action as a result of a change to a table

  4. Provide users with an alternate view of table data

Show answer
Correct Option: C

When you open a cursor, DB2 will always get all rows that meet the selection criteria and create a result set?
technology databases

  1. Yes

  2. No

  3. It Depends

  4. None of the above

Show answer
Correct Option: B

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?

technology databases

  1. VALUES degf_to_c(32)

  2. SELECT date, degf_to_c(temp) AS temp_c FROM temp_data

  3. CALL degf_to_c(32)

  4. Both a and b

Show answer
Correct Option: D

Which wildcard character is used for a single character replacement
technology databases

  1. %

  2. &

  3. _

  4. None of the above

Show answer
Correct Option: C

What is the picture clause of the null indicator variable
technology databases

  1. S9 (4) COMP-3

  2. S9 (4)

  3. 9 (4)

  4. S9 (4) COMP

Show answer
Correct Option: D