Deck 1: Introduction To PL/SQL

Question 1

PL/SQL allows blocks of statements to be sent to Oracle in a single transmission.

Answer 1

True

Question 2

The term stored indicates that the program unit is saved in the database and, therefore, can be used or shared by different applications. _________________________

Answer 2

True

Question 3

SQL was originally modeled after Ada, a programming language built for the U.S. Department of Defense. _________________________

Answer 3

False, PL/SQL

Question 4

PL/SQL supports the use of SQL data manipulation, transaction control, functions, cursors, operators, and pseudocolumns. _________________________

Question 5

The term interoperability implies that PL/SQL can run on any platform that Oracle can run on. _________________________

Question 6

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.

Question 7

The three-tier application model is also referred to as a client/server application.

Question 8

A database model is a general framework or design that describes how the various components of an application will be addressed.

Question 9

The three-tier application model is also referred to as a client/server application. _________________________

Question 10

SQL is a procedural language that allows a programmer to code a logical sequence of steps to make decisions. _________________________

Question 11

A programming language allows the actions of an end user to be converted into instructions that a computer can understand.

Question 12

The term named program unit indicates that the program is saved in a database and, therefore, can be used or shared by different applications.

Question 13

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.

Question 14

A(n) programming language is a general framework or design that describes how the various components of the application will be addressed. _________________________

Question 15

PL/SQL fully supports SQL data types.

Question 16

A procedure and function are named program units that are called to perform a specific task.

Question 17

Structured Query Language (SQL) is considered a procedural language.

Question 18

Program units can enable the access of database objects to users without the users being granted privileges to access the specific objects.

Question 19

A(n) package is any block of PL/SQL code that has been named so that it can be saved and reused. _________________________

Question 20

Database security can be increased with application processing supported by PL/SQL stored program units.

Question 21

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

Question 22

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

Question 23

PL/SQL's role is to provide the logic to instruct the computer as to what to do when an event occurs. _________________________

Question 24

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

Question 25

Which of the following can receive and return multiple values?

A) Procedure
B) Function
C) Database trigger
D) Package

Question 26

All of the following are components of the application model, except ____.

A) Screens
B) Programming logic
C) Database
D) Operating System

Question 27

All of the following are considered to be programming languages, except ____.

A) Java
B) VBScript
C) SQL
D) Oracle

Question 28

Functions perform tasks automatically when a DML action occurs on the table with which it is associated. _________________________

Question 29

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 respond to user actions.
D) The user interface is delivered from the thin client that contains the logic to respond to user actions.

Question 30

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.

Question 31

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

Question 32

Which of the following is considered the "brains behind the screens?"

A) Database
B) GUI
C) User interface
D) Programming logic

Question 33

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

Question 34

The term portability refers to the ability of PL/SQL to ____.

A) automate tasks
B) group SQL statements before sending them to Oracle for execution
C) tighten security
D) run on any platform that Oracle can run on

Question 35

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

Question 36

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.

Question 37

Procedural languages allow developers to ____.

A) write queries
B) manipulate databases
C) create tables
D) perform decision-making logic

Question 38

Which of the following typically returns only one value?

A) Procedure
B) Function
C) Database trigger
D) Package

Question 39

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.

Question 40

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. _________________________

Question 41

Which of the following serves as a visual representation of a database?

A) ERD
B) ERP
C) EDD
D) DFD

Question 42

Describe at least four advantages of using PL/SQL.

Question 43

It can be more efficient to process ____________________ statements stored within the database versus those stored in application code.

Question 44

The ____________________ application model attempts to ease application maintenance and enables the support of larger numbers of users.

Question 45

Describe the three-tier application model.

Question 46

A(n) _____________________ performs a task automatically when a Data Manipulation Language (DML) action occurs on the associated table.

Question 47

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.

Question 48

A program that can run on any platform is considered ____________________.

Question 49

____ is a basic tool available with the Oracle server that allows a user to enter SQL and PL/SQL directly to the database server for processing.

A) OTN
B) Procedure Builder
C) SQL*Plus
D) TOAD

Question 50

Describe the components of an application model.

Question 51

A(n) ____________________ typically returns only one value.

Question 52

The term ____________________ indicates the program unit is saved in the database, and therefore can be used or shared by different applications.

Question 53

An example of an application ____________________ is PL/SQL code that automatically runs when a particular button is clicked on the screen.

Question 54

Because a PL/SQL engine is part of the ____________________, code modules can be used or called from almost any application development language.