Question 1

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

Accepted Answer

The answer of A program that can run on any...

Question 2

In a three-tier application model, the user interface is often referred to as a(n) ____.

Accepted Answer

A)  GUI 
B)  thin client 
C)  program unit 
D)  OTN 
A)  GUI 
B)  thin client 
C)  program unit 
D)  OTN

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Describe at least four advantages of using PL/SQL.

Accepted Answer

Tight integration with SQL-You ca

Question 6

SQL is NOT a ____.

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 8

Describe the three-tier application model.

Accepted Answer

The three-tier model is growing in popul

Question 9

A(n) ____________________ typically returns only one value.

Accepted Answer

The answer of A(n) ____________________ typically returns only one value....

Question 10

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.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Which of the following statements is unique to the three-tier application model?

Accepted Answer

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

Procedural languages allow developers to ____.

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

The answer of The term ____________________ indicates the program unit...

Question 20

The two-tier application model is also referred to as a(n) ____.

Accepted Answer

A)  client/server application 
B)  database application 
C)  client application 
D)  server application 
A)  client/server application 
B)  database application 
C)  client application 
D)  server application

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

In a three-tier application model, the user interface is often referred to as a(n) ____.

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

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

Describe at least four advantages of using PL/SQL.

SQL is NOT a ____.

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

Describe the three-tier application model.

A(n) ____________________ typically returns only one value.

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.

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

Which of the following statements is unique to the three-tier application model?

Procedural languages allow developers to ____.

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

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

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

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

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

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

The two-tier application model is also referred to as a(n) ____.

Basic PL/SQL Block Structures

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Procedures

Functions

PL/SQL Packages

Program Unit Dependencies

Database Triggers

Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

Filters

Exam 1: Introduction To PL/SQL

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

In a three-tier application model, the user interface is often referred to as a(n) ____.

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

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

Describe at least four advantages of using PL/SQL.

SQL is NOT a ____.

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

Describe the three-tier application model.

A(n) ____________________ typically returns only one value.

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.

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

Which of the following statements is unique to the three-tier application model?

Procedural languages allow developers to ____.

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

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

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

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

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

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

The two-tier application model is also referred to as a(n) ____.

Basic PL/SQL Block Structures

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Procedures

Functions

PL/SQL Packages

Program Unit Dependencies

Database Triggers

Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

Filters