| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to write query to Delete the records in child table
and corresponding records in parent table | Semantic-Space | 8 |
| what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1; | Patni | 9 |
| How to select Distinct columns from the table, table having
20 columns and i want all coulmns | Wipro | 3 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| what is curser. | | 8 |
| What is difference beteen Migration and Upgrdation? | Satyam | 4 |
| Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement | | 2 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
| HCL | 1 |
| What is Peer to peer Replication? | HCL | 1 |
| Explain fundamentals of Data ware housing & OLAP? | | 1 |
| PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
| APX | 2 |
| Can you tell me the difference between DELETE & TRUNCATE
commands? | | 11 |
| internal language used in sql server 2000? | | 1 |
| Explain sp_configure commands, set commands? | | 3 |
| About Indexed Views? with example?
plz reply... | | 2 |
| wht is normalization?can u explain me in detail? | TCS | 6 |
| what is difference between primary key and Unique | | 8 |
| What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they. | IBM | 5 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 2 |
| Difference between Function and Procedure-in general? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
