| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| What is the difference Between Sql-server 2000 & 2005 | Value-Labs | 2 |
| how to select a field with firstletter as capital and
remaining are small letters | | 8 |
| 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 |
| What is transcation?Plz give One example? | | 2 |
| 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 |
| Which is better in performance - CONSTRAINT or TRIGGER over
a column which restricts say an input of particular value
in a column of a table? | Accenture | 3 |
| what is hash table | Teledata | 2 |
| What is the difference between a stored procedure and a user
defined function in sql server? | Millennium | 2 |
| What is a job? | | 3 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| How to Create Login and User through query in Sql server
2005.and also how to delete Login and User through query? | | 2 |
| 1.How to check the backup file details if we do not have
access to that folder
2.how to check the backup file size without connecting to
the folder
| IBM | 1 |
| what is the difference between group and having
give an example with query and sample output | | 2 |
| how to get the rowid/rownumbes of a table in sqlserver | IBM | 5 |
| write the query for taking database restore in sql? | | 2 |
| 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 are three different authentications to connect linked
servers? | CitiGroup | 1 |
| how to know description of a table in sqlserver 2000
| | 7 |
| I have student marks in a student table. I need second
highest mark .Then what will the query for this? | Wipro | 23 |
| |
| For more SQL Server Interview Questions Click Here |