| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is de-normalization and when do you do it? | | 3 |
| Anyone please explain me the concept of Serialization? | | 3 |
| what is index seek and index scan? | | 2 |
| Define candidate key, alternate key, composite key. | | 9 |
| what is the cursor life span? | Evalueserve | 5 |
| How can u convert the Date to String? | TCS | 4 |
| what is the purpose of creating view is sql server 2000 | Wipro | 9 |
| How can you see what type of locks used? | | 1 |
| IN Vs OR operator which is best to use sql server. | | 3 |
| What are constraints? Explain different types of
constraints? | | 6 |
| I need a query that retrieves info from an Oracle table and
a query that retrieves info from a SQL Server table. The
info has to be joined together according to Record ID
numbers. I have very limited access to the Oracle database
but full control of the SQL Server database.How do I join
two different queries from two different databases?
| | 1 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| 1. What are the grouping function in SQL ?
2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?
3. Difference between DROP, DELETE, TRUNCATE table ?
4. What is constraints and types ?
5. What is max size of nchar & nvarchar ?
6. Define ROLLBACK, COMMIT, SAVE POINT
7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise
8. Select 10 rows from a table ?
9. Define DML, DDL, DCL, DTL commands ?
10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?
11. Default constraints ?
12. Can we have more then primary Key in table ?
13. Type of integrity ? Entity, Referential, Domain ?
| Perot-Systems | 8 |
| Explain sp_configure commands, set commands? | | 3 |
| what is extended StoreProcedure ?
| Satyam | 3 |
| write down the sql query?
Table Name : emp1
empid empname
1 bala
2 guna
Table Name : emp2
empid empname
1 <Null>
2 <Null>
Solution : emp1 names are updated in emp2, write a query?
| | 7 |
| 1.what is the purpose of using alias name in sql server?
with certain example?
2.what is cursor?will u plz explain me in detail with
certain example? | | 3 |
| what is the output for this query
select * from employee where 1=1; | | 4 |
| how to delete duplicate rows from table in sql server | HCL | 8 |
| Lets say due to N/W or Security issues client is not able to
connect to server or vice versa. How do you troubleshoot? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
