Question 1

All objects in a package interface are public.

Accepted Answer

A) True 
 B)False

Question 2

The concept of ______________ for a database programming language involves the association of an SQL statement with its access plan.

Accepted Answer

The answer of The concept of ______________ for a database...

Question 3

A package ________________ contains the definitions of procedures and functions along with other objects that can be specified in the DECLARE section of a PL/SQL block.

Accepted Answer

The answer of A package ________________ contains the definitions of...

Question 4

Because the SQL:1999 trigger specification was defined in response to vendor implementation,most trigger implementations adhere to the SQL:1999 specification.

Accepted Answer

A) True 
 B)False

Question 5

You can encounter mutating table errors in trigger execution,regardless of the DBMS they are executed on.

Accepted Answer

A) True 
 B)False

Question 6

Because the optimization process can consume considerable computing resources,it is usually desirable to determine the access plan at run-time using dynamic statement binding.

Accepted Answer

A) True 
 B)False

Question 7

An important benefit of PL/SQL functions is that they can be used as expressions in SELECT statements.

Accepted Answer

A) True 
 B)False

Question 8

For most triggers,you can avoid mutating table errors by using statement triggers with new and old values.

Accepted Answer

A) True 
 B)False

Question 9

Open Database Connectivity (ODBC)and Java Database Connectivity (JDBC)are the most widely used _____________ level interfaces.

Accepted Answer

The answer of Open Database Connectivity (ODBC)and Java Database Connectivity...

Question 10

A ______________ can be implicit or explicit.

Accepted Answer

The answer of A ______________ can be implicit or explicit....

Question 11

A trigger execution procedure can be affected by which of the following?

Accepted Answer

A)  The DBMS the triggers are executed on. 
B)  The type of data manipulation statements specified in a trigger. 
C)  Foreign key constraints on referenced rows. 
D)  All of the above. 
A)  The DBMS the triggers are executed on. 
B)  The type of data manipulation statements specified in a trigger. 
C)  Foreign key constraints on referenced rows. 
D)  All of the above.

Question 12

Mutating table errors:

Accepted Answer

A)  Can occur when one table is cloned from another. 
B)  Can occur in trigger actions with SQL statements on the target table or related tables affected by DELETE CASCADE actions. 
C)  Never occur in Oracle databases. 
D)  None of the above. 
A)  Can occur when one table is cloned from another. 
B)  Can occur in trigger actions with SQL statements on the target table or related tables affected by DELETE CASCADE actions. 
C)  Never occur in Oracle databases. 
D)  None of the above.

Question 13

Since the number of triggers is a complicating factor in understanding the interaction among triggers,it is always better to create a few large triggers instead of many smaller triggers.

Accepted Answer

A) True 
 B)False

Question 14

An unnamed PL/SQL block of code,which is useful for testing procedures and triggers,is known as a(n)_________ block.

Accepted Answer

The answer of An unnamed PL/SQL block of code,which is...

Question 15

Inside a package implementation,each procedure or function must be terminated by a(n)_____________ statement containing the procedure or function name.

Accepted Answer

The answer of Inside a package implementation,each procedure or function...

Question 16

What is the primary motivation for using a database programming language?

Accepted Answer

A)  Customization. 
B)  Batch processing. 
C)  Complex operations. 
D)  All of the above. 
A)  Customization. 
B)  Batch processing. 
C)  Complex operations. 
D)  All of the above.

Question 17

Procedures and functions are executed by the rule system of the DBMS not by explicit calls as for triggers.

Accepted Answer

A) True 
 B)False

Question 18

To control complexity among a collection of triggers,which guideline(s)should be followed?

Accepted Answer

A)  Use data manipulation statements primarily in BEFORE triggers. 
B)  For triggers that fire on UPDATE statements, do not list the columns to which the trigger applies. 
C)  Be cautious about creating triggers on tables affected by actions on referenced rows. 
D)  All of the above. 
A)  Use data manipulation statements primarily in BEFORE triggers. 
B)  For triggers that fire on UPDATE statements, do not list the columns to which the trigger applies. 
C)  Be cautious about creating triggers on tables affected by actions on referenced rows. 
D)  All of the above.

