| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the appropriate number of test cases that you can
write on a database? | Microsoft | 1 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
| HCL | 1 |
| What is Files and Filegroups in SQL Server & it's
implementation. | Zenith | 1 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| how many type of subquery? | | 2 |
| Display a roll having miminum marks in two subjects? | Patni | 7 |
| What is referential integrity? What are the advantages of it? | Digital-Domain | 3 |
| Explain some DBCC commands? | | 4 |
| Can you explain the role of each service? | | 1 |
| What is MSDE? | | 2 |
| Define candidate key, alternate key, composite key. | | 9 |
| How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
| | 1 |
| what is a cursor and what is its use? | | 1 |
| how to get the maximum among two tables,for example table 1
(dep1) have (emp_id,emp_name,salary) columns and table 2
(dept2) have (emp_id,emp_name,salary) columns,i want which
employee have the maximum salary among two tables? | Lason | 2 |
| i have a table #temp1(id, Name groupname ) and record
like this 1 R1 S
2 R3 S
3 R2 S
4 R4 D
5 R5 D
6 R6 K
7 R7 K
8 R8 L
9 R9 L
10 R10 L
11 R11 K
and i want to display record based on user defind sorting
order e.g.
1 R4 D
2 R5 D
3 R6 K
4 R7 K
5 R11 K
6 R1 S
7 R3 S
8 R2 S
9 R8 L
10 R9 L
11 R10 L | | 4 |
| wt is mean by acid property? i know it is
atomocity,consistency,isolation and durabulaty but wt is
these mean and wt actions it's perform | Idea | 1 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| Can we rewrite subqueries into simple select statements or
with joins? Example? | ASD | 1 |
| The Difference between 'Count' and 'Count(*)' | | 12 |
| can anyone explain me the concept of Serialization in Detail
and Clear? plz its urgent i have interview on friday (15th feb) | | 1 |
| |
| For more SQL Server Interview Questions Click Here |