For 10 records.. SQL> Select * from Emp where rownum<=10; /

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 ?

Question Posted / apparao akki

10 Answers
16589 Views
Perot Systems, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What are the reporting services components?

108

Which sql server table is used to hold the stored procedure script?

659

What is sql or structured query language?

864

what is dbcc? : Sql server database administration

682

What does it mean if @@cursor_row returns a negative number?

716

What are data driven subscriptions?

what are triggers? : Sql server database administration

656

Explain following error properties?

725

What is a field in a table?

775

What is the use of group by clause?

706

What is check constraint in sql server?

715

what stored procedure can you use to display the current processes? : Sql server administration

717

Explain features and concepts of analysis services?

668

What is dirty page?

720

Write a sql query to delete duplicate records from a table called table1

776