| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are Sql Reporting Services and analysis services? Can
u Explain | | 1 |
| 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 |
| How m-m relationships are implemented? | | 1 |
| What is the difference between 2-Tier architecture and
3-Tier architecture | Oracle | 10 |
| Where do you think the users names and passwords will be
stored in sql server? | | 3 |
| What's the maximum size of a row? | | 4 |
| How do you know which index a table is using? | | 4 |
| How do we get current date in SQL Server 2000, Oracle, MS
Access? | | 11 |
| 1.How to check the backup file details if we do not have
access to that folder
2.how to check the backup file size without connecting to
the folder
| IBM | 1 |
| can you any body tell me the how to decrease the logfile | | 4 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| What is the difference between Userdefined function and
stored procedure? Explain and give the example also | | 4 |
| Can we have more than one NULL in a column having unique
constraint? | 247Customer | 7 |
| What are explicit and implicit transactions? | | 2 |
| I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer. | Satyam | 4 |
| What is the difference between a stored procedure and a user
defined function in sql server? | Millennium | 2 |
| What is Query Execution Plan? How does it help optimize or
tune a database driven application? | Accenture | 2 |
| difference between sql server2000 and sql server2005
| KPMG | 1 |
| What's the purpose of Stored Procedure? | Wipro | 4 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
