|
By Nishant Kumar
What are the
lock types?
|
SQL server supports following locks
Shared lock
Update lock
Exclusive lock
|
Shared lock
Shared Lock allows simultaneous access of record by multiple Select statements.
Shared Lock blocks record from updating and will remain in queue waiting while
record is accessed for reading.
If update process is going on then read command will have to wait until
updating process finishes.
Update locks
This lock is used with the resources to be updated.
Exclusive locks
This kind of lock is used with data modification operations like update, insert
or delete.
SQL
Server Interview questions part 3 includes following questions with
answers
What are cursors in SQL Server? | What is a join and explain different types of
joins. | What is an extended stored procedure in SQL Server? | What are
triggers in SQL Server? | What is a self join in SQL Server? | What is the
difference between UNION ALL Statement and UNION? | Write some disadvantage of
Cursor? | What is Log Shipping in SQL Server?
A database is a structured collection of data. Database can be thought as simple
data file......
The Bulk Copy is a command utility that transfer SQL data to or from a data
file.
This utility mostly used to transfer huge data to SQL server from other
database....
Distributed Query is a query which can retrieve data from multiple data sources
including distributed data........
Column with identity property contains unique system generated value in the
table. Column with identity property is similar to AutoNumber field in MS
Access....
Both are used for filtering of records based on filtered criteria.....
This is the default and recommended security mode. In this mode, access to SQL
server is controlled by Windows NT.....
It is
system variable that returns error code of the SQL
statement.....
|