| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is SQL server agent? | SAP-Labs | 2 |
| why SQL server is more used to store database rather than
Access | | 2 |
| How will u find the query which is running in some other
machine | IBM | 4 |
| Is it possible to have more then one foreign key in a
single table? if possible, is this the good way to design
the table? | | 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 |
| how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,... | ADP | 5 |
| where do you use Isolations?give me some exmpale? | | 1 |
| what are default? Is there a column to which a default cant be
bound? | | 1 |
| how to rename the table | | 3 |
| An employee table, with the columns id, name, sal and dob.
Query to select emp names of all highest salaries(there are
4-5 people having the same salary which happens to be the
highest).
| ADP | 8 |
| how to connect sybase to sql server 2005?. | ABC | 1 |
| select name of emplyoee whose total salary is 130 from
following table.
id name salary
1 a 100
2 b 20
3 c 50
1 a 30
2 b 70
Post the resulantant Query? | | 4 |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 2 |
| I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer. | Satyam | 4 |
| What is the order in which the SQL query is executed? list
them in order. | CTS | 4 |
| What is SQL Profiler what is the use of it? | 247Customer | 2 |
| What is a view? | | 6 |
| Please tell me some knowledge about Clustering and how to
add clustering? | | 1 |
| what is physical sort data and logical sort data in index? | | 2 |
| Whether the updations made to the views reflect the
original records in the table | NIIT | 5 |
| |
| For more SQL Server Interview Questions Click Here |