Question 1

Describe the components of an application model.

Accepted Answer

The answer of Describe the components of an application model....

Question 2

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

Accepted Answer

The answer of An example of an application ____________________ is...

Question 3

Which of the following statements about the three-tier application model is True?

Accepted Answer

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 4

Which of the following statements is correct?

Accepted Answer

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is an example of an event?

Accepted Answer

A)  User interface 
B)  Application logic 
C)  Clicking a button on the screen 
D)  Server-side processing

Question 7

Which of the following typically returns only one value?

Accepted Answer

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

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of A(n) _____________________ performs a task automatically when...

Exam 1: Introduction To PL/SQL

Describe the components of an application model.

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

Which of the following statements about the three-tier application model is True?

Which of the following statements is correct?

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

Which of the following is an example of an event?

Which of the following typically returns only one value?

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

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

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

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

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

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

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