FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

PL/SQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
1. What is PL/SQL?
  PL/SQL is an acronym for Programming Language/SQL. Structured Query Language (SQL) is a scripting language. PL/SQL block can contain any number of SQL statements integrated with flow of control statements.
Your Name Your Email-ID
Your Answer
 
2. What are the advantages of PL/SQL?
 
    PL/SQL is a completely portable, high-performance transaction processing language that offers the following advantages :
  • Support for SQL
  • Support for object–oriented programming
  • Better performance
  • Higher productivity
  • Full portability
  • Tight integration with Oracle
  • Tight security
Your Name Your Email-ID
Your Answer
 
3. What are the types of PL/SQL block?
 
    A PL/SQL block consisting of different sections.
  • Declaration Section
  • Executable Commands Section
  • Exception Handling section
Your Name Your Email-ID
Your Answer
 
4. What are the structure of PL/SQL block?
  Declare
      declarations
Begin
      executable statements
      Exception
            exception handlers
End;
Your Name Your Email-ID
Your Answer
 
5. What is the difference between SQL vs SQL*PLUS?
  SQL stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. This language is non procedural.
SQL *PLUS is an Oracle specific program, which accepts and executes SQL commands and PL/SQL blocks. SQL *PLUS allow us to manipulate SQL commands and PL/SQL blocks.
Your Name Your Email-ID
Your Answer