| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| HOW TO RENAME A COLUMN NAME | | 3 |
| 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 | 2 |
| How to write stored procedure to update the data in 10
tables | | 4 |
| As a part of your job, what are the DBCC commands that you
commonly use for database maintenance? | HCL | 1 |
| what is difference between primary key and Unique | | 8 |
| How will you fine tune a stored procedure or what are the
steps that should be taken to fine tune or optimize a
stored procedure? | Mphasis | 1 |
| If there exist a index on the table, and we then make a
view on that table (include the indexed column from base
table) than why do we require indexing on view?Doesnt it
create an overhead? | | 2 |
| Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database? | | 4 |
| Difference between server.transfer and server.execute method? | | 2 |
| wht's the differece between sqlserver05 and sqlserver2000 | | 3 |
| What is normalization and its forms? | Challenger-Financial | 3 |
| What are user defined datatypes and when you should go for
them? | | 1 |
| what is advantages in sql 2005 over sql 2000? | | 4 |
| Is it possible we can connect our SQL database to GUI
application? If it is yes than how tell me the explanation | | 1 |
| What is a table called, if it does not have neither Cluster
nor Non-cluster Index? | | 1 |
| How to find the latest updated value in a table without
sending any parameters to that query | | 2 |
| What's the maximum size of a row? | | 4 |
| wat is mean by trigger?.......normally wat use......when
trigger used in sql...........
plz cleary say with example....... | Wipro | 2 |
| syntax for deleting the database in T SQL | | 5 |
| Is it possible to delete duplicate rows in a table without
using a temporary table ? | | 10 |
| |
| For more SQL Server Interview Questions Click Here |