Question 1

Due to the growth of online database processing and commercial Web commerce,batch processing is no longer an important method to process database work.

Accepted Answer

A) True 
 B)False

Question 2

The common SQL*Plus command used to list the columns of a table is ___________.

Accepted Answer

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

Question 3

When writing a PL/SQL procedure,it is good practice to include length constraints in the data type specifications for parameters.

Accepted Answer

A) True 
 B)False

Question 4

A PL/SQL block contains:

Accepted Answer

A)  A required declaration section, a required executable section, and an optional exception section. 
B)  An optional declaration section, a required executable section, and an optional exception section. 
C)  A required declaration section, a required executable section, and a required exception section. 
D)  An optional declaration section, a required executable section, and a required exception section. 
A)  A required declaration section, a required executable section, and an optional exception section. 
B)  An optional declaration section, a required executable section, and an optional exception section. 
C)  A required declaration section, a required executable section, and a required exception section. 
D)  An optional declaration section, a required executable section, and a required exception section.

Question 5

If you omit the keywords FOR EACH ROW from a trigger specification,the trigger by default becomes a(n)_____________ trigger.

Accepted Answer

The answer of If you omit the keywords FOR EACH...

Question 6

A database programming language allows a program to combine procedural statements with non-procedural database access.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is true of PL/SQL iteration statements?

Accepted Answer

A)  The FOR LOOP iterates until a stopping condition is false. 
B)  The WHILE LOOP iterates over a range of integer values. 
C)  The LOOP statement iterates until an EXIT statement ceases termination. 
D)  All of the above. 
A)  The FOR LOOP iterates until a stopping condition is false. 
B)  The WHILE LOOP iterates over a range of integer values. 
C)  The LOOP statement iterates until an EXIT statement ceases termination. 
D)  All of the above.

Question 8

Dynamic binding involves the determination of the access plan at compile time.

Accepted Answer

A) True 
 B)False

Question 9

In PL/SQL,functions should:

Accepted Answer

A)  Always use input parameters. 
B)  Contain a parameter list. 
C)  Generate an output value using a RETURN statement. 
D)  All of the above. 
A)  Always use input parameters. 
B)  Contain a parameter list. 
C)  Generate an output value using a RETURN statement. 
D)  All of the above.

Question 10

Portability across host languages is one advantage of using the statement level interface language style.

Accepted Answer

A) True 
 B)False

Question 11

The PL/SQL code block above:

Accepted Answer

A)  Declares and opens an explicit cursor. 
B)  Declares and opens an implicit cursor. 
C)  Does not use a cursor. 
D)  None of the above. 
A)  Declares and opens an explicit cursor. 
B)  Declares and opens an implicit cursor. 
C)  Does not use a cursor. 
D)  None of the above.

Question 12

As with other programming languages,in PL/SQL the IF-THEN-ELSE statement construct is:

Accepted Answer

A)  A comparison operator. 
B)  A conditional statement. 
C)  A logical operator. 
D)  None of the above. 
A)  A comparison operator. 
B)  A conditional statement. 
C)  A logical operator. 
D)  None of the above.

Question 13

Triggers provide reuse of common code,while stored procedures provide rule processing for common tasks.

Accepted Answer

A) True 
 B)False

Question 14

To use the objects in a package,you must use the package name before the object name.

Accepted Answer

A) True 
 B)False

Question 15

In the body of a function,a(n)______________ statement is used to generate the function's output value.

Accepted Answer

The answer of In the body of a function,a(n)______________ statement...

Question 16

In the PL/SQL code block above,aStdSSN is:

Accepted Answer

A)  A return variable. 
B)  An input parameter. 
C)  A column in the Student table. 
D)  None of the above. 
A)  A return variable. 
B)  An input parameter. 
C)  A column in the Student table. 
D)  None of the above.

Due to the growth of online database processing and commercial Web commerce,batch processing is no longer an important method to process database work.

The common SQL*Plus command used to list the columns of a table is ___________.

When writing a PL/SQL procedure,it is good practice to include length constraints in the data type specifications for parameters.

A PL/SQL block contains:

If you omit the keywords FOR EACH ROW from a trigger specification,the trigger by default becomes a(n)_____________ trigger.

A database programming language allows a program to combine procedural statements with non-procedural database access.

Which of the following is true of PL/SQL iteration statements?

Dynamic binding involves the determination of the access plan at compile time.

In PL/SQL,functions should:

Portability across host languages is one advantage of using the statement level interface language style.

The PL/SQL code block above:

As with other programming languages,in PL/SQL the IF-THEN-ELSE statement construct is:

Triggers provide reuse of common code,while stored procedures provide rule processing for common tasks.

To use the objects in a package,you must use the package name before the object name.

In the body of a function,a(n)______________ statement is used to generate the function's output value.

In the PL/SQL code block above,aStdSSN is:

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

Due to the growth of online database processing and commercial Web commerce,batch processing is no longer an important method to process database work.

The common SQL*Plus command used to list the columns of a table is ___________.

When writing a PL/SQL procedure,it is good practice to include length constraints in the data type specifications for parameters.

A PL/SQL block contains:

If you omit the keywords FOR EACH ROW from a trigger specification,the trigger by default becomes a(n)_____________ trigger.

A database programming language allows a program to combine procedural statements with non-procedural database access.

Which of the following is true of PL/SQL iteration statements?

Dynamic binding involves the determination of the access plan at compile time.

In PL/SQL,functions should:

Portability across host languages is one advantage of using the statement level interface language style.

The PL/SQL code block above:

As with other programming languages,in PL/SQL the IF-THEN-ELSE statement construct is:

Triggers provide reuse of common code,while stored procedures provide rule processing for common tasks.

To use the objects in a package,you must use the package name before the object name.

In the body of a function,a(n)______________ statement is used to generate the function's output value.

In the PL/SQL code block above,aStdSSN is:

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