PL/SQL Chapter 1: Introduction to PL/SQL
The ____________________ application model attempts to ease application maintenance and enables the support of larger numbers of users.
3-tier
A database model is a general framework or design that describes how the various components of an application will be addressed
FALSE
The term named program unit indicates that the program is saved in a database and, therefore, can be used or shared by different applications
FALSE
Functions perform tasks automatically when a DML action occurs on the table with which it is associated.
FALSE Database Triggers
SQL is a procedure language that allows a programmer to code a logical sequence of steps to make decisions.
FALSE PL/SQL
Structured Query Language (SQL) is considered a procedural language
FALSE SQL is a non-procedural language.
A package is any block of PL/SQL code that has been named so that it can be saved and reused.
FALSE named program unit
The term interoperability implies that PL/SQL can run on any platform that Oracle can run on.
FALSE portability
The three-tier application model is also referred to as a client/server application
FALSE two-tier
SQL was originally modeled after Ada, a programming language built for the U.S Department of Defense
FALSE PL/SQL
An programming language is a general framework or design that describes how the various components of the application will be addressed.
FALSE application model
It can be more efficient to process ____________________ statements stored within the database versus those stored in application code.
SQL Structured Query Language
A procedure and function are named program units that are called to perform a specific task.
TRUE
A programming language allows the actions of an end user to be converted into instructions that a computer can understand
TRUE
An event can range from a user action, such as clicking the button on the screen, to a table update statement that automatically calls a database trigger.
TRUE
Database security can be increased with application processing supported by PL/SQL stored program units
TRUE
If you have a piece of code that has the potential of being used by various applications, saving this code on the server allows it to be shared by several applications.
TRUE
PL/SQL allows blocks of statements to be sent to Oracle in a single transmission
TRUE
PL/SQL fully supports SQL data types
TRUE
PL/SQL supports the user of SQL data manipulation, transaction control, functions, cursors, operators, and pseudocolumns.
TRUE
PL/SQL's role is to provide the logic to instruct the computer as to what to do when an event occurs.
TRUE
Program units can enable the access of database objects to users without the users being granted privileges to access the specific objects.
TRUE
SQL*Plus is a basic tool available with the Oracle server that allows a user to enter SQL and PL/SQL statements directly to the Oracle database server for processing.
TRUE
The term stored indicates that the program unit is saved in the database and, therefore, can be used or shared by different applications.
TRUE
Which of the following serves as visual representation of a database? a. ERD b. ERP c. EDD d. DFD
a. ERD
Which of the following statements is true? a. Oracle considers PL/SQL to be a procedural language extension of SQL b. Oracle does not consider PL/SQL to be a procedural language c. Oracle considers SQL to be a procedural language d. Oracle does not consider SQL to be a programming language
a. Oracle considers PL/SQL to be a procedural language extension of SQ.
Which of the following can receive and return multiple values? a. Procedure b. Function c. Database trigger d. Package
a. Procedure
Which of the following statements is correct? a. The application server contains the user interface and processing logic, which together, respond to user actions b. The user interface is delivered from the database server that contains the logic to respond to user actions c. The user interface is delivered from the SQL database that contains the logic to responds to user actions d. The user interface is delivered from the thin client that contains the logic to respond to user actions
a. The application server contains the user interface and processing logic, which together, respond to user actions
The two-tier application model is also referred to as a(n) ________________. a. client/server application b. database application c. client application d. server application
a. client/server application
Which of the following statements about the three-tier application model is true? a. Application code is loaded onto the client machine b. Application code is not loaded onto the client machine c. All the application code resides on a database server d. All the application code is stored in a package.
b. Application code is not loaded onto the client machine.
Which of the following typically returns only one value? a. Procedure b. Function c. Database trigger d. Package
b. Function
PL/SQL code that automatically runs when a particular button is clicked on the screen is an example of a(n) ________________. a. package b. application trigger c. function d. procedure
b. application trigger
In a three-tier application model, the user interface is often referred to as a(n) ________________. a. GUI b. thin client c. program unit d. OTN
b. thin client
Which of the following statements is unique to the three-tier application model? a. It is referred to as a client/server application b. In this model an executable program or application is loaded onto the user's computer that contains the user screens and some programming logic c. Application code resides on the application server d. Processing can take place on the client-side
c. Application code resides on the application server
Which of the following is an example of an event? a. User interface b. Application logic c. Clicking a button on the screen d. Server-side processing
c. Clicking a button on the screen
____________ is a basic tool available with the Oracle server that allows a user to enter SQL and PL/SQL directly to the database server processing. a. OTN b. Procedure Builder c. SQL*Plus d. TOAD
c. SQL*Plus
All of the following are components of the application model, except ______________. a. Screens b. Programming logic c. Database d. Operating System
d. Operating System
All of the following are considered to be programming languages, except __________________. a. Java b. VBScript c. SQL d. Oracle
d. Oracle
Which of the following is considered the "brains behind the screens?" a. Database b. GUI c. User interface d. Programming logic
d. Programming logic
A(n) _________________ is a general framework or design that describes how the various components of the application will be addressed a. programming language b. procedural language c. database d. application model
d. application model
Procedural languages allow developers to _________________. a. write queries b. manipulate databases c. create tables d. perform decision-making logic
d. perform decision-making logic
SQL is NOT a_________________. a. programming language b. language that allows the actions of the end user to be converted into instructions that a computer can understand c. language that allows us to add, delete, or change data in a database d. procedural language
d. procedural language
The term portability refers to the ability of PL/SQL to _____________. a. automate tasks b. group SQL statement before sending them to Oracle for execution c. tighten security d. run on any platform that Oracle can run on
d. run on any platform that Oracle can run on
A(n) ____________________ performs a task automatically when a Data Manipulation Language (DML) action occurs on the associated table.
database trigger
A(n) ____________________ 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.
event
A(n) __________________ typically returns only one value.
function
A program that can run on any platform is considered _____________________
portable
Because a PL/SQL engine is part of the ____________________, code modules can be used or called from almost any application development language.
server
The term ____________________ indicates the program unit is saved in the database, and therefore can be used or shared by different applications.
stored
An example of an application ____________________ is PL/SQL code that automatically runs when a particular button is clicked on the screen.
trigger