1.

In an SQL Server, the hexadecimal value for an apostrophe ( ) in xml query is_____________________________.

2.
In an SQL Server, which of the following commands is used to add columns to a pre-existing table?
3.
What SQL command can be used to delete columns from a pre-existing table?
4.

In an SQL Server, which of the following are the advantages of using a table-valued parameter in user-defined functions?

 

  1. They easily acquire locks for the initial population of data from a client.

  2. Provide a simple programming model.

  3. Enable you to include complex business logic in a single routine.

  4. Reduce round trips to the server.

  5. We can have a table structure of different cardinality.




  6.  
  7.  


  8.  
5.

In SQL, which of the following is used to improve the query performance?

6.

In an SQL Server, the following sql statements are executed:



 
 

select customers.name, customers.ord_id, orders.ord_date

from customers inner join

orders

where customers.cust_id = orders.cust_id



Both the tables have 10,000 rows each. The query takes a long time to execute. Which of the following will help you to improve the query performance?
7.
In an SQL Server, if the row that is being fetched from the cursor result set is missing then which of the following values is stored in the @@fetch_status variable?
8.

In an SQL Server, which of the following stored procedures is used to view the lock information?

9.

In an SQL Server, which of the following will you use view the details such as size and date of creation of all its databases?

10.

In an SQL Server, the__________ database manages all the server-specific configuration information.