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
18458 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

Explain the commands in sql server?

1019

Does a full backup include transaction log?

949

How do you delete duplicate records in sql server?

1032

can a table be moved to different filegroup? : Sql server administration

945

What are sql server functions?

962

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1011

How to create a user to access a database in ms sql server using "create user" statements?

937

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

923

How to create database with physical files specified in ms sql server?

979

Does group by sort data?

883

How can you check the version of sql server?

1079

Explain transaction server isolation?

1005

How do I debug a stored procedure in sql server?

1080

How to maintain a fill factor in existing indexes?

986

What is primary key index?

964