| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What command do we use to rename a db? | | 3 |
| What is the purpose of UPDATE STATISTICS? | | 1 |
| How to write stored procedure to update the data in 10
tables | | 3 |
| create procedure proc1 (@a int)
as
begin
if @a=1
create table #temp(a1 int)
else
create table #temp(a1 int)
end
while executeing the above code it shows error
like '#temp already exist' .why it shows an error? | IBM | 1 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | | 2 |
| Can you have a nested transaction? | HCL | 3 |
| What is the STUFF function and how does it differ from the
REPLACE function? | | 1 |
| what is the main difference between constraints(like
primary key etc..)& joins? | Annik | 2 |
| In clustered and non clustered indexes which one is faster
while executing a query ? | | 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 |
| What types of integrity are enforced by a foreign-key
constraint
| | 1 |
| What is the difference between 2-Tier architecture and
3-Tier architecture | Oracle | 5 |
| create index a on employee(dno)
In this,which index was created? | | 1 |
| 1.what is the purpose of using alias name in sql server?
with certain example?
2.what is cursor?will u plz explain me in detail with
certain example? | | 3 |
| how to find out the repeated value from table using groupby
function? | | 3 |
| About types of indexes in SQL server ? | Cognizent | 1 |
| syntax for deleting the database in T SQL | | 3 |
| How to Generate a Series of Random Integers With T-SQL? | | 1 |
| What is the difference between SSAS 2000 and SSAS 2005? | APX | 1 |
| write down the sql query?
Table Name : emp1
empid empname
1 bala
2 guna
Table Name : emp2
empid empname
1 <Null>
2 <Null>
Solution : emp1 names are updated in emp2, write a query?
| | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
