Question 1

The common SQL*Plus command used to display compilation errors is ___________________.

Accepted Answer

The answer of The common SQL*Plus command used to display...

Question 2

A database connection identifies the database used by an application.A database connection can be ________ or ________.

Accepted Answer

A)  implicit/explicit 
B)  internal/external 
C)  implicit/dynamic 
D)  virtual/dynamic 
A)  implicit/explicit 
B)  internal/external 
C)  implicit/dynamic 
D)  virtual/dynamic

Question 3

Like procedures,triggers can be tested directly by executing them in SQL*Plus.

Accepted Answer

A) True 
 B)False

Question 4

In a stored procedure,a(n)_____________ parameter should have a value provided outside the procedure but it can be changed inside the procedure.

Accepted Answer

The answer of In a stored procedure,a(n)_____________ parameter should have...

Question 5

For statement level interfaces,SQL:2003 provides statements to:

Accepted Answer

A)  Declare cursors. 
B)  Position cursors. 
C)  Retrieve values from cursors. 
D)  All of the above. 
A)  Declare cursors. 
B)  Position cursors. 
C)  Retrieve values from cursors. 
D)  All of the above.

Question 6

In PL/SQL,a function is used instead of a procedure when:

Accepted Answer

A)  You want to manipulate output variables. 
B)  You want to produce a side effect. 
C)  You are returning a single value. 
D)  You want to return more than one result. 
A)  You want to manipulate output variables. 
B)  You want to produce a side effect. 
C)  You are returning a single value. 
D)  You want to return more than one result.

Question 7

To catch a specific error in a stored procedure,you should use a predefined exception or create a user-defined exception.

Accepted Answer

A) True 
 B)False

Question 8

In the SQL:2003 specification,a statement level interface can support both static and dynamic binding,while a call level interface supports only dynamic binding.

Accepted Answer

A) True 
 B)False

Question 9

Transitive closure,an important operation for queries involving self-referencing relationships,is supported by most SQL implementations.

Accepted Answer

A) True 
 B)False

Question 10

In PL/SQL,a(n)_____________ statement is comprised of a variable,the assignment symbol,and an expression.

Accepted Answer

The answer of In PL/SQL,a(n)_____________ statement is comprised of a...

Question 11

The two language styles provided by SQL:2003 for integrating a procedural language with SQL are:

Accepted Answer

A)  Statement level interface and function level interface. 
B)  Procedural level interface and trigger level interface. 
C)  Statement level interface and call level interface. 
D)  None of the above. 
A)  Statement level interface and function level interface. 
B)  Procedural level interface and trigger level interface. 
C)  Statement level interface and call level interface. 
D)  None of the above.

Question 12

Which of the following is true of a statement level interface?

Accepted Answer

A)  It is more difficult to learn and use than a CLI. 
B)  It is available only for proprietary languages. 
C)  It includes a set of procedures and a set of type definitions for manipulating the results of SQL statements in computer programs. 
D)  It involves changes to the syntax of a host programming language to accommodate embedded SQL. 
A)  It is more difficult to learn and use than a CLI. 
B)  It is available only for proprietary languages. 
C)  It includes a set of procedures and a set of type definitions for manipulating the results of SQL statements in computer programs. 
D)  It involves changes to the syntax of a host programming language to accommodate embedded SQL.

Question 13

An event-condition-action rule managed by a DBMS is another name for a ____________.

Accepted Answer

The answer of An event-condition-action rule managed by a DBMS...

Question 14

Which of the following is the reason the DBMS,instead of the programming environment,manages stored procedures?

Accepted Answer

A)  A DBMS can compile the programming language code along with the SQL statements in a stored procedure. 
B)  Since they are stored on the server, stored procedures allow flexibility for client-server development. 
C)  Database administrators can manage stored procedures with the same tools for managing other parts of the database. 
D)  All of the above. 
A)  A DBMS can compile the programming language code along with the SQL statements in a stored procedure. 
B)  Since they are stored on the server, stored procedures allow flexibility for client-server development. 
C)  Database administrators can manage stored procedures with the same tools for managing other parts of the database. 
D)  All of the above.

Question 15

A Database Programming Language is a procedural language with an interface to one or more DBMSs.The interface allows a program to combine procedural statements with nonprocedural database access.

Accepted Answer

A) True 
 B)False

