DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: help on plsql questions

  1. #1
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401
    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




  2. #2
    Join Date
    Apr 2001
    Location
    Jakarta
    Posts
    1

    Smile

    hi...
    I am afraid I can't help you with your questions but I know where you can look for the answer. It's PL/SQl book named
    ORACLE 8 PL/SQL PROGRAMMING (Scott Urman, Oracle Press)...

    By the way.. I wonder where you get the questions.
    Are you planning to take an OCP ?
    Do you have some dumps on OCP in developer?
    If so , please tell me where I can find it....

    Thanks

    Hadiman

  3. #3
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401
    no I have no idea on OCP dumps.

    Some body gave these questions and I found these interesting so thought let me post .


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