| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| when inserting to a table how many rows will be effected
using triggers
| | 1 |
| Can you create UNIQUE and PRIMARY KEY constraints on
computed columns in SQL Server 2000? | Infosys | 1 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | | 1 |
| Explain the architecture of SQL Server? | | 2 |
| how to rename the table | | 3 |
| What are the types of backup and tell me the difference
between full and differential backup? | TCS | 3 |
| About types of indexes in SQL server ? | Cognizent | 1 |
| What is normalization in Database ? | | 4 |
| HOW TO RENAME A COLUMN NAME | | 2 |
| Whether the updations made to the views reflect the
original records in the table | NIIT | 5 |
| Which system table contains information on constraints on
all the tables created? | | 2 |
| what is the cursor life span? | Evalueserve | 5 |
| What are the magic tables in SQL Server 2000? | Infogain | 5 |
| what is the importence of the trigger in sqlserver2000? | ATI | 1 |
| i have 4 tables.. T1, T2, T3, T4..
these tables have the same structure and they store the
information entered in different years..
T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored
2005..
i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and
T4 to T1..
how do i do that? Temp tables cannot be used.. | | 2 |
| What is an Index? | Yardi-Software | 3 |
| What is a NOLOCK? | | 3 |
| How are SQL Server databases physically stored under
Windows 2000? | | 1 |
| How To delete duplicate record from a particular table? | eXensys | 10 |
| what is the purpose of creating view is sql server 2000 | Wipro | 9 |
| |
| For more SQL Server Interview Questions Click Here |