Oracle 11g PL/SQL Practice Questions for Interview
This blog post on Oracle 11g PL/SQL Practice Questions for Interview will help entry level Database programmers to answer most common Oracle 11g PL/SQL Questions.
1. Because a PL/SQL engine is part of the server, code modules can be used or called from almost any application development language.
2. A program that can run on any platform is considered portable.
3. It can be more efficient to process SQL Structured Query Language statements stored within the database versus those stored in application code.
4. The term stored indicates the program unit is saved in the database, and therefore can be used or shared by different applications.
5. A(n) function typically returns only one value.
6. A(n) database trigger performs a task automatically when a Data Manipulation Language (DML) action occurs on the associated table.
7. An example of an application trigger is PL/SQL code that automatically runs when a particular button is clicked on the screen.
8. The tier3 application model attempts to ease application maintenance and enables the support of larger numbers of users.
9. A(n) event can range from a user action, such as clicking a button on the screen, to a table update statement that automatically calls a database trigger.
Download Link for Oracle Database Software: Go to Oracle Website
What are four advantages of using Oracle 11g PL/SQL
Tight integration with SQL—You can leverage your knowledge of SQL because PL/SQL supports the use of SQL data manipulation, transaction control, functions, cursors, operators, and pseudo columns. In addition, PL/SQL fully supports SQL data types, which reduces the need to convert data passed between your applications and the database.
Increased performance—First, PL/SQL allows blocks of statements to be sent to Oracle in a single transmission. This is important in reducing network communication between your application and Oracle, especially if your application is database intensive. PL/SQL blocks can be used to group SQL statements before sending them to Oracle for execution. Otherwise, each SQL statement must be transmitted individually. Second, PL/SQL code modules, or stored program units, are stored in executable form—making procedure calls very efficient. Third, executable code is automatically cached in memory and shared among users. This can speed processing tremendously with a multiuser application that has repeated calls to modules of code. Fourth, a PL/SQL engine is embedded in Oracle developer tools so that PL/SQL code can be processed on the client machine. This reduces network traffic.
Increased productivity—PL/SQL can be used in many of the Oracle tools, and the coding is the same within all. Therefore, your PL/SQL knowledge can be used with many development tools, and the code created can be shared across applications. Because a PL/SQL engine is part of the server, these code modules can also be used or called from almost any application development language. You can use Visual Basic or Java to develop an application but still harness the power of PL/SQL with Oracle.
Portability—PL/SQL can run on any platform that Oracle can run. This is important to enable a developer to easily deploy an application on different platforms.
Tighter security—Database security can be increased with application processing supported by PL/SQL stored program units. Program units can enable the access of database objects to users without the users being granted privileges to access the specific objects. Therefore, the users can access these objects only via the PL/SQL program units
What are the components of an application model
An application model has three main components:
User interface or screens—The screens that are presented to the end user to enter information and/or take actions, such as clicking a button on the screen. The user interface component may be developed with tools, such as Visual Basic, Java, or Oracle Forms.
Program logic or the brains behind the screens—The programming code that provides the logic of what the application will do. PL/SQL addresses the “brains” or logic portions of an application.
Database—The database management system providing the physical storage structure for data and mechanisms to retrieve, add, change, and remove data. The Oracle server provides the database.
Describe the three-tier application model Oracle 11g PL/SQL
The three-tier model is growing in popularity because it attempts to ease application maintenance and enables the support of larger numbers of users. In this scenario, the user interface is typically presented via a Web browser and is often referred to as a thin client. Application code is not loaded onto the client machine; all the application code now resides on an application server, which is also referred to as the middle tier.
Three layers now exist in this model: the user interface, the application server, and the database server. The Oracle application server allows the deployment of Oracle Forms applications via the Web. The application server contains the user interface and processing logic, which together, respond to user actions and, in turn, send appropriate code to the database server for processing.http://techhowdy.com/oracle-11g-plsql-practice-questions/http://techhowdy.com/wp-content/uploads/2017/10/Oracle-11g-PLSQL-1.pnghttp://techhowdy.com/wp-content/uploads/2017/10/Oracle-11g-PLSQL-1-150x150.pngDatabase Programmingattempts to ease application maintenance,Oracle 11g PLSQLThis blog post on Oracle 11g PL/SQL Practice Questions for Interview will help entry level Database programmers to answer most common Oracle 11g PL/SQL Questions. 1. Because a PL/SQL engine is part of the server, code modules can be used or called from almost any application development language. 2. A program that...DemonLyoid Lopeslyoid_lopes@yahoo.comAdministratorHi there, I am Lyoid Lopes. Internet Marketer and Blog writer. I am Software Engineering Technology graduate from Centennial College Canada. In Techhowdy I publish new technology news every day. You can reach me Facebook, Twitter and Google +TechHowdy