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
- 19028 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
How can we solve concurrency problems?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
what is the difference between openrowset and openquery?
What is sql or structured query language?
How do I start sql server 2017?
What is the difference between upgrade and migration in sql server?
What are the source of constraints?
What is a view in sql?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Can one drop a column from a table?
What is normalization and what are the advantages of it?
Where can you add custom error messages to sql server?
How do I create a trace in sql server?
What is an indexed view?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
