DBM 405 Technology levels--snaptutorial.com

1
DBM 405 Technology levels--snaptutorial.com
2
DBM 405 Technology levels--snaptutorial.com
DBM 405 Week 1 quiz For more classes
visit www.snaptutorial.com   1. TCO 1 - Which of
the following statements is unique to the
three-tier application model? 2. TCO 1 - Which of
the following is an example of an event? 3. TCO 1
- The ____ section of a PL/SQL block contains
code that creates variables, cursors, and
types 4. TCO 1 - The only required sections of a
PL/SQL block are the ____ sections.
3
DBM 405 Technology levels--snaptutorial.com
DBM 405 Week 2 quiz For more classes
visit www.snaptutorial.com   1. TCO 4 - Which of
the following clauses indicates the variable that
is to hold the values that are retrieved from the
database? 2. TCO 4 - _____ are declared and
manipulated in the PL/SQL block code for handling
a set of rows returned by a SELECT statement 3.
TCO 4 - A(n) _____ is a variable that can store
and handle multiple values of the same data type
as one unit
4
DBM 405 Technology levels--snaptutorial.com
DBM 405 Week 3 quiz For more classes
visit www.snaptutorial.com   1. TCO 7 - Which of
the following is an acceptable error number for
the RAISE_APPLICATION_ERROR function? 2. TCO 7 -
Which of the following is saved in an Oracle
application or library on the client-side?
5
DBM 405 Technology levels--snaptutorial.com
DBM 405 Week 4 quiz For more classes
visit www.snaptutorial.com   1. TCO 6 - Which of
the following views can be used to review the
source code of a procedure, function, or
package? 2. TCO 6 - If a dependent object has an
older ____ than the referenced object when
called, the dependent object is flagged as
INVALID and needs to be recompiled. 3. TCO 6 - A
program unit is said to contain ____ when it
includes references to database objects that in
turn references other database objects. 4. TCO 6
- When a procedure is compiled, it stores the
____ of any referenced objects.
6
DBM 405 Technology levels--snaptutorial.com
DBM 405 Week 5 quiz For more classes
visit www.snaptutorial.com   1. TCO 3 - The
values checked in the ____ clause of a trigger
must reference correlation identifiers 2. TCO 3 -
Which of the following statements recompiles the
trigger named sales_trg? 3. TCO 3 - A(n)
____triggeris a PL/SQL block that executes in
place of a DML action on a database view 4. TCO 3
- The default timing of a trigger is ____.
7
DBM 405 Technology levels--snaptutorial.com
DBM 405 Week 6 quiz For more classes
visit www.snaptutorial.com   1. TCO 3 - Which of
the following is not a new procedure in
ULT_FILE. 2. TCO 3 - Prior to which version of
Oracle did the UTL_FILE package have to be
explicitly compiled into the database as it was
not part of the installation?
8
DBM 405 Technology levels--snaptutorial.com
DBM 405 Week 7 quiz For more classes
visit www.snaptutorial.com   1. TCO 8 - Where
does the Web browser run? 2. TCO 8 - Which of the
following is NOT a benefit of using a common and
simple user interface with Internet
technologies? 3. TCO 8 - To create a data source
name, ____ is the one that you do NOT need to
provide
9
DBM 405 Technology levels--snaptutorial.com