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.
 
Amol, said Apr 1, 2018
User defuned function is nothing but the one kind of stored procedure which is stored in the databse which accept the one or more parameter and return a single value or data table. we can not manupulate the databse from UDF.
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
123456789101112131415


16171819202122232425 Page 3 of 25