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 ?
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
What is log cache in sql server?
What is command parameter in ssrs?
What is 4nf in normalization form?
What are the types of processing and explain each? : sql server analysis services, ssas
How to generate create view script on an existing view?
Does sql server use java?
What is difference between table aliases and column aliases? Do they affect performance?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What stored by the model? : sql server database administration
What are parameterized reports? What are cascading parameters in ssrs reports?
what type of index will get created after executing the above statement? : Sql server database administration
what does the automatic recovery do? : Sql server administration
What are different types of subquery?
What are triggers? How do you invoke a trigger on demand?
What do I need to start working with sql studio? : sql server management studio