Question 1

What is another name for a package header?

Accepted Answer

A) package body 
B) package definition 
C) package specification 
D) package declaration 
A) package body 
B) package definition 
C) package specification 
D) package declaration C

Question 2

The Database Objects node ____.

Accepted Answer

A) is a top-level node within the Object Navigator 
B) is not associated with a specific form 
C) contains child nodes that represent every database user 
D) All of the above 
A) is a top-level node within the Object Navigator 
B) is not associated with a specific form 
C) contains child nodes that represent every database user 
D) All of the above D

Question 3

How do you test a program unit in Forms Builder?

Accepted Answer

A) Create a form for the input fields and attach a form trigger to a button. 
B) Use the auto test feature. 
C) Write a test harness PL/SQL program. 
D) Create a new tester component and associate the program unit with it. 
A) Create a form for the input fields and attach a form trigger to a button. 
B) Use the auto test feature. 
C) Write a test harness PL/SQL program. 
D) Create a new tester component and associate the program unit with it. A

Question 4

The ____ parameter mode should be used to return a value from a procedure when the input value to the procedure will not be set.

Accepted Answer

A) IN 
B) OUT 
C) IN OUT 
D) OUT IN 
A) IN 
B) OUT 
C) IN OUT 
D) OUT IN

Question 5

Other database users may execute stored program units.

Accepted Answer

A) True 
 B)False

Question 6

How do you build a library in Forms Builder?

Accepted Answer

A) Create a new library,add existing program units. 
B) Create a new library,then write new program units 
C) Create a new library,then locate program units in the database and copy and paste them into the library 
D) Create a new library,then ask a DBA to add existing program units from the DBMS 
A) Create a new library,add existing program units. 
B) Create a new library,then write new program units 
C) Create a new library,then locate program units in the database and copy and paste them into the library 
D) Create a new library,then ask a DBA to add existing program units from the DBMS

Question 7

To remove an index,use the ____________________ INDEX command.

Accepted Answer

The answer of To remove an index,use the ____________________ INDEX...

Question 8

The _________________________,also called the package header,declares package objects,including variables,cursors,procedures,and functions that are in the package and are to be made public.

Accepted Answer

package sp

Question 9

What is the last command in a function body?

Accepted Answer

A) DONE 
B) RETURN 
C) EXIT 
D) QUIT 
A) DONE 
B) RETURN 
C) EXIT 
D) QUIT

Question 10

If applications frequently insert or modify table data it is better not to use an index.

Accepted Answer

A) True 
 B)False

Question 11

Explain how stored program units are used to make up a larger functional program.Give an example of how one program unit might be called from another.

Accepted Answer

PL/SQL database applications can become

Question 12

What is the purpose of a database table index?

Accepted Answer

A) Keep track of changes 
B) Audit trail 
C) Speed up queries 
D) Modularize code 
A) Keep track of changes 
B) Audit trail 
C) Speed up queries 
D) Modularize code

Question 13

A(n)____________________ is a program unit that can receive multiple input parameters,and always returns a single output value.

Accepted Answer

The answer of A(n)____________________ is a program unit that can...

Question 14

What follows the parameter declaration list in a function?

Accepted Answer

A) IS 
B) RETURN 
C) BEGIN 
D) END 
A) IS 
B) RETURN 
C) BEGIN 
D) END

Question 15

Each program unit that you declare in the package body must have a matching
program unit ____________________ in the package specification,with an identical parameter list.

Accepted Answer

The answer of Each program unit that you declare in...

Question 16

When using Forms Builder to create a package,what is the first step in the process?

Accepted Answer

A) Create a new Package 
B) Create a new Package Spec 
C) Create a new Package Header 
D) Create a new Package Definition 
A) Create a new Package 
B) Create a new Package Spec 
C) Create a new Package Header 
D) Create a new Package Definition

Question 17

If you are passing the value of a named variable to a stored program unit,the variable name must be the same as the corresponding variable name in the program unit parameter declaration list.

