| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to dispaly a particular row details from a given table | | 1 |
| What are the OS services that the SQL Server installation adds? | | 1 |
| What does the INSTEAD OF trigger do? | | 3 |
| What is The Use Of TIMESTAMP DataType in SQL Server 2005?
| | 3 |
| What is the difference between login and a user? | TCS | 7 |
| WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER? | | 6 |
| 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 are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 3 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
| HCL | 2 |
| What are primary keys and foreign keys? | | 3 |
| What is Schema? and why we use schemas? | | 1 |
| what is normalization?
what is denormalization?
| Satyam | 5 |
| there is a table having two columns no and name
and the data is
1 A
2 B
3 C
write a query that will result a horizontal output
A,B,C
| vsworx | 7 |
| What is BCP? When do we use it? | | 1 |
| employee table has employee id
-----------
empid
----------------
1
2
3
3
3
4
5
5
5
6
6
6
7
here the values r repeated two times.how to select the
repeated values only.i.e 3,5,6 should alone come. | | 2 |
| How can you get @@error and @@rowcount at the same time? | | 5 |
| 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? | | 1 |
| how many type of subquery? | | 2 |
| What about UPDATESTATISTICS ? | Intelligroup | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
