Question 1

A(n)______________ is a construct in a database programming language that allows for storage and iteration of a set of records returned by a SELECT statement.

Accepted Answer

cursor

Question 2

In the case of overlapping triggers,which of the following is true?

Accepted Answer

A)  The firing order is predictable and can be depended on to be the same every time. 
B)  The firing order has not been specified for SQL:2003. 
C)  The firing order is the same for all DBMSs. 
D)  None of the above. 
A)  The firing order is predictable and can be depended on to be the same every time. 
B)  The firing order has not been specified for SQL:2003. 
C)  The firing order is the same for all DBMSs. 
D)  None of the above. D

Question 3

With regards to conditional decision making in PL/SQL,which statement is true?

Accepted Answer

A)  A condition must evaluate to TRUE or FALSE. 
B)  Complex conditions are evaluated left to right, and this order cannot be altered. 
C)  Conditions are evaluated using three-value logic. 
D)  There is a limit to the number of statements that can be used between the THEN and END-IF keywords. 
A)  A condition must evaluate to TRUE or FALSE. 
B)  Complex conditions are evaluated left to right, and this order cannot be altered. 
C)  Conditions are evaluated using three-value logic. 
D)  There is a limit to the number of statements that can be used between the THEN and END-IF keywords. C

Question 4

The ______________________________ specifies the order of execution among the various kinds of triggers,integrity constraints,and database manipulation statements.

Accepted Answer

trigger ex

Question 5

Which of the following is not a common cursor attribute?

Accepted Answer

A)  %IsOpen. 
B)  %IsNotOpen. 
C)  %Found. 
D)  %NotFound. 
A)  %IsOpen. 
B)  %IsNotOpen. 
C)  %Found. 
D)  %NotFound.

Question 6

The PL/SQL code block above is an example of:

Accepted Answer

A)  An anonymous block. 
B)  A PL/SQL package. 
C)  A PL/SQL function. 
D)  None of the above. 
A)  An anonymous block. 
B)  A PL/SQL package. 
C)  A PL/SQL function. 
D)  None of the above.

Question 7

In a PL/SQL IF statement,the keywords AND,OR and NOT are ____________ operators.

Accepted Answer

The answer of In a PL/SQL IF statement,the keywords AND,OR...

Question 8

A package ________________ contains the private details of a package.

Accepted Answer

implementa

Question 9

To support customized code,most database application development tools use a coding style known as _________________.

Accepted Answer

The answer of To support customized code,most database application development...

Question 10

A(n)_____________ level interface is a language style that involves changes to the syntax of a host programming language to accommodate embedded SQL statements.

Accepted Answer

The answer of A(n)_____________ level interface is a language style...

Question 11

The PL/SQL statement "FOR StudentRec IN SELECT StudentID FROM StudentTable" is an example of:

Accepted Answer

A)  An implicit cursor. 
B)  An explicit cursor. 
C)  A dynamic cursor. 
D)  This statement does not define a cursor. 
A)  An implicit cursor. 
B)  An explicit cursor. 
C)  A dynamic cursor. 
D)  This statement does not define a cursor.

Question 12

Integrity constraints that compare the values before and after an update to a table occurs are called ___________.

Accepted Answer

transition

Question 13

One of the advantages of using a package over procedures and functions is:

Accepted Answer

A)  A package supports a larger unit of modularity. 
B)  Packages provide easier reuse of code. 
C)  Packages reduce software maintenance costs. 
D)  All of the above. 
A)  A package supports a larger unit of modularity. 
B)  Packages provide easier reuse of code. 
C)  Packages reduce software maintenance costs. 
D)  All of the above.

Question 14

A _____________________ is a procedural language with an interface to one or more DBMSs.

Accepted Answer

database p

Question 15

Based on the PL/SQL code block above,if there is not a SSN in the Student table which matches the value provided:

Accepted Answer

A)  The code will return the name of the Student record that is the closest numeric match. 
B)  The code will raise an application error. 
C)  The code will stop executing without any explanation. 
D)  The code will return NULL. 
A)  The code will return the name of the Student record that is the closest numeric match. 
B)  The code will raise an application error. 
C)  The code will stop executing without any explanation. 
D)  The code will return NULL.

Question 16

An explicit cursor cannot use parameters for non-constant search values in the associated SELECT statement.

Accepted Answer

A) True 
 B)False

Question 17

In the use of an explicit cursor,which 3 statements replace the FOR statement of an implicit cursor?

