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