ANSI SQL Extensions  «Prev  Next»

Oracle built-in functions - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which one of the following is a major disadvantage of BIFs?
Please select the best answer.
  A. They are specific to Oracle SQL and cannot be used with other relational databases.
  B. They consume an inordinate amount of system resources.
  C. Their syntax is complex and confusing.
  D. Invoking a BIF requires knowledge of the location of the BIF source code.

2. Which one of the following is a use for the DECODE BIF? (Choose all that apply)
Please select all the correct answers.
  A. Translating single character values
  B. Translating multiple character values
  C. Translating between data types (i.e. numeric to character)
  D. Translating dates to characters

3. What is a possible use for the NVL clause?
Please select the best answer.
  A. Replacing null values from tables with NOT NULL columns
  B. Replacing null values with defaults for outer joins
  C. Replacing zero values with characters

4. Which is true about dynamic SQL?
Please select the best answer.
  A. Dynamic SQL is available in PL/SQL in Oracle7.
  B. Dynamic SQL can be simulated in Oracle7 by using SQL*Plus and the SPOOL command.
  C. Dynamic SQL is normally reserved for Java applications.