| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is WITH CHECK OPTION | Karur-Vysya-Bank-KVB | 2 |
| Let us say the SQL Server crashed and you are rebuilding the
databases including the master database what procedure to
you follow? | | 2 |
| why cluster and non clusterindex are used in sqlserver 2000?
explain with example | | 1 |
| Following are some of the question related to below
mentioned query?
select e1.salary from employee3 e1
where 2=
(
select count(distinct(e2.salary))
from employee3 e2 where e2.salary>=e1.salary
)
1) What the query returns?
2) How it works? - Detail explanation (what the sub query
does, why it is (where 2=)....etc...Please?
| | 3 |
| explain different types of jions with examples briefly? | Zensar | 3 |
| how to change column into row in sql | | 1 |
| What is a stored procedure? | | 3 |
| can we call functions from stored procedure in SQL Server
2005 ? How? | | 2 |
| What are cursors? Name four types of cursors and when each
one would be applied? | Adea-Solutions | 1 |
| how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server. | IBM | 3 |
| What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance.... | Siemens | 6 |
| What is normalization and its forms? | Challenger-Financial | 3 |
| Is it possible to create tables in stored procedures using
a variable for the table name? | | 1 |
| What are the OS services that the SQL Server installation adds? | | 1 |
| Can we use Truncate command on a table which is referenced
by FOREIGN KEY? | | 1 |
| what is the query and condition to delete datas in sql
server. | | 1 |
| create index a on employee(dno)
In this,which index was created? | | 1 |
| you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required | | 2 |
| How do SQL server 2000 and XML linked? | | 1 |
| What is the difference between windows authentication and
sql server authentication | HCL | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
