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
18159 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 many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1153

what's the information that can be stored inside a bit column? : Sql server database administration

964

How do I completely remove sql server instance?

1021

What is triggers in ms sql server?

1048

Explain what are commit and rollback in sql?

864

What is subquery? Explain the properties of a subquery?

924

What is cte (common table expression)?

976

How do clustered indexes store data?

1054

Benefits of Stored Procedures?

918

What are the types of indexing?

1028

What do you mean by normalisation?

961

What are the new scripting capabilities of ssms? : sql server management studio

1000

How do I find the transaction log size in sql server?

914

Explain Geometry datatype in sql server 2008 with example

916

What is Extended user-defined?

895