Home
About Us
Contact Us
Bookmark
Saved Bookmarks
Current Affairs
General Knowledge
Chemical Engineering
UPSEE
BSNL
ISRO
BITSAT
Amazon
ORACLE
Verbal Ability
→
PL SQL Interview Questions
→
PL/SQL Advanced Interview Questions in PL SQL Interview Questions
→
Differentiate between SQL and PL/SQL.
1.
Differentiate between SQL and PL/SQL.
Answer»
SQL
PL/SQL
SQL is a natural language meant for the interactive
PROCESSING
of data in the database.
PL/SQL is a procedural extension of SQL.
Decision-making and looping are not allowed in SQL.
PL/SQL supports all features of procedural language such as
CONDITIONAL
and looping statements.
All SQL statements are executed at a time by the database
SERVER
which is why it becomes a time-consuming process.
PL/SQL statements are executed one
BLOCK
at a time thereby reducing the network traffic.
There is no error handling mechanism in SQL.
This supports an error handling mechanism.
Show Answer
Discussion
No Comment Found
Post Comment
Related InterviewSolutions
Differentiate between the cursors declared in procedures and the cursors declared in the package specifications.
What are the virtual tables available during the execution of the database trigger?
What is the use of SYS.ALL_DEPENDENCIES?
What is the difference between ROLLBACK and ROLLBACK TO statements in PL/SQL?
What are the various functions available for manipulating the character data?
What is the importance of %TYPE and %ROWTYPE data types in PL/SQL?
Differentiate between SQL and PL/SQL.
Differentiate between implicit cursor and explicit cursor.
Why is SYSDATE and USER keywords used?
Can you explain the PL/SQL execution architecture?
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply
Your experience on this site will be improved by allowing cookies. Read
Cookie Policy
Reject
Allow cookies