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? SQL 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 requirement 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 @ https://www.facebook.com/discussexcel FORUM RULES 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 EXCEL AND VBA MACROS" group. 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 email@example.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.