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 / apparao akki
For 10 records..
SQL> Select * from Emp where rownum<=10;
/
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are the restrictions applicable while creating views? : SQL Server Architecture
What is the difference between system objects and user objects?
What is the xml datatype?
How to access the deleted record of an event?
What is self contained sub query?
How to test a dml trigger in ms sql server?
What are the steps to insert a table?
What is a Join and explain its types?
What to check if a User database is locked?
Why should we go for stored procedures? Why not direct queries?
Is resultset an interface?
What is difference between primary key and foreign key?
How to enable/disable indexes?
What is bookmark link in ssrs?
How important do you consider cursors or while loops for a transactional database?