Select 10 rows from a table ? Answer : Use TOP keyword to select 10 ro

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 ?

Question Posted / srivas

10 Answers
18822 Views
Perot Systems, I also Faced
E-Mail Answers

Answer Posted / srivas

Select 10 rows from a table ?

Answer : Use TOP keyword to select 10 rows from a table.

Is This Answer Correct ?

4 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How you trouble shoot when any job fails

1979

What is indexing explain it with an example?

1065

Why normalization is used?

1062

What is a filestream?

1043

What is self join in sql server joins?

1108

Can we use where clause with group by?

945

What is cached report?

150

What is the parse query button used for?

1078

Can you leave a union at any time?

1106

Differentiate between SQL and ORACLE joins and write their syntax.

1069

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

1037

What is fill factor and pad index?

1058

Can I disable or restrict ssrs export formats (rendering formats)?

155

What are .mdf files?

1012

Does a full backup include transaction log?

1040