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 ?
- 10 Answers
- 16586 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
Write a query to find 5th highest amount paid from the customer table.
What is inline variable assignment?
What is faster join or union?
how you can configure a running aggregate in SSRS?
What is the importance of concurrency control?
What are the advantages of using stored procedures in sql server?
What is Replication?
What is bcp? When does it used?
What is replication with database mirroring? : sql server database administration
What is @@rowcount in sql?
what is a transaction and what are acid properties? : Sql server database administration
How many types of keys are there?
What are the types of user defined functions in sql server?
Do you know what are the ways available in sql server to execute sql statements?
How you would rewrite the sql query to return the customerid sorted numerically?
