Oracle  Placement Paper   General - Other   -1 Jan 2004

Oracle  Placement Paper   General - Other   -1 Jan 2004


  • Posted by  FreshersWorld 
    7 Jan, 2012

    Question Paper:
    1. It contains 30 Questions of SQL + PL/SQL and the TIME allocated
    is 30 minutes
    STRICTLY!

    2. After test (15 Mins.) a Oracle guy declared test results by  announcing the full name of candidates and apologising to others. Very Polite.

    3. Then another test for Programming is there.

    4. After this they have to go for the round of Interviews.I remembered some questions from the Test Paper:
    (I wish this will help others in their preparations)

    (THESE QUESTIONS ARE IN RANDOM ORDER)

    Q. DELETE FROM TABLE TempV WHERE ROWID IN
    (SELECT ROWID FROM TempV WHERE ROWID IN (
    ((SELECT MIN(ROWID) FROM TempV
    WHERE ... COUNT(*) > 1)))
    UNION
    (SELECT ROWID FROM TempV WHERE ROWID IN (
    ((SELECT MIN(ROWID) FROM TempV
    WHERE ... COUNT(*) > 1)));

    Q. When there is a failure in fetching the rows from a cursor...
    A. %ISOPEN
    B. %NOTFOUND
    C. %FOUND
    D. %ROWCOUNT

    Q. SELECT 'ORACLE' FROM DUAL WHERE NULL = NULL;
    A. ORACLE
    B. NULL
    C. ERROR OUT
    D. NO ROWS SELECTED

    Q. There is a question of Package body and Package Specification,  they have provided the code for that describing the scenario of  movie_tickets_sold and asked the programmer to insert a block of  code...., where that code block to be inserted? In Package body? or  in Package Specification?

    Q. Which of the following operator is not used in Outer Join?
    a. =
    b. !=
    c. AND
    d. OR

    Q. PL/SQL uses which of the following
    a. Early Binding
    b. Late binding
    c. No Binding
    d. Deferred Binging

    Q. followin is a database trigger,

    CREATE OR REPLACE TRIGGER delete_row
    ON DELETE  did not remember the complete code for this ...
    ....

    if table contains 100 rows and it is truncated, how many rows get
    updated
    a. 0
    b. 1
    c. 100
    d. No rows updated

     

2009-2016 downloadmela.com. All rights reserved.