| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is the output for this query
select * from employee where 1=1; | | 4 |
| What is a sub-query? When would you use one? | | 3 |
| What are the OS services that the SQL Server installation adds? | | 1 |
| can you any body tell me suppose database is suspect mode.
how can take to normal? | Teledata | 1 |
| what is mean by crystal repoart? ahere we will mainly use
that? | | 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 |
| What is SQL server agent? | SAP-Labs | 2 |
| Can you explain the role of each service? | | 1 |
| can you anybody tell me the how can you restore the master
database. while migraion(one server to onther server)? | | 1 |
| hi,
how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.
| | 2 |
| What is a Trace frag?Where can we use this? | | 1 |
| what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1; | Patni | 9 |
| UPDATE statement can on a single table or on the multiple
table? | iGate | 5 |
| How to Generate a Series of Random Integers With T-SQL? | | 1 |
| write query for fourth maximum salary from employee table | Mind-Tree | 5 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 2 |
| can you any body tell me the difference between candidate
key and primary key | | 4 |
| Write an SQL query if u want to select the data from one
block which intern reflects in another block ?
thanx,do reply | Covansys | 1 |
| What is normalization and what are the different forms of
normalizations? | | 1 |
| |
| 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
