Multiple choice technology databases

In sql server 2008, whats the new concepts?

  1. XML data types

  2. Table value parameters

  3. Transactions

  4. none of these
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Table-valued parameters (TVPs) were introduced in SQL Server 2008 as a new feature to pass multiple rows of data to stored procedures or functions. XML data types existed since SQL Server 2000, and transactions are a fundamental database concept present from early versions.

Keep practicing — related questions