Question 1

The first field of a composite index is the ____________________ field.

Accepted Answer

The answer of The first field of a composite index...

Question 2

How do you specify that a trigger should only fire if the value of the column AMOUNT is less than 100?

Accepted Answer

A) IF amount < 100 
B) WHEN amount < 100 
C) ONLY IF amount < 100 
D) ONLY WHEN amount < 100 
A) IF amount < 100 
B) WHEN amount < 100 
C) ONLY IF amount < 100 
D) ONLY WHEN amount < 100

Question 3

A PL/SQL stored program unit can run on either the database server or on the client workstation.

Accepted Answer

A) True 
 B)False

Question 4

Variables declared in a package can only be used within the package.

Accepted Answer

A) True 
 B)False

Question 5

How do you call a function from a PL/SQL program?

Accepted Answer

A) EXECUTE function_name (parameters... ) 
B) CALL function_name (parameters ... ) 
C) variable := function_name (parameters ... ) 
D) RUN function_name (parameters ... ) 
A) EXECUTE function_name (parameters... ) 
B) CALL function_name (parameters ... ) 
C) variable := function_name (parameters ... ) 
D) RUN function_name (parameters ... )

Question 6

Why is it convenient to use Forms Builder to develop stored program units?

Accepted Answer

You can use Forms Builder to develop sto

Question 7

What keyword indicates the start of the body of a stored procedure?

Accepted Answer

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

Question 8

How do you temporarily disable a trigger called my_trigger?

Accepted Answer

A) DROP TRIGGER my_trigger 
B) DISABLE TRIGGER my_trigger 
C) ALTER TRIGGER my_trigger DISABLE 
D) ALTER my_trigger DISABLE 
A) DROP TRIGGER my_trigger 
B) DISABLE TRIGGER my_trigger 
C) ALTER TRIGGER my_trigger DISABLE 
D) ALTER my_trigger DISABLE

Question 9

What is the keyword that indicates the start of a trigger body?

Accepted Answer

A) EXECUTE 
B) WHEN 
C) START 
D) BEGIN 
A) EXECUTE 
B) WHEN 
C) START 
D) BEGIN

Question 10

Which of the following is a legal command when used in a trigger body?

Accepted Answer

A) COMMIT 
B) SAVEPOINT 
C) SELECT 
D) ROLLBACK 
A) COMMIT 
B) SAVEPOINT 
C) SELECT 
D) ROLLBACK

Question 11

What type of trigger fires only once per row?

Accepted Answer

A) Statement-level trigger 
B) Row-level trigger 
C) Column-level trigger 
D) Field-level trigger 
A) Statement-level trigger 
B) Row-level trigger 
C) Column-level trigger 
D) Field-level trigger

Question 12

What type of program unit may be shared with other users?

Accepted Answer

A) declared 
B) public 
C) stored 
D) defined 
A) declared 
B) public 
C) stored 
D) defined

Question 13

consultant_skill_skill_id_certification is a valid index name.

Accepted Answer

A) True 
 B)False

Question 14

In a procedure declaration,the DEFINE keyword follows the parameter list.

Accepted Answer

A) True 
 B)False

Question 15

A(n)____________________ is a program unit that can receive multiple input parameters and return multiple output values or return no output values.

Accepted Answer

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

Question 16

What keyword indicates that a procedure definition is finished?

Accepted Answer

A) DONE 
B) END 
C) DROP 
D) FINISH 
A) DONE 
B) END 
C) DROP 
D) FINISH

Question 17

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

Accepted Answer

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

Question 18

The IN OUT parameter mode is the default if parameter mode is not specified.

Accepted Answer

A) True 
 B)False

Question 19

Trigger ____________________ defines whether a trigger fires before or after the SQL statement executes,and can have the values BEFORE or AFTER.

Accepted Answer

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

Question 20

To create a package specification in Forms Builder,you create a new program unit of type ____________________,and then create the package specification in the PL/SQL Editor.

Accepted Answer

The answer of To create a package specification in Forms...

The first field of a composite index is the ____________________ field.

How do you specify that a trigger should only fire if the value of the column AMOUNT is less than 100?

A PL/SQL stored program unit can run on either the database server or on the client workstation.

Variables declared in a package can only be used within the package.

How do you call a function from a PL/SQL program?

Why is it convenient to use Forms Builder to develop stored program units?

What keyword indicates the start of the body of a stored procedure?

How do you temporarily disable a trigger called my_trigger?

What is the keyword that indicates the start of a trigger body?

Which of the following is a legal command when used in a trigger body?

What type of trigger fires only once per row?

What type of program unit may be shared with other users?

consultant_skill_skill_id_certification is a valid index name.

In a procedure declaration,the DEFINE keyword follows the parameter list.

A(n)____________________ is a program unit that can receive multiple input parameters and return multiple output values or return no output values.

What keyword indicates that a procedure definition is finished?

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

The IN OUT parameter mode is the default if parameter mode is not specified.

Trigger ____________________ defines whether a trigger fires before or after the SQL statement executes,and can have the values BEFORE or AFTER.

To create a package specification in Forms Builder,you create a new program unit of type ____________________,and then create the package specification in the PL/SQL Editor.

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

The first field of a composite index is the ____________________ field.

How do you specify that a trigger should only fire if the value of the column AMOUNT is less than 100?

A PL/SQL stored program unit can run on either the database server or on the client workstation.

Variables declared in a package can only be used within the package.

How do you call a function from a PL/SQL program?

Why is it convenient to use Forms Builder to develop stored program units?

What keyword indicates the start of the body of a stored procedure?

How do you temporarily disable a trigger called my_trigger?

What is the keyword that indicates the start of a trigger body?

Which of the following is a legal command when used in a trigger body?

What type of trigger fires only once per row?

What type of program unit may be shared with other users?

consultant_skill_skill_id_certification is a valid index name.

In a procedure declaration,the DEFINE keyword follows the parameter list.

A(n)____________________ is a program unit that can receive multiple input parameters and return multiple output values or return no output values.

What keyword indicates that a procedure definition is finished?

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

The IN OUT parameter mode is the default if parameter mode is not specified.

Trigger ____________________ defines whether a trigger fires before or after the SQL statement executes,and can have the values BEFORE or AFTER.

To create a package specification in Forms Builder,you create a new program unit of type ____________________,and then create the package specification in the PL/SQL Editor.

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