What is a table in a database?
What is the difference between an inner and outer join?
Define the select into statement.
Write an sql query to select all records from the table?
What is a column in a table?
Write the command to remove all players named sachin from the players table.
How to add new employee details in an employee_details table with the following details
What is synchronized subquery?
What is a unique constraint?
What is a temp table?
What is the difference between null value, zero, and blank space?
How to test for null values?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Explain lock escalation? : Transact sql