Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Table A Table B
1 1
2 1
3
1. Union & union all --> A Union B , A Union all B
2. Minus , Intersect --> A minus B , B Minus A , A Intersect B
3. Joins A join B , A Left Join B A Right Join B , A full Join B

4. %Type - Uses & Benifit
5. Truncate & Delete
6. Pragma Autonomus Transaction
7. how to Perform DDL from function or procedure
8. Can we have DML inside Function
9. Rank & Dense Rank diffrence
10. Water Mark in Oracle
11. Index , Can we have index in all column of table if no then why ?

Question Posted / deepak tiwary

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer



More SQL PLSQL Interview Questions

What is the difference between explicit and implicit cursors in oracle?

0 Answers  

What are the difference between Functions/Stored Procs and Triggers and where are they used.

1 Answers   CGI, TCS,

Which data dictionary views have the information on the triggers that are available in the database?

0 Answers  

what is bdb (berkeleydb)? : Sql dba

0 Answers  

What are sql procedures?

0 Answers  




When sql appeared?

0 Answers  

Can a foreign key have a different name?

0 Answers  

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

0 Answers  

Is sql procedural language?

0 Answers  

difference between SQL and C

1 Answers   Indus Software Technologies,

what is a foreign key ? : Sql dba

0 Answers  

What is interval partition?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories