Question 1

A(n)____________________ PL/SQL program is one which is submitted to the PL/SQL interpreter and run,but that does not interact with other program units.

Accepted Answer

The answer of A(n)____________________ PL/SQL program is one which is...

Question 2

In a stored procedure,the ____________________ defines the program unit name,specifies the parameters that the program unit receives or delivers,and declares the procedure or function variables.

Accepted Answer

The answer of In a stored procedure,the ____________________ defines the...

Question 3

There are three required parameters that must be specified when creating a trigger: timing,statement,and level.Explain what each of these means and provide an example of how it might be used.

Accepted Answer

Trigger timing defines whether a trigger

Question 4

The parameter mode ____________________ specifies a parameter that is a write-only value that can appear only on the left side of an assignment statement in the program unit.

Accepted Answer

The answer of The parameter mode ____________________ specifies a parameter...

Question 5

To view index names for indexes in your own schema,use the command "SELECT index_name FROM all_indexes".

Accepted Answer

A) True 
 B)False

Question 6

What is the correct order for items in a package specification?

Accepted Answer

A) variables,cursors,functions,procedures 
B) cursors,functions,variables,procedures 
C) functions,procedures,variables,cursors 
D) any order is acceptable 
A) variables,cursors,functions,procedures 
B) cursors,functions,variables,procedures 
C) functions,procedures,variables,cursors 
D) any order is acceptable

Question 7

A(n)____________________ is a code library that contains related program units and variables;it is stored in the database and executes on the database server.

Accepted Answer

The answer of A(n)____________________ is a code library that contains...

Question 8

What type of database column is indexed automatically?

Accepted Answer

A) Primary key column 
B) Columns with data type NUMBER 
C) Foreign key columns 
D) Unique key columns 
A) Primary key column 
B) Columns with data type NUMBER 
C) Foreign key columns 
D) Unique key columns

Question 9

The ____ parameter mode indicates that the parameter will not be modified by the procedure.

Accepted Answer

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

Question 10

____________________ PL/SQL program units are program units that other PL/SQL programs can reference,and that other database users can execute.

Accepted Answer

The answer of ____________________ PL/SQL program units are program units...

Question 11

What is the maximum number of indexes a table can have?

Accepted Answer

A) 2 
B) 5 
C) 99 
D) Unlimited 
A) 2 
B) 5 
C) 99 
D) Unlimited

Question 12

Database triggers is another name for Form Triggers.

Accepted Answer

A) True 
 B)False

Question 13

It is more efficient to create an index when the table is empty,before adding any data.

Accepted Answer

A) True 
 B)False

Question 14

Explain how Oracle implements a database index.

Accepted Answer

To speed up data retrievals on queries t

Question 15

A PL/SQL ____________________ is an operating system file that contains code for multiple related procedures and functions.

Accepted Answer

The answer of A PL/SQL ____________________ is an operating system...

Question 16

What is the name of the table field that stores information about the physical location of a row?

Accepted Answer

A) ROWNUM 
B) ROWID 
C) ROWLOC 
D) ROWPOS 
A) ROWNUM 
B) ROWID 
C) ROWLOC 
D) ROWPOS

Question 17

The ____________________ contains the commands to create the program units that the package specification declares.

Accepted Answer

The answer of The ____________________ contains the commands to create...

Question 18

A library is the only client-side stored program unit.

Accepted Answer

A) True 
 B)False

Question 19

To call a function from a SQL*Plus session assign the return value of the function to a variable using the assignment operator (:=).

Accepted Answer

A) True 
 B)False

Question 20

How many input parameters can a function have?

Accepted Answer

A) 0 
B) 1 
C) 10 
D) unlimited 
A) 0 
B) 1 
C) 10 
D) unlimited

A(n)____________________ PL/SQL program is one which is submitted to the PL/SQL interpreter and run,but that does not interact with other program units.

In a stored procedure,the ____________________ defines the program unit name,specifies the parameters that the program unit receives or delivers,and declares the procedure or function variables.

There are three required parameters that must be specified when creating a trigger: timing,statement,and level.Explain what each of these means and provide an example of how it might be used.

The parameter mode ____________________ specifies a parameter that is a write-only value that can appear only on the left side of an assignment statement in the program unit.

To view index names for indexes in your own schema,use the command "SELECT index_name FROM all_indexes".

What is the correct order for items in a package specification?

A(n)____________________ is a code library that contains related program units and variables;it is stored in the database and executes on the database server.

What type of database column is indexed automatically?

The ____ parameter mode indicates that the parameter will not be modified by the procedure.

____________________ PL/SQL program units are program units that other PL/SQL programs can reference,and that other database users can execute.

What is the maximum number of indexes a table can have?

Database triggers is another name for Form Triggers.

It is more efficient to create an index when the table is empty,before adding any data.

Explain how Oracle implements a database index.

A PL/SQL ____________________ is an operating system file that contains code for multiple related procedures and functions.

What is the name of the table field that stores information about the physical location of a row?

The ____________________ contains the commands to create the program units that the package specification declares.

A library is the only client-side stored program unit.

To call a function from a SQL*Plus session assign the return value of the function to a variable using the assignment operator (:=).

How many input parameters can a function have?

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

A(n)____________________ PL/SQL program is one which is submitted to the PL/SQL interpreter and run,but that does not interact with other program units.

In a stored procedure,the ____________________ defines the program unit name,specifies the parameters that the program unit receives or delivers,and declares the procedure or function variables.

There are three required parameters that must be specified when creating a trigger: timing,statement,and level.Explain what each of these means and provide an example of how it might be used.

The parameter mode ____________________ specifies a parameter that is a write-only value that can appear only on the left side of an assignment statement in the program unit.

To view index names for indexes in your own schema,use the command "SELECT index_name FROM all_indexes".

What is the correct order for items in a package specification?

A(n)____________________ is a code library that contains related program units and variables;it is stored in the database and executes on the database server.

What type of database column is indexed automatically?

The ____ parameter mode indicates that the parameter will not be modified by the procedure.

____________________ PL/SQL program units are program units that other PL/SQL programs can reference,and that other database users can execute.

What is the maximum number of indexes a table can have?

Database triggers is another name for Form Triggers.

It is more efficient to create an index when the table is empty,before adding any data.

Explain how Oracle implements a database index.

A PL/SQL ____________________ is an operating system file that contains code for multiple related procedures and functions.

What is the name of the table field that stores information about the physical location of a row?

The ____________________ contains the commands to create the program units that the package specification declares.

A library is the only client-side stored program unit.

To call a function from a SQL*Plus session assign the return value of the function to a variable using the assignment operator (:=).

How many input parameters can a function have?

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