Tag: databases

Questions Related to databases

A collection of named objects is called ______
technology databases

  1. Schema

  2. Table

  3. Alias

  4. Both a & b

Show answer
Correct Option: A

The maximum number of tables that can be joined is _____________
technology databases

  1. 20

  2. 10

  3. 15

  4. No Limit.

Show answer
Correct Option: C

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

To retrieve data from more than one table we could use
technology databases

  1. Joins

  2. Unions

  3. Nested SELECT

  4. All of the above

Show answer
Correct Option: D

What is the restriction on using UNION in embedded SQL ?
technology databases

  1. It has to be in a CURSOR

  2. cannot be used in Embedded SQL

  3. No restrictions

  4. None of the above

Show answer
Correct Option: A

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

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

  1. Uncommitted Read

  2. Cursor Stability

  3. Read Stability

  4. Repeatable Read

Show answer
Correct Option: D

A declared temporary table is used for which of the following purposes?
technology databases

  1. Backup purposes

  2. Storing intermediate results

  3. Staging area for load operations

  4. Sharing result data sets between applications

Show answer
Correct Option: B

The identity value will be rolled back when the transaction that tried to insert the value into the table is not committed or rolled back
technology databases

  1. True

  2. False

Show answer
Correct Option: B