| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Alternative way to DetDate() function? | | 2 |
| how to get the automatic backup of the database in the sql
server | | 3 |
| how to dispaly a particular row details from a given table | | 1 |
| how can do you the system monitoring? | | 1 |
| what is diffence between replicaion and logshipping? | | 1 |
| I Have Employee table having column name as ID,SALARY
how to get second max salary from employee table with id
ex
ID SALARY
1 20000
7 37000
2 5000 | | 10 |
| Can a stored procedure call another stored procedure. If yes
what level and can it be controlled? | | 2 |
| what are three different authentications to connect linked
servers? | CitiGroup | 1 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 1 |
| Can I remove the default constraint columns in SQL SERVER? | Value-Labs | 2 |
| What is a Linked Server? | | 1 |
| What are constraints? Explain different types of
constraints? | | 5 |
| how to implement locking in sql server | Satyam | 1 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 1 |
| What are the authentication modes in SQL Server? | | 2 |
| What is ACID Property of Transaction? | | 3 |
| WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER? | | 5 |
| Let us say the SQL Server crashed and you are rebuilding the
databases including the master database what procedure to
you follow? | | 2 |
| How to write stored procedure to update the data in 10
tables | | 3 |
| What does the INSTEAD OF trigger do? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |