Oracle Placement Paper General - Other -1 Jan 2004
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)
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. %ISOPENB. %NOTFOUNDC. %FOUNDD. %ROWCOUNT
Q. SELECT 'ORACLE' FROM DUAL WHERE NULL = NULL;A. ORACLEB. NULLC. ERROR OUTD. 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. ANDd. OR
Q. PL/SQL uses which of the followinga. Early Bindingb. Late bindingc. No Bindingd. Deferred Binging
Q. followin is a database trigger,
CREATE OR REPLACE TRIGGER delete_rowON DELETE did not remember the complete code for this .......
if table contains 100 rows and it is truncated, how many rows get updateda. 0b. 1c. 100d. No rows updated
2009-2016 downloadmela.com. All rights reserved.