| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how do u do Performance tunning ?
| Satyam | 1 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
| HCL | 3 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| can you any body tell me suppose database is suspect mode.
how can take to normal? | Teledata | 1 |
| can you anybody tell me the how can you restore the master
database. while migraion(one server to onther server)? | | 1 |
| if we have a column (Key) in a table.
and values of that column is
Key
1
1
1
2
2
3
3
4
4
5
5
5
and we want to show the data after query..like..
1(3)
2(3)
3(2)
4(2)
5(3)
how many times a single term comes..
| Rolta | 5 |
| How to tune a stored procedure? | | 5 |
| Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not? | | 3 |
| What do u mean by orphan users, how will u list them in the
DB | IBM | 2 |
| Can we use Truncate command on a table which is referenced
by FOREIGN KEY? | | 2 |
| How do I compare two values when one value(data type) is
char and the other is an integer? | | 3 |
| What are the main control-of-flow T-SQL constructs?
| | 1 |
| What is a job? | | 3 |
| What is the appropriate number of test cases that you can
write on a database? | Microsoft | 1 |
| About types of indexes in SQL server ? | Cognizent | 1 |
| What are the advantages of using sql server over ms access
or why should one use sql instead of ms access | Impetus | 1 |
| table:employee
EID ENAME MID(manager ids)
101 rama null
102 sita 101
103 siva 101
104 ganesh 103
. . .
. . .
for 103 ID the manager ID is 101(RAMA) and for 104 manager
is SIVA
if i give employee id (EID) you have to tell the manager for
that EID write query?
eample:if i give 102 .The query output should be manager for
102 ID that it should print RAMA as output
| | 5 |
| how to know Who Is Blocking Your SQL Server? | | 3 |
| write the query for find the top 2 highest salary in sql
server | TCS | 23 |
| What is a trigger? | | 6 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
