-
hi greetings
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.
A: data
B: object
C: user
D: db
You can refer to the attributes within an object using ____ notation.
A: comma
B: semicolon
C: name
D: dot
Oracle 8i provides a ____ interface to the event-based tracing available with earlier versions.
A: java
B: pl/sql
C: VB user interface
D: C++ interface
The ____ returns the number of elements currently in a collection, as an integer.
A: count(n)
B: count
C: number
D: none of the above
The ____ object is stored in the database, and is available until explicitly deleted.
A: sessient
B: persistent
C: clear
D: db
A ____ object is stored as a database column, like the scalar types.
A: column
B: True
C: row
D: colorful
In Oracle 8i, if there is an error processing one of the rows in a bulk DML statement, ____ row(s) is rolled back.
A: 1
B: 3
C: 2
D: 4
____ means to manipulate many variables at once, as one unit.
A: Routine
B: Collector
C: Rollback routine
D: Collections
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: 2GB
B: 4GB
C: 3GB
D: 1GB
A packaged function is only as pure as the initialization section of the ____ package.
A: calling
B: containing
C: named
D: newer
Inside the package body, objects can be referenced ____ the package name.
A: without
B: within
C: name
D: outside
When a stored procedure or function is compiled, all of the Oracle objects that it references are recorded in the ____ dictionary.
A: data
B: user
C: object
D: layered
Which of the following is true regarding the following procedure declaration:
CREATE OR REPLACE PROCEDURE CallMe(
p_ParameterA VARCHAR2,
p_ParameterB NUMBER,
p_ParameterC BOOLEAN,
p_ParameterD DATE) AS
...
v_Variable1 VARCHAR2(10);
v_Variable2 NUMBER(7,6);
v_Variable3 BOOLEAN;
v_Variable4 DATE;
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.
A: body
B: lower
C: footer
D: header
When a procedure is created a ____ is stored in the data dictionary.
A: name
B: signature
C: order
D: new name
Oracle 8 provides the ____ package that can be used to provide random numbers.
A: dbms_any
B: plsql_random
C: random_random
D: dbms_random
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.
A: True
B: False
The runtime state of a package-namely, the packaged variables and cursors-is kept in session memory in the ____.
A: SGA
B: UGA
C: LGA
D: BGA
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
B: receive_message
C: done message
D: unsent message
The purity level of ____ for a function indicates that the function does not modify any database tables.
A: WNPS
B: RNPS
C: DNNS
D: WNDS
The ____ parameter of a job definition specifies the first time the job will be run after the submit call.
A: next_date
B: future date
C: open_date
D: after_date
Jobs may be exported and imported.
A: True
B: False
DDL triggers can check the type and name of the object being modified, and can check the userid or username.
A: True
B: False
Which of the following PL/SQL statements will return the major version of the trace.
A: dbms_output.put_line(
'trace major version: ' || v_majorversion);
B: dbms_output.put_line(
'trace major version: ' || v_majorversion1);
C: dbms_output.put_line(
'trace major version: ' || v_majorversion2);
D: dbms_output.put_line(
'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
from students
where &where_clause
B: select fn, ln
from students
where +where_clause
C: select fn, ln
from students
where -where_clause
D: select fn, ln
from students
where mwhere_clause
A ____ operation takes its argument and places it into the buffer for storage.
A: out
B: put
C: in
D: one
The event attribute function of ____ returns the userid of the user that fired the trigger.
A: login_user
B: dictionary_obj3_type
C: dictionary_instance_type
D: dictionary_obj_number
The abbreviation for PL/SQL errors always begins with ____.
A: PLS
B: SLP
C: PSL
D: LSP
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?
A: set_plsql_trace
B: sql_plsql_file
C: set_plsql_file
D: set_new_pl_sql_trace
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)
begin
/body/
end;
A: True
B: False
Each line of the internal buffer in SQL PLUS has a limit of ____ characters.
A: 255
B: 456
C: 233
D: 345
It is legal to use a PL/SQL table inside a package.
A: True
B: False
A trigger may not issue any ____ control statements.
A: strict
B: transactional
C: sensational
D: movies
Exception cannot propagate across remote procedure calls, and therefore a plsql block cannot catch an exception raised by a remote subprogram.
A: True
B: False
The get_version subprogram of dbms_profiler will return the major and minor versions of the profiler package.
A: True
B: False
-
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.
- Chris
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|