FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

SQL SERVER INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
51. CRUD stands for?
  CRUD stands for Create, Read, Update, and Delete
Your Name Your Email-ID
Your Answer
 
52. List the Aggregate Functions in SQL Server 2008.
 
  • AVG()
  • CHECKSUM_AGG()
  • COUNT()
  • COUNT_BIG()
  • GROUPING()
  • MAX()
  • MIN()
  • SUM()
  • STDEV()
  • STDEVP()
  • VAR()
  • VARP()
Your Name Your Email-ID
Your Answer
 
53. Can we execute multiple data operations using one command?
  Yes, using MERGE keyword, we can execute multiple data operations. The MERGE keyword was introduced in SQL Server 2008. Its purpose is to perform all appropriate insert, update, and delete operations in a table based in data in joined tables. Using one command, we can execute multiple data operations. This is very useful technique for maintaining data consistency and integrity. The result is that the statement merges the changes from the target table into the source table.
Your Name Your Email-ID
Your Answer
 
54. What is variable?
  A variable is a container for a single data value of a particular type. In Transact-SQL, all variables are preceded by an @ symbol. It is possible to define up to 10,000 variables in a single batch
Your Name Your Email-ID
Your Answer
 
55. List CATCH Block Error Functions.
 
  • ERROR_LINE()
  • ERROR_NUMBER()
  • ERROR_MESSAGE()
  • ERROR_PROCEDURE()
  • ERROR_SEVERITY()
  • ERROR_STATE()
Your Name Your Email-ID
Your Answer