Question 19

Two triggers with the same timing,granularity,and applicable table ______________ if an SQL statement may cause both triggers to fire.

Accepted Answer

The answer of Two triggers with the same timing,granularity,and applicable...

Question 20

Functions should be usable in expressions,i.e.a function call can be replaced by the __________ it returns.

Accepted Answer

The answer of Functions should be usable in expressions,i.e.a function...

All objects in a package interface are public.

The concept of ______________ for a database programming language involves the association of an SQL statement with its access plan.

A package ________________ contains the definitions of procedures and functions along with other objects that can be specified in the DECLARE section of a PL/SQL block.

Because the SQL:1999 trigger specification was defined in response to vendor implementation,most trigger implementations adhere to the SQL:1999 specification.

You can encounter mutating table errors in trigger execution,regardless of the DBMS they are executed on.

Because the optimization process can consume considerable computing resources,it is usually desirable to determine the access plan at run-time using dynamic statement binding.

An important benefit of PL/SQL functions is that they can be used as expressions in SELECT statements.

For most triggers,you can avoid mutating table errors by using statement triggers with new and old values.

Open Database Connectivity (ODBC)and Java Database Connectivity (JDBC)are the most widely used _____________ level interfaces.

A ______________ can be implicit or explicit.

A trigger execution procedure can be affected by which of the following?

Mutating table errors:

Since the number of triggers is a complicating factor in understanding the interaction among triggers,it is always better to create a few large triggers instead of many smaller triggers.

An unnamed PL/SQL block of code,which is useful for testing procedures and triggers,is known as a(n)_________ block.

Inside a package implementation,each procedure or function must be terminated by a(n)_____________ statement containing the procedure or function name.

What is the primary motivation for using a database programming language?

Procedures and functions are executed by the rule system of the DBMS not by explicit calls as for triggers.

To control complexity among a collection of triggers,which guideline(s)should be followed?

Two triggers with the same timing,granularity,and applicable table ______________ if an SQL statement may cause both triggers to fire.

Functions should be usable in expressions,i.e.a function call can be replaced by the __________ it returns.

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters

Exam 11: Stored Procedures and Triggers

All objects in a package interface are public.

The concept of ______________ for a database programming language involves the association of an SQL statement with its access plan.

A package ________________ contains the definitions of procedures and functions along with other objects that can be specified in the DECLARE section of a PL/SQL block.

Because the SQL:1999 trigger specification was defined in response to vendor implementation,most trigger implementations adhere to the SQL:1999 specification.

You can encounter mutating table errors in trigger execution,regardless of the DBMS they are executed on.

Because the optimization process can consume considerable computing resources,it is usually desirable to determine the access plan at run-time using dynamic statement binding.

An important benefit of PL/SQL functions is that they can be used as expressions in SELECT statements.

For most triggers,you can avoid mutating table errors by using statement triggers with new and old values.

Open Database Connectivity (ODBC)and Java Database Connectivity (JDBC)are the most widely used _____________ level interfaces.

A ______________ can be implicit or explicit.

A trigger execution procedure can be affected by which of the following?

Mutating table errors:

Since the number of triggers is a complicating factor in understanding the interaction among triggers,it is always better to create a few large triggers instead of many smaller triggers.

An unnamed PL/SQL block of code,which is useful for testing procedures and triggers,is known as a(n)_________ block.

Inside a package implementation,each procedure or function must be terminated by a(n)_____________ statement containing the procedure or function name.

What is the primary motivation for using a database programming language?

Procedures and functions are executed by the rule system of the DBMS not by explicit calls as for triggers.

To control complexity among a collection of triggers,which guideline(s)should be followed?

Two triggers with the same timing,granularity,and applicable table ______________ if an SQL statement may cause both triggers to fire.

Functions should be usable in expressions,i.e.a function call can be replaced by the __________ it returns.

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters