| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the authentication modes in SQL Server? | | 2 |
| How do you find the number of rows in a table? | | 5 |
| What is the disadvantage of using subquery exact after a
select statement?ex.
select (select * from sometable) | | 1 |
| 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 |
| 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. | | 3 |
| can we call functions from stored procedure in SQL Server
2005 ? How? | | 2 |
| explain different types of jions with examples briefly? | Zensar | 2 |
| About types of indexes in SQL server ? | Cognizent | 1 |
| What are the advantages of using stored procedures? Please
don't simply say compilation time will be saved as they are
already complied. Please specify some other advantages. | 247Customer | 3 |
| In which year relase the 7.0& 2000 & 2005? | | 1 |
| in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc. | | 7 |
| Wht is Stuff in sql ser | | 1 |
| Different Types of Functions ?
| Satyam | 2 |
| What is a view? | | 4 |
| Which virtual table does a trigger use? | | 3 |
| What is an index? | Yardi-Software | 7 |
| What is RAID and what are different types of RAID
configurations? | Wipro | 5 |
| Table student containing 2 columns,Join date,Employee name.
Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar-
2008,4-feb-2008.Under Employee name 4 difeerent names
jaison,robin,binoy,rahul
Result set is,
Table containing 4-column name=jan,feb,mar,april,,beneath
these months count is given as 1,2,1,0 means these counts
representing number of emplooyees joined in a month(january
1employee,february 2 employee,march 1 employee,april 0
employee)
Can you give me the required sql query | Wipro | 3 |
| What is a Lock and let me know Different types of locks? | | 1 |
| We create an index to fast the search. How it fast the
query? Do we write any special keyword with query? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
