What is a view?
In view, we can create
virtual table with the columns from different tables by relation between them, we can use
this view as a table for selecting a data
but we can't use view to insert data.
What are the types of indexes available with
SQL Server?
There are basically two
types of indexes that we use with the SQL Server. “Clustered”
and the “Non-Clustered”.
What are cursors?
“Cursors” help us to do an operation on a set of data that we retrieve by commands
such as Select columns from table. For
example : If we have duplicate records in a table we can remove it by declaring a cursor which would
check the records during retrieval one by
one and remove rows which have duplicate
values.
0 Response to "SQL Server interview questions & Answers Set 10"
Post a Comment