DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2001
    south africa
    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:
    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)

    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

  2. #2
    Join Date
    Nov 2000
    Baltimore, MD USA
    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.