Words That Rhyme With "Andwich"

51 Questions | Total Attempts: 61

SettingsSettingsSettings
Please wait...
Words That Rhyme With "Andwich"


Questions and Answers
  • 1. 
    SELECT SUBSTR(“Azure Skies”,-5, 5)FROM DUAL;What would be returned?
    • A. 

      An error message.

    • B. 

      Azure

    • C. 

      Skies

    • D. 

      Nothing

  • 2. 
    The UPPER function in SQL
    • A. 

      Converts letters currently uppercase into lowercase

    • B. 

      Converts all characters to uppercase

    • C. 

      Converts the first letter of each word to uppercase

  • 3. 
    The INITCAP function in SQL
    • A. 

      Sets all letters to uppercase (CAPS)

    • B. 

      Sets the first letter of each word to caps provided there is a space before each word

    • C. 

      Sets the first letter of each word to caps provided there is not a space before each word

  • 4. 
    The INSTR function is used to find one string within another string. It can be called in one of three ways. Which of the following is not a valid way of calling the function?
    • A. 

      INSTR(Name, ‘:’)

    • B. 

      SELECT Name, INSTR(Name ‘:’, 15)

    • C. 

      SELECT Name, INSTR(Name, ‘es’, -5, 2)

    • D. 

      SELECT Name, INSTR(Name, ‘es’, 1, 2)

  • 5. 
    Given the following:TRIM(‘     SQL is fun!      ‘)The expected output would be (without the quotes)
    • A. 

      ‘SQLisfun!’

    • B. 

      ‘SQL is fun! ‘

    • C. 

      ‘SQL is fun!’

    • D. 

      ‘ SQL is fun!’

  • 6. 
    All of the following are true regarding the TRANSLATE function except
    • A. 

      A. Translate is used to replace one character with another

    • B. 

      B. Translate can eliminate characters by having fewer replacement characters specified than characters to replace

    • C. 

      C. If the replacement string is NULL it means that all the characters to replace should be deleted

  • 7. 
    The REPLACE function is used to replace one string with another string
    • A. 

      True

    • B. 

      False

  • 8. 
    The CONCAT function can concatenate any number of character strings together
    • A. 

      True

    • B. 

      False

  • 9. 
    Given the following SQL function:ROUND(568.8615, 1)
    • A. 

      568.9

    • B. 

      570

    • C. 

      568.862

    • D. 

      568.86

  • 10. 
    Given the following SQL function:ROUND(563.399, -1)
    • A. 

      564

    • B. 

      560

    • C. 

      563.4

    • D. 

      600

  • 11. 
    The MOD function calculates the remainder of a division
    • A. 

      True

    • B. 

      False

  • 12. 
    Which of the following is not a format mask for the day portion of a date
    • A. 

      DDD

    • B. 

      DDDD

    • C. 

      Day

    • D. 

      DD

  • 13. 
    Given the following function:TO_CHAR(56.89, ‘9.0’)The expected output would be
    • A. 

      5.6

    • B. 

      An error since the mask is not large enough for the number to be displayed

    • C. 

      ####

    • D. 

      6.9

  • 14. 
    The NVL function is used to
    • A. 

      Check a column for null and return either the column value if not null or a replacement value of the same type if it is null.

    • B. 

      Check a column for null and return either the column value if not null or a replacement value of any type if it is null.

    • C. 

      Check a column for null and return one replacement value when it is null and a different replacement value if it is not null.

  • 15. 
    The NVL2 function is used to
    • A. 

      Check a column for null and return either the column value if not null or a replacement value of any type if it is null.

    • B. 

      Check a column for null and return either the column value if not null or a replacement value of the same type if it is null.

    • C. 

      Check a column for null and return one replacement value when it is null and a different replacement value if it is not null.

  • 16. 
    Which of the statements regarding the DECODE function are false?
    • A. 

      The function searches for a value provided among a list of possible outcomes

    • B. 

      If the value provided matches one of the possible outcomes, the value associated with that outcome is returned

    • C. 

      If the value provided does not match one of the possible outcomes, the value provided by DEFAULT is returned

    • D. 

      DEFAULT is optional. If omitted the DECODE function returns an error.

  • 17. 
    Which column function will count all records in a result set, regardless of the presence of null values?
    • A. 

      COUNT()

    • B. 

      COUNT(*)

    • C. 

      COUNT(%)

    • D. 

      COUNT(ColumnName)

  • 18. 
    When using the AVG() column function, NULL values are included in the calculation.
    • A. 

      True

    • B. 

      False

  • 19. 
    Select the true statement about column functions:
    • A. 

      A column function takes an entire column of data and summarizes it into a single data item.

    • B. 

      A column function takes an entire row of data and summarizes it into a single data item.

    • C. 

      A column function takes the values of two columns and adds them together to create a new value.

    • D. 

      When using column functions, the WHERE clause cannot be used.

  • 20. 
    A SELECT statement that uses column functions can also include a WHERE clause.
    • A. 

      True

    • B. 

      False

  • 21. 
    Select the true statements about HAVING clauses from the list below. (There are more than one.)
    • A. 

      If a column function is used on the HAVING clause, it will be calculated after the GROUP BY, creating additional processing.

    • B. 

      HAVING is used to eliminate groups from the result set.

    • C. 

      HAVING clause normally consists of one or more of the column functions applied to each of the groups.

    • D. 

      HAVING is used to eliminate rows from the result set.

  • 22. 
    A subquery can return many columns of data as its query result.
    • A. 

      True

    • B. 

      False

  • 23. 
    The ORDER BY clause cannot be used in a subquery.
    • A. 

      True

    • B. 

      False

  • 24. 
    The INSERT, DELETE and UPDATE statements are considered what in SQL?
    • A. 

      DML (Data Manipulation Language)

    • B. 

      DDL (Data Defnition Language)

    • C. 

      Transactions

    • D. 

      All the above

  • 25. 
    When inserting a new row with a date, and you want to insert  the date today, you can use the symbolic constant 'TODAY'.
    • A. 

      True

    • B. 

      False

Back to Top Back to top