Sql Interview Question and Answers

11. Define SubQuery?
 
  • Nesting of Queries one within the other is called as a Subquery.
  • A table can have only one primary key.
 
Your Name Your Email-ID
Your Answer
12. What are the different types of subquery?
 
  • Single row subquery
  • Multiple row subquery
  • Correlated row subquery
 
Your Name Your Email-ID
Your Answer

13. What are the different types of replication?
 
    The SQL Server 2000-supported replication types are as follows
  • Transactional
  • Snapshot
  • Merge
 
Your Name Your Email-ID
Your Answer
14. What is User Defined Functions?
  User-Defined Functions allow to define its own T-SQL functions that can accept 0 or more parameters and return a single scalar data value or a table data type.
 
Your Name Your Email-ID
Your Answer
15. Define Self Join?
  Self join means joining one table with itself.
The self join can be viewed as a join of two copies of the same table.
 
Your Name Your Email-ID
Your Answer