| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is normalization and its forms? | Challenger-Financial | 3 |
| What is INTVAL( )and where we use
Plz any body help me | | 1 |
| What are the OS services that the SQL Server installation adds? | | 1 |
| Is it possible to have more then one foreign key in a
single table? if possible, is this the good way to design
the table? | | 2 |
| Can you have a nested transaction? | HCL | 3 |
| can you any body tell me the how to decrease the logfile | | 3 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| i have a table student like
sname
-----
ram
ram
ram
raj
raj
raj
i need the output like
sname
-----
ram
raj
ram
raj
ram
raj
| IBM | 6 |
| Which system tables contain information on privileges
granted and privileges obtained | | 1 |
| how to give input dynamically to a insert statement in
sqlserver | HCL | 1 |
| What is normalization in Database ? | | 3 |
| Lets say due to N/W or Security issues client is not able to
connect to server or vice versa. How do you troubleshoot? | | 1 |
| Can a stored procedure call itself(recursive). If yes what
level and can it be controlled.? | | 2 |
| How do you measure the performance of a stored procedure? | Infosys | 1 |
| Which stored procedure will you be running to add a linked
server? | | 1 |
| What are primary keys and foreign keys? | | 3 |
| What does the INSTEAD OF trigger do? | | 2 |
| Difference between sql server 2000 and sql server 2005?
| Satyam | 2 |
| How many max. conditions can b written under the WHERE
clause?
Like select * from [tabnam] WHERE
(cond1...or..cond2....or...cond3...and.....so on.....???
(upto how much extent))????? | SAP-Labs | 1 |
| i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on... | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
