No. 1 Fresher Jobs Website in India.
Are you employer? Register to Post Jobs Login
Search Jobs

Exam Paper by Oracle

Details of Exam Paper by Oracle conducted by Oracle for job interview.
Share Us With Others

Oracle 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