| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to write a script for upate the data in prod , i have
50000 row are there | TCS | 2 |
| 1. What are the grouping function in SQL ?
2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?
3. Difference between DROP, DELETE, TRUNCATE table ?
4. What is constraints and types ?
5. What is max size of nchar & nvarchar ?
6. Define ROLLBACK, COMMIT, SAVE POINT
7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise
8. Select 10 rows from a table ?
9. Define DML, DDL, DCL, DTL commands ?
10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?
11. Default constraints ?
12. Can we have more then primary Key in table ?
13. Type of integrity ? Entity, Referential, Domain ?
| Perot-Systems | 8 |
| In clustered and non clustered indexes which one is faster
while executing a query ? | | 1 |
| what is the purpose of creating view is sql server 2000 | Wipro | 9 |
| Wht is the difference between stored procedure and trigger | TCS | 4 |
| How to list all tables having unique constraints in any of
the columns in a database. | | 1 |
| What is the system function to get the current user's user
id? | TCS | 3 |
| UPDATE statement can on a single table or on the multiple
table? | iGate | 5 |
| wht is normalization?can u explain me in detail? | TCS | 6 |
| How to count the number of duplicate items in a table? | | 1 |
| What is bit datatype and what's the information that can be
stored inside a bit column? | | 1 |
| What is Schema? and why we use schemas? | | 1 |
| logshipping is Any difference 2000 and 2005? | | 1 |
| How to display n-1 columns from n number of columns, from a
single table in MS SQL server 2005? | | 1 |
| Can you explain the role of each service? | | 1 |
| Plz tell about backup&recovery? | | 2 |
| WHAT OPERATOR PERFORMS PATTERN MATCHING? | CTS | 2 |
| Wht is Stuff in sql ser | | 1 |
| can you any body tell me why are go for the rebuild the
master database.what is the reason? | | 1 |
| what is trigger | NIIT | 1 |
| |
| For more SQL Server Interview Questions Click Here |