Database programming section 5 quiz

  • Which function compares two expressions?

    The NULLIF() function compares two expressions and returns NULL if they are equal..

  • Which functions allow you to perform explicit data type conversions?

    Explicit conversions use the CAST or CONVERT functions..

  • Which of the following general functions will return the first non null expression in the expression list?

    COALESCE returns the first non-null expr in the expression list.
    You must specify at least two expressions.
    If all occurrences of expr evaluate to null, then the function returns null..


Categories

Database programming tools
Database programming tutorial
Database programming techniques
Database programming tutorial pdf
Database programming types
Database programming triggers
Database programmer training
Database transactions programming
Database schedule table
Database schedule transactions
Database schedule tasks
Program database toolkit
Database table program
Lazarus database programming tutorial
Python database programming tutorial
Database programming using python
Database programming uts
Database programming using oracle 11g
Database programming using sql
Database programming using python pdf