Question 16

For procedures and triggers stored in a database,the database connection is explicit.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is not a typical use for triggers:

Accepted Answer

A)  Complex integrity constraints. 
B)  Update propagation. 
C)  Exception reporting. 
D)  All of the above are typical uses for triggers. 
A)  Complex integrity constraints. 
B)  Update propagation. 
C)  Exception reporting. 
D)  All of the above are typical uses for triggers.

Question 18

The _________________ of a trigger involves the keywords BEFORE,AFTER,or INSTEAD OF,along with a triggering event using the keywords INSERT,UPDATE,or DELETE.

Accepted Answer

timing spe

Question 19

The body of a trigger is similar to other PL/SQL blocks,except that triggers have more restrictions on the statements in a block.

Accepted Answer

A) True 
 B)False

Question 20

When a procedure calls itself,this is known as ______________________.

Accepted Answer

The answer of When a procedure calls itself,this is known...

The common SQL*Plus command used to display compilation errors is ___________________.

A database connection identifies the database used by an application.A database connection can be or .

Like procedures,triggers can be tested directly by executing them in SQL*Plus.

In a stored procedure,a(n)_____________ parameter should have a value provided outside the procedure but it can be changed inside the procedure.

For statement level interfaces,SQL:2003 provides statements to:

In PL/SQL,a function is used instead of a procedure when:

To catch a specific error in a stored procedure,you should use a predefined exception or create a user-defined exception.

In the SQL:2003 specification,a statement level interface can support both static and dynamic binding,while a call level interface supports only dynamic binding.

Transitive closure,an important operation for queries involving self-referencing relationships,is supported by most SQL implementations.

In PL/SQL,a(n)_____________ statement is comprised of a variable,the assignment symbol,and an expression.

The two language styles provided by SQL:2003 for integrating a procedural language with SQL are:

Which of the following is true of a statement level interface?

An event-condition-action rule managed by a DBMS is another name for a ____________.

Which of the following is the reason the DBMS,instead of the programming environment,manages stored procedures?

A Database Programming Language is a procedural language with an interface to one or more DBMSs.The interface allows a program to combine procedural statements with nonprocedural database access.

For procedures and triggers stored in a database,the database connection is explicit.

Which of the following is not a typical use for triggers:

The _________________ of a trigger involves the keywords BEFORE,AFTER,or INSTEAD OF,along with a triggering event using the keywords INSERT,UPDATE,or DELETE.

The body of a trigger is similar to other PL/SQL blocks,except that triggers have more restrictions on the statements in a block.

When a procedure calls itself,this is known as ______________________.

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

The common SQL*Plus command used to display compilation errors is ___________________.

A database connection identifies the database used by an application.A database connection can be ________ or ________.

Like procedures,triggers can be tested directly by executing them in SQL*Plus.

In a stored procedure,a(n)_____________ parameter should have a value provided outside the procedure but it can be changed inside the procedure.

For statement level interfaces,SQL:2003 provides statements to:

In PL/SQL,a function is used instead of a procedure when:

To catch a specific error in a stored procedure,you should use a predefined exception or create a user-defined exception.

In the SQL:2003 specification,a statement level interface can support both static and dynamic binding,while a call level interface supports only dynamic binding.

Transitive closure,an important operation for queries involving self-referencing relationships,is supported by most SQL implementations.

In PL/SQL,a(n)_____________ statement is comprised of a variable,the assignment symbol,and an expression.

The two language styles provided by SQL:2003 for integrating a procedural language with SQL are:

Which of the following is true of a statement level interface?

An event-condition-action rule managed by a DBMS is another name for a ____________.

Which of the following is the reason the DBMS,instead of the programming environment,manages stored procedures?

A Database Programming Language is a procedural language with an interface to one or more DBMSs.The interface allows a program to combine procedural statements with nonprocedural database access.

For procedures and triggers stored in a database,the database connection is explicit.

Which of the following is not a typical use for triggers:

The _________________ of a trigger involves the keywords BEFORE,AFTER,or INSTEAD OF,along with a triggering event using the keywords INSERT,UPDATE,or DELETE.

The body of a trigger is similar to other PL/SQL blocks,except that triggers have more restrictions on the statements in a block.

When a procedure calls itself,this is known as ______________________.

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

A database connection identifies the database used by an application.A database connection can be or .