Exam 70-461

  1. What is the purpose and syntax of the IIF() function?
    IIF(boolean_expressiontrue_valuefalse_value)

    The IIF function returns one of two values, depending on whether the Boolean expression evaluates to true or false.

    This function is new to SQL Server 2012.
  2. What is sp_rename?
    Changes the name of a user-created object in the current database. This object can be a table, index, column, alias data type, or Microsoft .NET Framework common language runtime (CLR) user-defined type.

    • sp_rename [ @objname = ] 'object_name' , [ @newname = ] 'new_name'
    •     [ , [ @objtype = ] 'object_type' ]
  3. How is the isolation level set, and what are the possible isolation levels?
    SET TRANSACTION ISOLATION LEVEL ___;

    • 1. READ UNCOMMITTED
    • 2. REPEATABLE READ
    • 3. SNAPSHOT
    • 4. SERIALIZABLE
    • 5. READ COMMITTED
    •      ↳ READ_COMMITTED_SNAPSHOT
Author
velvet_stallion
ID
206233
Card Set
Exam 70-461
Description
Questions to help pass Microsoft's Exam 70-461: Querying Microsoft SQL Server 2012
Updated