Checking It

1:SQL functions falls into
  1. 1 Category

  2. 2 Categories

  3. 3 Categories

  4. Does not have categories

2:A single-row function can only return one row.

True/False

3:In a DATE mask, the RR means
  1. Current century if the year tested is between 00 and 49 and the current year is between 50 and 99

  2. Current century if the year tested is between 00 and 49 and the current year is between 00 and 49

  3. Next century if the year tested is 00 through 49 and the current year is 50 through 99

  4. Current century if the year tested is 50 and 99 and the current year is between 00 and 49

4:When might a group function return more than one row?
  1. When used with a WHERE clause

  2. When used with an ORDER BY clause

  3. When used with a GROUP BY clause

  4. Cannot have more than one row returned

5:Cartesian Joins have a valid use.

True/False

6:Oracle9i supports a subquery in the FROM clause.

True/False

7:SQL*Plus can
  1. Take input from the command line

  2. Format column output

  3. Sum the contents of a column

  4. All of the above

8:SQL*Plus can be used to create GUI reports.

True/False

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.119.104.238