Question 9


Answer E is correct. The only command that will leave the table behind is one that copies data directly into a table from the current database. The #, ##, and @ identifiers are used solely for variables and create no permanent table. Anything created in tempdb is temporary by definition because tempdb is erased every time the server starts.

For more information, see the following sources:

  • Chapter 2, "Creating Database Objects"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, Accessing and Changing Database Data, Changing Data in a Database, Inserting Data into a Table, Adding Rows by Using INSERT and SELECT INTO"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, Databases (Database Engine), Understanding Databases, System Databases, tempdb Database"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, Designing and Creating Databases, Tables, Understanding Tables, Special Table Types"




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net