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
18568 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 what are the restrictions that views have to follow? : SQL Server Architecture

1048

Tell me something about security and sql azure?

114

What is cursors? And what are the different types of cursor?

1144

What is the default Port No on which SQL Server listens?

1124

Does the order of columns in update statements matter?

913

What is transact-sql ddl trigger?

1107

Explain user defined views?

965

What are 3 ways to get a count of the number of records in a table?

1078

How to generate create function script on an existing function?

1118

Explain the advantages of merge replication?

952

What does asynchronous call backs means?

1158

What are the system database in sql server 2005?

1045

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2026

Explain the use of keyword with encryption. Create a store procedure with encryption?

961

How do I run sql server 2014?

1002