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

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

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 ?

167

What is Collation Sensitivity ? What are the various type ?

99


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

How to fix oracle error ora-00942: table or view does not exist

246


Explain the savepoint statement.

229


What is prepared statement in sql?

202


What version is sql?

205


what is oracle database ? : Sql dba

231






What is on delete set null?

210


How many types of cursors supported in pl/sql?

252


Can you selectively load only those records that you need? : aql loader

264


What does plvtab enables you to do when you showthe contents of pl/sql tables?

235


What type of database is sql?

201


Is sql microsoft?

200


Which sorts rows in sql?

218


Why is stored procedure faster than query?

195


Can we use two order by clause in query?

197


how to decrement dates by 1 in mysql? : Sql dba

246