Oracle Database 11g: Advanced Programming with PL/SQL (Mock Assessment Test)

Oracle Database 11g: Advanced Programming with PL/SQL (Mock Assessment Test)

Here is a mock assessment test for the 1Z0-146 certification exam which can be your final warm up game before you appear for the real exam. Questions follow similar pattern but also test your basic understanding on a concept. For answer key – comment on the post with your email id and I shall send across to you the same.

I hope the readers of my book will find the mock paper quite handy while the rest of you will discover the areas to dive in further.

24 thoughts on “Oracle Database 11g: Advanced Programming with PL/SQL (Mock Assessment Test)

  1. Hi Saurabh,
    Question no.11 seems to have only one correct statement. Could you please clarify ?
    Below is the question

    11. Which two statements are true about REF CURSOR types? (Choose two.)

    A. REF CURSOR types cannot be defined inside a package.
    B. SYS_REFCURSOR can be used to declare cursor variables in stored procedures and functions.
    C. A REF CURSOR return type can be declared using %TYPE, or %ROWTYPE, or a user defined record.
    D. Only a weak REF CURSOR type can be used as a formal parameter of a stored procedure or function.

  2. Hi Saurabh,
    Thanks a lot for the answers.
    Regarding Q no : 51, What do you mean by reduntant SQLs ?, I tried searching web, I could not find any results.

  3. Also regarding correct answers given by you for my previous post (REF CURSOR), I have a doubt on answer C, a REF CURSOR return type has to be a record or row type, right? So %TYPE cannot be applicable here, right ?

  4. Hi Saurabh,
    Doubt related to the Question no:53

    53. Identify the ways of PL/SQL tuning
    A. Assigning suitable data type to the variables
    B. Modularized programming
    C. Extensive use of bulk binds
    D. Always constraining the columns at the table definition level

    Could you elobrate briefly on answer B for me ?
    I thought option C was more appropriate .
    Thanks in advance.

  5. Hi Saurabh,
    Please refer below question:

    58. You set the below initialization parameter settings for your database:
    MEMORY_TARGET = 500M
    RESULT_CACHE_MODE = MANUAL
    You execute a query by using the RESULT_CACHE hint. Which statement is true in this scenario?
    A. The query results are not stored because no memory is allocated for the result cache.
    B. The query results are stored and 250M is allocated to the result cache.
    C. The query results are stored and 125m is allocated to the result cache.
    D. The query results are not stored because the RESULT_CACHE_MODE parameter is not set to
    FORCE.

    Dont you think 1.25 (0.25% of 500M) is the correct answer ? Is the dot (.) missing from Option C ?

  6. Thanks a lot for compiling the questions for OCP aspirants like me. I certainly find the questions relevant to 1Z0-146 exam. I am preparing for this exam. Could you please send me the answers on my e-mail id . Thanks again.(Pravin)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s