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
Explain what is “asynchronous” communication in sql server service broker?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
Can we call stored procedure in trigger?
What are the lambda triggers?
Are null values the same as that of zero or a blank space?
What is molap and its advantage? : sql server analysis services, ssas
What is report rendering ?
What does set rowcount do?
What is the bookmark lookup and rid lookup?
What is lock escalation? : sql server database administration
Why would you call update statistics?
What is a sql join?
What is the log shipping?
Can you tell me some of the common replication dmv's and their use? : sql server replication
Please differentiate between a local and a global temporary table?