DATABASE | SQL | SQL INTERVIEW QUESTION AND ANSWERS 3 | DEFINE SUBQUERY? | WHAT ARE THE DIFFERENT TYPES OF SUBQUERY? | WHAT ARE THE DIFFERENT TYPES OF REPLICATION? | WHAT IS USER DEFINED FUNCTIONS? | DEFINE SELF JOIN? | DEFINE SEQUENCE?

Sql Interview Question and Answers:

13.     Define SubQuery?
    Nesting of Queries one within the other is called as a Subquery.
    A table can have only one primary key.

14.     What are the different types of subquery?
    Single row subquery
    Multiple row subquery
    Correlated row subquery

15.     What are the different types of replication?
    The SQL Server 2000-supported replication types are as follows
    Transactional
    Snapshot
    Merge

16.     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.

17.     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.

18.     Define Sequence?
      A Sequence is a database object that can be used to provide very quick generation of unique numbers.