Exam 70-461

Card Set Information

Author:
velvet_stallion
ID:
206233
Filename:
Exam 70-461
Updated:
2013-03-12 14:07:36
Tags:
SQL Server
Folders:

Description:
Questions to help pass Microsoft's Exam 70-461: Querying Microsoft SQL Server 2012
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user velvet_stallion on FreezingBlue Flashcards. What would you like to do?


  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

What would you like to do?

Home > Flashcards > Print Preview