| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | HCL | 4 |
| i have a table #temp1(id, Name groupname ) and record
like this 1 R1 S
2 R3 S
3 R2 S
4 R4 D
5 R5 D
6 R6 K
7 R7 K
8 R8 L
9 R9 L
10 R10 L
11 R11 K
and i want to display record based on user defind sorting
order e.g.
1 R4 D
2 R5 D
3 R6 K
4 R7 K
5 R11 K
6 R1 S
7 R3 S
8 R2 S
9 R8 L
10 R9 L
11 R10 L | | 4 |
| how can do you the system monitoring? | | 1 |
| what is advantages in sql 2005 over sql 2000? | | 4 |
| What are cursors? | | 8 |
| how to know description of a table in sqlserver 2000
| | 7 |
| from the table display the 2nd highest salary?
and also the least 2nd salay?
| | 6 |
| I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz... | Value-Labs | 5 |
| 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. | | 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 |
| Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed) | | 5 |
| how to select 5 to 7 rows from a table, which contains 10 rows? | IBM | 14 |
| How to write query to Delete the records in child table
and corresponding records in parent table | Semantic-Space | 8 |
| Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not? | | 3 |
| What is one of the first things you would do to increase
performance of a query? For example, a boss tells you that
?a query that ran yesterday took 30 seconds, but today it
takes 6 minutes? | Wipro | 1 |
| Rate yourself in .NET and SQL ? | Cognizent | 1 |
| can you any body tell me which service pack is installed in
the sql server? | | 3 |
| how to get the maximum among two tables,for example table 1
(dep1) have (emp_id,emp_name,salary) columns and table 2
(dept2) have (emp_id,emp_name,salary) columns,i want which
employee have the maximum salary among two tables? | Lason | 2 |
| I have to display ten columns values from diffrent ten
tables.
how many joins are require? | HCL | 8 |
| What is normalization in Database ? | | 4 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
