Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)



1

Most database application development tools support:
A)Customization.
B)Batch processing.
C)Database retrievals that are beyond the operations of Relational Algebra.
D)All of the above.
2

Using a database identifier:
A)Relieves the programmer from knowing the specific web address for a database.
B)Provides the server administrator with more flexibility to relocate a database to a different server.
C)Is an example of an explicit database connection.
D)All of the above.
3

Which of the following is not an iteration statement supported by PL/SQL:
A)The FOR LOOP statement.
B)The LOOP UNTIL statement.
C)The WHILE LOOP statement.
D)None of the above.
4

The common SQL*Plus command which causes the results of PL/SQL statements to be displayed is:
A)SHOW ERRORS.
B)DESCRIBE.
C)SPOOL.
D)SET SERVEROUTPUT ON.
5

In a stored procedure, when specifying a string parameter you should use which of these data types:
A)CHAR
B)VARCHAR2
C)TEXT
D)REAL
6

The INTO clause of the SELECT statement:
A)Can be used only when the SELECT statement returns at most one row.
B)Does not generate an exception if no rows are returned.
C)Is not a valid clause in PL/SQL.
D)None of the above.
7

For more complex procedures and functions involving iteration through multiple rows, PL/SQL supports:
A)Explicit cursors.
B)Implicit cursors.
C)Dynamic cursors.
D)All of the above.
8

Which of the following is not a common cursor attribute?
A)%IsOpen.
B)%IsNotOpen.
C)%Found.
D)%NotFound.
9

Because they should not contain SQL manipulation statements, what kind of trigger is typically used to enforce complex integrity constraints?
A)AFTER ROW triggers.
B)BEFORE ROW triggers.
C)INSTEAD OF triggers.
D)None of the above.





To learn more about the book this website supports, please visit its Information Center.
(c)2007 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Mannino DB Design 3eOnline Learning Center with Powerweb

Home > Chapter 11 > Multiple Choice Quiz