Question 1

What naming convention should be followed for indexes?

Accepted Answer

A) The Oracle Naming Convention 
B) tablename_fieldname 
C) fieldname_tablename 
D) in_fieldname_tablename 
A) The Oracle Naming Convention 
B) tablename_fieldname 
C) fieldname_tablename 
D) in_fieldname_tablename

Question 2

The trigger ____________________ defines whether a trigger fires once for each triggering statement or once for each row affected by the triggering statement,and can have the values ROW or STATEMENT.

Accepted Answer

The answer of The trigger ____________________ defines whether a trigger...

Question 3

You can cause a trigger to be executed only if a certain condition is true by adding the WHEN clause to the trigger header.

Accepted Answer

A) True 
 B)False

Question 4

____________________ variables are visible to many different PL/SQL programs.

Accepted Answer

The answer of ____________________ variables are visible to many different...

Question 5

Index names should using the naming convention tablename_fieldname.

Accepted Answer

A) True 
 B)False

Question 6

What type of data structure does Oracle use to store indexes?

Accepted Answer

A) Linked List 
B) Array 
C) B-Tree 
D) Red-Black Tree 
A) Linked List 
B) Array 
C) B-Tree 
D) Red-Black Tree

Question 7

A program unit cannot be used in a larger program.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following program units executes on the client workstation?

Accepted Answer

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

Question 9

A(n)____________________ is a place in the database that stores object identifiers for a user's database objects.

Accepted Answer

The answer of A(n)____________________ is a place in the database...

Question 10

When is the best time to create an index?

Accepted Answer

A) When the table is empty 
B) When the table is half-full 
C) When all rows have been added 
D) It doesn't matter - any time is fine 
A) When the table is empty 
B) When the table is half-full 
C) When all rows have been added 
D) It doesn't matter - any time is fine

Question 11

A PL/SQL library can only contain stored procedures,not functions.

Accepted Answer

A) True 
 B)False

Question 12

How do you reference the previous value of a field from within a trigger?

Accepted Answer

A) :OLD.fieldname 
B) OLD:fieldname 
C) :PREV.fieldname 
D) PREV:fieldname 
A) :OLD.fieldname 
B) OLD:fieldname 
C) :PREV.fieldname 
D) PREV:fieldname

Question 13

How many records does it take for a table to be considered large?

Accepted Answer

A) 100 
B) 1000 
C) 10,000 
D) 100,000 
A) 100 
B) 1000 
C) 10,000 
D) 100,000

Question 14

A composite index can contain up to 16 columns.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following stored program units can return zero,one,or many values?

Accepted Answer

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

Question 16

The ____ command is used to display error information if a procedure does not compile.

Accepted Answer

A) VIEW ERRORS 
B) ERRORS 
C) SEND ERRORS 
D) SHOW ERRORS 
A) VIEW ERRORS 
B) ERRORS 
C) SEND ERRORS 
D) SHOW ERRORS

Question 17

What keyword follows the parameter declaration list in a procedure header?

Accepted Answer

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

Question 18

The ____ keyword is used to call a stored procedure in SQL*Plus.

Accepted Answer

A) CALL 
B) EXECUTE 
C) RUN 
D) No keyword is needed - just the procedure name 
A) CALL 
B) EXECUTE 
C) RUN 
D) No keyword is needed - just the procedure name

Question 19

If you modify a library in Forms Builder,you must reattach the library to the forms that use it before the changes will take effect.

Accepted Answer

A) True 
 B)False

Question 20

The extension for a compiled PL/SQL library is ____________________.

Accepted Answer

The answer of The extension for a compiled PL/SQL library...

What naming convention should be followed for indexes?

The trigger ____________________ defines whether a trigger fires once for each triggering statement or once for each row affected by the triggering statement,and can have the values ROW or STATEMENT.

You can cause a trigger to be executed only if a certain condition is true by adding the WHEN clause to the trigger header.

____________________ variables are visible to many different PL/SQL programs.

Index names should using the naming convention tablename_fieldname.

What type of data structure does Oracle use to store indexes?

A program unit cannot be used in a larger program.

Which of the following program units executes on the client workstation?

A(n)____________________ is a place in the database that stores object identifiers for a user's database objects.

When is the best time to create an index?

A PL/SQL library can only contain stored procedures,not functions.

How do you reference the previous value of a field from within a trigger?

How many records does it take for a table to be considered large?

A composite index can contain up to 16 columns.

Which of the following stored program units can return zero,one,or many values?

The ____ command is used to display error information if a procedure does not compile.

What keyword follows the parameter declaration list in a procedure header?

The ____ keyword is used to call a stored procedure in SQL*Plus.

If you modify a library in Forms Builder,you must reattach the library to the forms that use it before the changes will take effect.

The extension for a compiled PL/SQL library is ____________________.

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 naming convention should be followed for indexes?

The trigger ____________________ defines whether a trigger fires once for each triggering statement or once for each row affected by the triggering statement,and can have the values ROW or STATEMENT.

You can cause a trigger to be executed only if a certain condition is true by adding the WHEN clause to the trigger header.

____________________ variables are visible to many different PL/SQL programs.

Index names should using the naming convention tablename_fieldname.

What type of data structure does Oracle use to store indexes?

A program unit cannot be used in a larger program.

Which of the following program units executes on the client workstation?

A(n)____________________ is a place in the database that stores object identifiers for a user's database objects.

When is the best time to create an index?

A PL/SQL library can only contain stored procedures,not functions.

How do you reference the previous value of a field from within a trigger?

How many records does it take for a table to be considered large?

A composite index can contain up to 16 columns.

Which of the following stored program units can return zero,one,or many values?

The ____ command is used to display error information if a procedure does not compile.

What keyword follows the parameter declaration list in a procedure header?

The ____ keyword is used to call a stored procedure in SQL*Plus.

If you modify a library in Forms Builder,you must reattach the library to the forms that use it before the changes will take effect.

The extension for a compiled PL/SQL library is ____________________.

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