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
18147 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 is the difference between Clustered and Non-Clustered Index?

1008

Explain cursor as data base object?

971

When to use Inner join & when to use subquery?

1077

What is meant by indexing?

934

How do I view a script in sql server?

975

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1901

What triggers long term care?

991

How do I find sql server instance name?

913

What does set rowcount do?

865

What is a print index?

840

What are the indexes in sql server?

1018

what's the maximum size of a row? : Sql server database administration

1010

How you can get a list of all the table constraints in a database?

904

What does null mean?

931

What is amo? : sql server analysis services, ssas

1043