Exam 1: Introduction To PL/SQL

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

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

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

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

Which of the following statements is True?

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

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.

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

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

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

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

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

PL/SQL fully supports SQL data types.

PL/SQL code that automatically runs when a particular button is clicked on the screen is an example of a(n) ____.

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

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

Which of the following can receive and return multiple values?

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.

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

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