Question 1

When creating a package specification,components must be declared in the following order: public variables,cursors,functions and procedures.

Accepted Answer

A) True 
 B)False

Question 2

To call a stored procedure from a PL/SQL program,do not use the EXECUTE keyword.

Accepted Answer

A) True 
 B)False

Question 3

If an index does not improve query performance,it should be dropped.

Accepted Answer

A) True 
 B)False

Question 4

A composite index is used for a query that uses logical operators in the search condition.

Accepted Answer

A) True 
 B)False

Question 5

To save a program unit as a stored program unit in the database,you use the ____ node in the Object Navigator

Accepted Answer

A) PL/SQL 
B) Database Objects 
C) Procedures 
D) Functions 
A) PL/SQL 
B) Database Objects 
C) Procedures 
D) Functions

Question 6

To find information on the indexes in your own schema use the ____________________ data dictionary view.

Accepted Answer

The answer of To find information on the indexes in...

Question 7

A database table ____________________ is a distinct database table that contains data values,along with a corresponding column that specifies the physical locations of the records that contain those data values.

Accepted Answer

The answer of A database table ____________________ is a distinct...

Question 8

Database triggers are often used to gather audit information.

Accepted Answer

A) True 
 B)False

Question 9

A(n)____________________ is a database index table that contains multiple sorted columns that the DBMS can use for identifying the row location.

Accepted Answer

The answer of A(n)____________________ is a database index table that...

Question 10

To display a summary listing of compile errors generated by the last program unit that was compiled,you execute the SHOW ERRORS command.

Accepted Answer

A) True 
 B)False

Question 11

Under what circumstances does Oracle Corporation recommend creating an index?

Accepted Answer

Oracle Corporation recommends creating a

Question 12

A PL/SQL package contains exactly the same functionality as a library,but it resides on the database server.

Accepted Answer

A) True 
 B)False

Question 13

A database table cannot have more than five indexes.

Accepted Answer

A) True 
 B)False

Question 14

What is the extension for a PL/SQL library design file?

Accepted Answer

A) psl 
B) lib 
C) pll 
D) plx 
A) psl 
B) lib 
C) pll 
D) plx

Question 15

Which of the following is a reason not to create an index?

Accepted Answer

A) The field contains a large number of null values 
B) The field contains a wide range of values 
C) The table contains a large number of records 
D) Most queries retrieve more than 2% to 4% of the table records 
A) The field contains a large number of null values 
B) The field contains a wide range of values 
C) The table contains a large number of records 
D) Most queries retrieve more than 2% to 4% of the table records

Question 16

Which of the following program units must return exactly one value?

Accepted Answer

A) package 
B) function 
C) procedure 
D) library 
A) package 
B) function 
C) procedure 
D) library

Question 17

The Database Objects node in Forms Builder is a top-level node within the Object Navigator,and is not associated with a specific form.

Accepted Answer

A) True 
 B)False

Question 18

Any stored procedures and functions developed in Forms Builder can never be used by other users.

Accepted Answer

A) True 
 B)False

Question 19

What is the maximum number of columns that can be contained in a composite index?

Accepted Answer

A) 2 
B) 4 
C) 16 
D) 32 
A) 2 
B) 4 
C) 16 
D) 32

Question 20

Every package specification must have a matching package body.

Accepted Answer

A) True 
 B)False

When creating a package specification,components must be declared in the following order: public variables,cursors,functions and procedures.

To call a stored procedure from a PL/SQL program,do not use the EXECUTE keyword.

If an index does not improve query performance,it should be dropped.

A composite index is used for a query that uses logical operators in the search condition.

To save a program unit as a stored program unit in the database,you use the ____ node in the Object Navigator

To find information on the indexes in your own schema use the ____________________ data dictionary view.

A database table ____________________ is a distinct database table that contains data values,along with a corresponding column that specifies the physical locations of the records that contain those data values.

Database triggers are often used to gather audit information.

A(n)____________________ is a database index table that contains multiple sorted columns that the DBMS can use for identifying the row location.

To display a summary listing of compile errors generated by the last program unit that was compiled,you execute the SHOW ERRORS command.

Under what circumstances does Oracle Corporation recommend creating an index?

A PL/SQL package contains exactly the same functionality as a library,but it resides on the database server.

A database table cannot have more than five indexes.

What is the extension for a PL/SQL library design file?

Which of the following is a reason not to create an index?

Which of the following program units must return exactly one value?

The Database Objects node in Forms Builder is a top-level node within the Object Navigator,and is not associated with a specific form.

Any stored procedures and functions developed in Forms Builder can never be used by other users.

What is the maximum number of columns that can be contained in a composite index?

Every package specification must have a matching package body.

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

When creating a package specification,components must be declared in the following order: public variables,cursors,functions and procedures.

To call a stored procedure from a PL/SQL program,do not use the EXECUTE keyword.

If an index does not improve query performance,it should be dropped.

A composite index is used for a query that uses logical operators in the search condition.

To save a program unit as a stored program unit in the database,you use the ____ node in the Object Navigator

To find information on the indexes in your own schema use the ____________________ data dictionary view.

A database table ____________________ is a distinct database table that contains data values,along with a corresponding column that specifies the physical locations of the records that contain those data values.

Database triggers are often used to gather audit information.

A(n)____________________ is a database index table that contains multiple sorted columns that the DBMS can use for identifying the row location.

To display a summary listing of compile errors generated by the last program unit that was compiled,you execute the SHOW ERRORS command.

Under what circumstances does Oracle Corporation recommend creating an index?

A PL/SQL package contains exactly the same functionality as a library,but it resides on the database server.

A database table cannot have more than five indexes.

What is the extension for a PL/SQL library design file?

Which of the following is a reason not to create an index?

Which of the following program units must return exactly one value?

The Database Objects node in Forms Builder is a top-level node within the Object Navigator,and is not associated with a specific form.

Any stored procedures and functions developed in Forms Builder can never be used by other users.

What is the maximum number of columns that can be contained in a composite index?

Every package specification must have a matching package body.

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