Please Visit Our New Website for Further Communication

Amazon

25 Feb 2013

Oracle PL/SQL Interview Questions

  • What is difference between SQL and PL/SQL?
  • Difference between Truncate and Delete commands.
  • What is a Merge command?
  • Difference between Implicit and Explicit Locking
  •  Types of Joins in Oracle
  •  Types of Integrity Constraints in Oracle
  • How many different types of NULL functions are there in Oracle?
  • Difference between Union and Union ALL
  • What are Synonyms?
  • What are materialized View? Syntax? How to create Primary key on Materialized Views?
  • What are Indexes? Different types of Indexes?
  • Types of Cursors?
  •  Explain Cursors Attribute?
  • Difference between Procedures and Functions
  • Difference between Packages and Stored Procedures
  • What are Packages?
  • Name any In-built Oracle Packages
  • Types of Triggers
  • Difference between Before and After Trigger
  • Difference between Package Specification and Package Body
  • Types of Exceptions in PLSQL
  •  What are Ref Cursors?
  • Explain Optimization Techniques?
  • What is Explain Plan?
  •  Difference between Normalization and Denormalization
  • Explain SDLC Life cycle and name few different Models
  •  Explain AGILE Model
  • What is Group BY and having clause?
  • Oracle 11g new features
  • Difference between VARCHAR and VARCHAR2
  • Name parameter modes for stored procedures
  • What is DB LINK?
  • What is an Autonomous Transaction?
  • What is a Savepoint
  •  Explain Rollup and Cube statement
  •  Write a query to find even rows from a Table
  • Write a query to find duplicate rows from a Table
  • Write a query to find nth highest salary from employee Table
  • Write a query to find first 10 rows from a table
  • Write a query to find random 7 rows out of 47 rows in a Table
Posted by at

2 comments:

  1. Unknown27 May 2013 at 21:35

    really good piece of information, I had come to know about your site from my friend shubodh, kolkatta,i have read atleast nine posts of yours by now, and let me tell you, your site gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a lot once again, Regards, sql and plsql difference

    ReplyDelete
  2. Unknown5 June 2013 at 21:55

    Thanks a lot Buddy!!!!

    ReplyDelete

Subscribe to: Post Comments (Atom)