Q. About PL/SQL Tables?

   - Objects of Type “TABLE” Are Called PL/SQL Tables.
   - They Are Modeled As Database Tables, But Are Not Same.
   - PL/SQL TABLES Use A “PRIMARY KEY” To Give Array Like Access To Rows.
   - PL/SQL Tables Are Very Dynamic in Operation, Giving The Simulation To 
   Pointers in ‘C’ Language.
   - They Help in Integrating The Cursors For Dynamic Management of Records 
   At Run Time.
   - They Make Runtime Management of Result Sets Very Convenient.

Q. Difference Between SQL and PL/SQL?
It’s complete name is structured query language It’s complete name is 
procedural Language / Structured Query Language
It doesn’t have the any facility of branching or looping It has the 
complete  facility of branching or looping
In SQL, only one statement can be sent to Oracle Engine. It increase the 
execution time In PL/SQL, a complete block of statements can be sent to 
Oracle engine at a time, reducing traffic
In SQL, the use of variables is not possible In PL/SQL, the results of the 
statements can be stored in variables and can be used further as per the 
It doesn’t have the capacity for procedural language It is fully support 
procedural language
In SQL, there is no facility of error management. In case of error 
condition, It is the Oracle Engine that tracks it.                     In 
PL/SQL, the results of the statements can be stored in variables and can be 
used further as per the requirement    

Q. What is the Difference Between SQL & MYSQL?

SQL is more natural than MYSQL. MySQL is a computer application. whose DBMS 
allows multiple users. It enables access to several database application 
and management system. SQL is more natural and standard language that is 
used with different applications alike. But, however no organization 
actually employs this standard language, rather every software firm follows 
its own kind of SQL version.

If you're looking for SQL Interview Questions for Experienced or Freshers, 
you are at right place. There are lot of opportunities from many reputed 
companies in the world. SQL database market continue even stronger by 2020 
will be 70%. According to a research SQL by Microsoft grew at 10.32%, while 
Oracle grew 3.5%. In the upcoming era, competition will be more heated than 
is has been for years. So, You still have opportunity to move ahead in your 
career in SQL certification guide. Mindmajix offers Advanced SQL Interview 
Questions 2018 <https://mindmajix.com/sql-interview-questions> that helps 
you in cracking your interview & acquire dream career as SQL Developer.

Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 


1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
You received this message because you are subscribed to the Google Groups "MS 
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Reply via email to