Get in here to get the Interview Tips of Various Companies. Or see how to improve performances related to your job.

Test Paper :7
Paper Type : General - other
Posted By : Jai

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
ADVERTISEMENT