Can some body answer for the following questions.Little help also much appreciated.
The____ is a unique locator for certain types of persistent objects.
A: object identifier
B: name identifier
C: name identifier
D: data identifier
Object types are created as ____ dictionary objects.
You can refer to the attributes within an object using ____ notation.
Oracle 8i provides a ____ interface to the event-based tracing available with earlier versions.
C: VB user interface
D: C++ interface
The ____ returns the number of elements currently in a collection, as an integer.
D: none of the above
The ____ object is stored in the database, and is available until explicitly deleted.
A ____ object is stored as a database column, like the scalar types.
In Oracle 8i, if there is an error processing one of the rows in a bulk DML statement, ____ row(s) is rolled back.
____ means to manipulate many variables at once, as one unit.
C: Rollback routine
You may use a ____ declaration to create a type before you know the attributes and/or methods that it will contain.
A: passing type
B: rewind type
C: reverse type
D: forward type
Large objects in Oracle may store up to ____ of binary data.
A packaged function is only as pure as the initialization section of the ____ package.
Inside the package body, objects can be referenced ____ the package name.
When a stored procedure or function is compiled, all of the Oracle objects that it references are recorded in the ____ dictionary.
Which of the following is true regarding the following procedure declaration:
CREATE OR REPLACE PROCEDURE CallMe(
p_ParameterD DATE) AS
A: p_ParameterA VARCHAR2 is associated with v_Variable1 VARCHAR2
B: too large for pl/sql file
C: variable2 is really not a number
D: variable3 is not boolean
If the arguments to a procedure in both the specification and bode were changed in the body, then the ____ would have to be modified to match.
When a procedure is created a ____ is stored in the data dictionary.
D: new name
Oracle 8 provides the ____ package that can be used to provide random numbers.
The maximum length of a pl/sql varchar is ____.
A: 32,767 bytes
B: 56,768 bytes
C: 45,567 bytes
D: 32,980 bytes
The dbms_shared_pool.keep procedure does not load the packaged into the shared pool immediately.
The runtime state of a package-namely, the packaged variables and cursors-is kept in session memory in the ____.
The ____ is the counterpart to send_message, and retrieves a message from a pipe and places it into a local message buffer.
A: sent message
C: done message
D: unsent message
The purity level of ____ for a function indicates that the function does not modify any database tables.
The ____ parameter of a job definition specifies the first time the job will be run after the submit call.
B: future date
Jobs may be exported and imported.
DDL triggers can check the type and name of the object being modified, and can check the userid or username.
Which of the following PL/SQL statements will return the major version of the trace.
'trace major version: ' || v_majorversion);
'trace major version: ' || v_majorversion1);
'trace major version: ' || v_majorversion2);
'trace major version: ' || v_majorversion2);
Which of the following would prompt for an entry by the user in a PL/SQL block?
A: select fn, ln
B: select fn, ln
C: select fn, ln
D: select fn, ln
A ____ operation takes its argument and places it into the buffer for storage.
The event attribute function of ____ returns the userid of the user that fired the trigger.
The abbreviation for PL/SQL errors always begins with ____.
Which of the following is the proper syntax for declaring a parameter with the 'nocopy' hint?
A: parameter_name[mode]copy datatype
B: parameter_name[mode]status datatype
C: parameter_name[mode]new datatype
D: parameter_name[mode]nocopy datatype
Which of the following is a trace that is present in dbms_trace of 8.1.5?
The ____ layer of the db application controls the work done by the application.
A: object logic
B: application logic
C: user logic
D: system logic
The following is the correct usage of the when statement:
Create or replace trigger checkfile
before insert or update of current_credits on students
for each row
when (new.current_credits > 20)
Each line of the internal buffer in SQL PLUS has a limit of ____ characters.
It is legal to use a PL/SQL table inside a package.
A trigger may not issue any ____ control statements.
Exception cannot propagate across remote procedure calls, and therefore a plsql block cannot catch an exception raised by a remote subprogram.
The get_version subprogram of dbms_profiler will return the major and minor versions of the profiler package.
Looks like a take-home test to me...
If so, I would seriously suggest you look elsewhere for answers, or maybe try studying. This forum does not exist to do homework or answer take-home tests.
Click Here to Expand Forum to Full Width