| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is row by row processing ? | | 1 |
| What are the two virtual tables SQL Server maintains for
triggers? | | 2 |
| how many type of subquery? | | 2 |
| Which TCP/IP port does SQL Server run on? | | 2 |
| What is a view? is View updatable? | IBM | 11 |
| 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? | | 1 |
| What is the difference between windows authentication and
sql server authentication | HCL | 4 |
| Can anybody explain me cold backup and hot backup?
| TCS | 3 |
| What is an index? | Yardi-Software | 7 |
| How do you use DBCC statements to monitor various aspects of
a SQL server installation? | | 1 |
| What are the new features in SQL Server 2005? | Emphasis | 2 |
| Explain Trigger with an example?
| | 1 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| What meant by Performance Tuning,how can we do the
performance tuning on stored procedures and tell some steps
to do the performance tuning | TCS | 2 |
| what is the main difference between after trigger and
instead trigger. | | 1 |
| I am having table Title with TITLE id,Author ID, Publiser
ID , table AUTHOR with Author ID, Author Name, table
PUBLISER with Pub ID, Pub name Here hot to find out the
publiser id who have relesed the books of patriticular
author? | | 3 |
| What is the diff between Dynamic queries and static queries
| ICS-Integrated-Computer-Solutions | 1 |
| What's the difference between a primary key and a unique key? | Wipro | 8 |
| Where do you think the users names and passwords will be
stored in sql server? | | 3 |
| What are the advantages of using sql server over ms access
or why should one use sql instead of ms access | Impetus | 1 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
