| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the different types of replication? How are they used? | | 3 |
| I have a website that allows customers to browse and place
orders for certain products.
I have 2 tables; Customers and Orders. The Customers table
holds the customer records and the Orders table
holds the orders placed by the customer. Both tables are
tied based on the field Cust_ID.
Example of the data is shown below:
Cust_ID Cust_Name Cust_ID Product Amount Order_Date
1001 John Tan 1001 P-5211 $120.00 2/13/2006
1002 Michael Wong 1001 K-1428 $88.90 1/11/2006
1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006
1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006
Write a single SQL statement that extracts all purchase
records with the following criteria:
1. Customer names starting with “M” only.
2. Orders placed within the current month only.
3. Amount does not exceed $100.00
The list must be sorted by order date with the latest order
showing on top. | Techno-Solutions | 3 |
| What is an index? | Yardi-Software | 5 |
| What are tasks? | Wipro | 1 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 1 |
| Which institute is best for SQL Server 2005 Training? | | 3 |
| Wht is SQL Injection Attack ? | | 1 |
| What are the new features in SQL Server 2005? | Emphasis | 2 |
| What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE? | Yardi-Software | 2 |
| How to determine the service pack currently installed on
SQL Server? | HCL | 2 |
| what is normalization?
what is denormalization?
| Satyam | 4 |
| What is the STUFF function and how does it differ from the
REPLACE function? | | 1 |
| What is a NOLOCK? | | 3 |
| Which is best Subquery (or) joins in sql server? explain why | | 1 |
| What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table | HP | 12 |
| How do you find the number of rows in a table? | | 5 |
| wht is normalization?can u explain me in detail? | TCS | 6 |
| syntax for deleting the database in T SQL | | 3 |
| What are the different types of joins and what does each do? | | 2 |
| what is curser. | | 7 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
