| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 2 |
| how will u create "n" possible tables in sql...
| Oracle | 1 |
| How do you measure the performance of a stored procedure? | Infosys | 1 |
| Can I remove the default constraint columns in SQL SERVER? | Value-Labs | 3 |
| How do we rollback the table data in SQL Server | | 3 |
| what is the Enterprise manager(2000) and management studio
(2005)? | | 2 |
| 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 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| Please give me the SP for the below scenario. I have two
tables named Table1 and Table2...I need to fetch record by
record from Table1 and insert the record in to table2 where
the value in the sno column of the table1 is even number. | Value-Labs | 4 |
| what is difference between having and where clause ? | | 2 |
| what is normalization?
what is denormalization?
| Satyam | 5 |
| What are statistics, under what circumstances they go out
of date, how do you update them? | HCL | 2 |
| IN Vs OR operator which is best to use sql server. | | 3 |
| Can you explain the types of Joins that we can have with Sql
Server? | | 2 |
| What is Report Server,Report Manager and Report Builder in
SSRS 2005? | | 1 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| How To delete duplicate record from a particular table? | eXensys | 10 |
| How can u convert the Date to String? | TCS | 4 |
| After using delete statement in sql query to delete some
records...to retrieve the deleted records we can get using
rollback command but till that where it stores means
particular location name i need....(after deleting and
rollback ) | iGate | 2 |
| Is it possible to delete duplicate rows in a table without
using a temporary table ? | | 6 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