Accepted Answer

A) True 
 B)False

Question 18

The ____________________ field of every database table specifies the internal location of the record in the database.

Accepted Answer

The answer of The ____________________ field of every database table...

Question 19

____________________ program units are stored in the database as database objects and execute on the database server.

Accepted Answer

The answer of ____________________ program units are stored in the...

Question 20

Database ____________________ are program units that execute in response to the database events of inserting,updating,or deleting a record.

Accepted Answer

The answer of Database ____________________ are program units that execute...

What is another name for a package header?

The Database Objects node ____.

How do you test a program unit in Forms Builder?

The ____ parameter mode should be used to return a value from a procedure when the input value to the procedure will not be set.

Other database users may execute stored program units.

How do you build a library in Forms Builder?

To remove an index,use the ____________________ INDEX command.

The _________________________,also called the package header,declares package objects,including variables,cursors,procedures,and functions that are in the package and are to be made public.

What is the last command in a function body?

If applications frequently insert or modify table data it is better not to use an index.

Explain how stored program units are used to make up a larger functional program.Give an example of how one program unit might be called from another.

What is the purpose of a database table index?

A(n)____________________ is a program unit that can receive multiple input parameters,and always returns a single output value.

What follows the parameter declaration list in a function?

Each program unit that you declare in the package body must have a matching program unit ____________________ in the package specification,with an identical parameter list.

When using Forms Builder to create a package,what is the first step in the process?

If you are passing the value of a named variable to a stored program unit,the variable name must be the same as the corresponding variable name in the program unit parameter declaration list.

The ____________________ field of every database table specifies the internal location of the record in the database.

____________________ program units are stored in the database as database objects and execute on the database server.

Database ____________________ are program units that execute in response to the database events of inserting,updating,or deleting a record.

Clientserver Databases and the Oracle10g Relational Database

Creating and Modifying Database Tables

Using SQL Queries to Insert, update, delete, and View Data

Introduction to PlSQL

Introduction to Forms Builder

Creating Custom Forms

Creating Database Reports

Creating an Integrated Database Application

Advanced Forms Builder Topics

Introduction to Oracle 10g Database Administration

Filters

Exam 9: Advanced SQL and PlSQL Topics

What is another name for a package header?

The Database Objects node ____.

How do you test a program unit in Forms Builder?

The ____ parameter mode should be used to return a value from a procedure when the input value to the procedure will not be set.

Other database users may execute stored program units.

How do you build a library in Forms Builder?

To remove an index,use the ____________________ INDEX command.

The _________________________,also called the package header,declares package objects,including variables,cursors,procedures,and functions that are in the package and are to be made public.

What is the last command in a function body?

If applications frequently insert or modify table data it is better not to use an index.

Explain how stored program units are used to make up a larger functional program.Give an example of how one program unit might be called from another.

What is the purpose of a database table index?

A(n)____________________ is a program unit that can receive multiple input parameters,and always returns a single output value.

What follows the parameter declaration list in a function?

Each program unit that you declare in the package body must have a matching program unit ____________________ in the package specification,with an identical parameter list.

When using Forms Builder to create a package,what is the first step in the process?

If you are passing the value of a named variable to a stored program unit,the variable name must be the same as the corresponding variable name in the program unit parameter declaration list.

The ____________________ field of every database table specifies the internal location of the record in the database.

____________________ program units are stored in the database as database objects and execute on the database server.

Database ____________________ are program units that execute in response to the database events of inserting,updating,or deleting a record.

Clientserver Databases and the Oracle10g Relational Database

Creating and Modifying Database Tables

Using SQL Queries to Insert, update, delete, and View Data

Introduction to PlSQL

Introduction to Forms Builder

Creating Custom Forms

Creating Database Reports

Creating an Integrated Database Application

Advanced Forms Builder Topics

Introduction to Oracle 10g Database Administration

Filters