| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what are file groups? | Evalueserve | 3 |
| How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table? | Leo-Technologies | 12 |
| What is a materialized view? | | 2 |
| How do we return a record set from a Stored Procedure in SQl
server 2000? | | 2 |
| What is the difference between the following two sql
statements
select count(*) from <tablename>
select count(col_name) from <tablename> | 247Customer | 2 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server. | IBM | 4 |
| How can u convert the Date to String? | TCS | 4 |
| What is normalization and what are the different forms of
normalizations? | | 1 |
| How to get the count of distinct records. Please give me the
query? | Value-Labs | 5 |
| 1.What is the deferece between DBMS & RDBMS?
2.How can you trouble shoot? If u will get error while
installing sql server?
3.How can u trouble shoot slow running query?
4.how can u trouble log shipping errors?
5.why do we use merge replication instead of T.log
replication? | Microsoft | 4 |
| What is the use of CASCADE CONSTRAINTS? | | 2 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | HCL | 2 |
| how can we use a composite key for two tables and how can
we represent it | BoA | 1 |
| What is the difference between a Application Server and a
Database | Oracle | 2 |
| What are the two virtual tables SQL Server maintains for
triggers? | | 2 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 2 |
| What is the purpose of using COLLATE in a query? | | 1 |
| Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed) | | 5 |
| |
| For more SQL Server Interview Questions Click Here |