Accepted Answer

A)  OPEN, FIND, and CLOSE. 
B)  OPEN, FETCH, and CLOSE. 
C)  OPEN, GET, and CLOSE. 
D)  CONNECT, FIND, and CLOSE. 
A)  OPEN, FIND, and CLOSE. 
B)  OPEN, FETCH, and CLOSE. 
C)  OPEN, GET, and CLOSE. 
D)  CONNECT, FIND, and CLOSE.

Question 18

Since PL/SQL is a block structured language,all code blocks must have unique names in order to execute in SQL*Plus.

Accepted Answer

A) True 
 B)False

Question 19

A Call-Level Interfaceis a language style for integrating a programming language with a nonprocedural language such as SQL.A statement-level interface involves changes to the syntax of a host programming language to accommodate embedded SQL statements.

Accepted Answer

A) True 
 B)False

Question 20

For each object defined in a package interface,the package body must define:

Accepted Answer

A)  A private object. 
B)  An implementation. 
C)  A cursor. 
D)  An exception handler. 
A)  A private object. 
B)  An implementation. 
C)  A cursor. 
D)  An exception handler.

A(n)______________ is a construct in a database programming language that allows for storage and iteration of a set of records returned by a SELECT statement.

In the case of overlapping triggers,which of the following is true?

With regards to conditional decision making in PL/SQL,which statement is true?

The ______________________________ specifies the order of execution among the various kinds of triggers,integrity constraints,and database manipulation statements.

Which of the following is not a common cursor attribute?

The PL/SQL code block above is an example of:

In a PL/SQL IF statement,the keywords AND,OR and NOT are ____________ operators.

A package ________________ contains the private details of a package.

To support customized code,most database application development tools use a coding style known as _________________.

A(n)_____________ level interface is a language style that involves changes to the syntax of a host programming language to accommodate embedded SQL statements.

The PL/SQL statement "FOR StudentRec IN SELECT StudentID FROM StudentTable" is an example of:

Integrity constraints that compare the values before and after an update to a table occurs are called ___________.

One of the advantages of using a package over procedures and functions is:

A _____________________ is a procedural language with an interface to one or more DBMSs.

Based on the PL/SQL code block above,if there is not a SSN in the Student table which matches the value provided:

An explicit cursor cannot use parameters for non-constant search values in the associated SELECT statement.

In the use of an explicit cursor,which 3 statements replace the FOR statement of an implicit cursor?

Since PL/SQL is a block structured language,all code blocks must have unique names in order to execute in SQL*Plus.

A Call-Level Interfaceis a language style for integrating a programming language with a nonprocedural language such as SQL.A statement-level interface involves changes to the syntax of a host programming language to accommodate embedded SQL statements.

For each object defined in a package interface,the package body must define:

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

A(n)______________ is a construct in a database programming language that allows for storage and iteration of a set of records returned by a SELECT statement.

In the case of overlapping triggers,which of the following is true?

With regards to conditional decision making in PL/SQL,which statement is true?

The ______________________________ specifies the order of execution among the various kinds of triggers,integrity constraints,and database manipulation statements.

Which of the following is not a common cursor attribute?

The PL/SQL code block above is an example of:

In a PL/SQL IF statement,the keywords AND,OR and NOT are ____________ operators.

A package ________________ contains the private details of a package.

To support customized code,most database application development tools use a coding style known as _________________.

A(n)_____________ level interface is a language style that involves changes to the syntax of a host programming language to accommodate embedded SQL statements.

The PL/SQL statement "FOR StudentRec IN SELECT StudentID FROM StudentTable" is an example of:

Integrity constraints that compare the values before and after an update to a table occurs are called ___________.

One of the advantages of using a package over procedures and functions is:

A _____________________ is a procedural language with an interface to one or more DBMSs.

Based on the PL/SQL code block above,if there is not a SSN in the Student table which matches the value provided:

An explicit cursor cannot use parameters for non-constant search values in the associated SELECT statement.

In the use of an explicit cursor,which 3 statements replace the FOR statement of an implicit cursor?

Since PL/SQL is a block structured language,all code blocks must have unique names in order to execute in SQL*Plus.

A Call-Level Interfaceis a language style for integrating a programming language with a nonprocedural language such as SQL.A statement-level interface involves changes to the syntax of a host programming language to accommodate embedded SQL statements.

For each object defined in a package interface,the package body must define:

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