Oracle India Pvt Ltd Placement Paper
Company: Oracle India Pvt Ltd
ORACLE LATEST PLACEMENT PAPER (SQL, PL/SQL)
1. What does a COMMIT statement do to a CURSOR
a] Open the Cursor
b] Fetch the Cursor
c] Close the Cursor
d] None of the above
Ans : D
2. Which of the following is TRUE
1] Host variables are declared anywhere in the program
2] Host variables are declared in the DECLARE section
a] Only 1 is TRUE
b] Only 2 is TRUE
c] Both 1 & 2are TRUE
d] Both are FALSE
Ans : B
3. Which of the following is NOT VALID is PL/SQL
a] Bool boolean;
b] NUM1, NUM2 number;
c] deptname dept.dname%type;
d] date1 date := sysdate
Ans : B
4. Declare
fvar number := null; svar number := 5
Begin
goto << fproc>>
if fvar is null then
<< fproc>>
svar := svar + 5
end if;
End;
What will be the value of svar after the execution ?
a] Error
b] 10
c] 5
d] None of the above
Ans : A
5. Which of the following is not correct about an Exception ?
a] Raised automatically / Explicitly in response to an ORACLE_ERROR
b] An exception will be raised when an error occurs in that block
c] Process terminates after completion of error sequence.
d] A Procedure or Sequence of statements may be processed.
Ans : C
6. Which of the following is not correct about User_Defined Exceptions ?
a] Must be declared
b] Must be raised explicitly
c] Raised automatically in response to an Oracle error
d] None of the above
Ans : C
7. A Stored Procedure is a
a] Sequence of SQL or PL/SQL statements to perform specific function
b] Stored in compiled form in the database
c] Can be called from all client environments
d] All of the above
Ans : D
8. Which of the following statement is false
a] Any procedure can raise an error and return an user message and error number
b] Error number ranging from 20000 to 20999 are reserved for user defined messages
c] Oracle checks Uniqueness of User defined errors
d] Raise_Application_error is used for raising an user defined error.
Ans : C
9. Is it possible to open a cursor which is in a Package in another procedure ?
a] Yes
b] No
Ans : A
10. Is it possible to use Transactional control statements in Database Triggers ?
a] Yes
b] No
Ans : B
11. Is it possible to Enable or Disable a Database trigger ?
a] Yes
b] No
Ans : A
12. PL/SQL supports datatype(s)
a] Scalar datatype
b] Composite datatype
c] All of the above
d] None of the above
Ans C
13. Find the ODD data type out
a] VARCHAR2
b] RECORD
c] BOOLEAN
d] RAW
Ans : B
14. Which of the following is not correct about the “TABLE” data type ?
a] Can contain any no of columns
b] Simulates a One-dimensional array of unlimited size
c] Column datatype of any Scalar type
d] None of the above
Ans : A
15. Find the ODD one out of the following
a] OPEN
b] CLOSE
c] INSERT
d] FETCH
Ans C
16. Which of the following is not correct about Cursor ?
a] Cursor is a named Private SQL area
b] Cursor holds temporary results
c] Cursor is used for retrieving multiple rows
d] SQL uses implicit Cursors to retrieve rows
Ans : B
18. Which of the following is NOT VALID in PL/SQL ?
a] Select … into
b] Update
c] Create
d] Delete
Ans : C
19. What is the Result of the following ‘VIK’||NULL||’RAM’ ?
a] Error
b] VIK RAM
c] VIKRAM
d] NULL
Ans : C
20. Declare
a number := 5; b number := null; c number := 10;
Begin
if a > b AND a < c then a := c * a; end if; End; What will be the value of ‘a’ after execution ? a] 50 b] NULL c] 5 d] None of the above
Ans : C
21. Does the Database trigger will fire when the table is TRUNCATED ?
a] Yes
b] No
Ans : B
22. SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return
a] ALWAY
b} S ALWA
c] ALWAYS
Ans : C
23. REPLACE(‘JACK AND JUE’,’J’,’BL’) will return
a] JACK AND BLUE
b] BLACK AND JACK
c] BLACK AND BLUE
d] None of the above
Ans : C
24. TRANSLATE(‘333SQD234′,’0123456789ABCDPQRST’,’0123456789′) will return
a] 333234
b] 333333
c] 234333
d] None of the above
Ans : A
25.. EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH 2850 A500 BALAJI 5750 Use these data for the following Questions Select SAL from EMP E1 where 3 > ( Select count(*) from Emp E2
where E1.SAL > E2.SAL ) will retrieve
a] 3500,5000,2500
b] 5000,2850
c] 2850,5750
d] 5000,5750
Ans : A
26. Is it possible to modify a Data type of a column when column contains data ?
a] Yes
b] No
Ans B
27. Which of the following is not correct about a View ?
a] To protect some of the columns of a table from other users
b] Occupies data storage space
c] To hide complexity of a query
d] To hide complexity of a calculations
Ans : B
28. Which is not part of the Data Definition Language ?
a] CREATE
b] ALTER
c] ALTER SESSION
Ans : C
29. The Data Manipulation Language statements are
a] INSERT
b] UPDATE
c] SELECT
d] All of the above
Ans : D
30. EMPNO ENAME SAL
A822 RAMASWAMY 3500
A812 NARAYAN 5000
A973 UMESH
A500 BALAJI 5750
Using the above data Select count(sal) from Emp will retrieve
a] 1
b] 0
c] 3
d] None of the above
Ans : C
31. If an UNIQUE KEY constraint on DATE column is created, will it accept the rows that are inserted with SYSDATE ?
a] Will
b] Won’t
Ans : B
32. What are the different events in Triggers ?
a] Define, Create
b] Drop, Comment
c] Insert, Update, Delete
d] All of the above
Ans : C
33. What built-in subprogram is used to manipulate images in image items ?
a] Zoom_out
b] Zoom_in’
c] Image_zoom
d] Zoom_image
Ans : C
34. Can we pass RECORD GROUP between FORMS ?
a] Yes
b] No
Ans : A
36. SHOW_ALERT function returns
a] Boolean
b] Number
c] Character
d] None of the above
Ans : B
37. What SYSTEM VARIABLE is used to refer DATABASE TIME ?
a] $$dbtime$$
b] $$time$$
c] $$datetime$$
d] None of the above
Ans : A
38. :SYSTEM.EFFECTIVE.DATE varaible is
a] Read only
b] Read & Write
c] Write only
d] None of the above
Ans : C
39.. How can you CALL Reports from Forms4.0 ?
a] Run_Report built_in
b] Call_Report built_in
c] Run_Product built_in
d] Call_Product built_in
Ans : C
85. When do you get a .PLL extension ?
a] Save Library file
b] Generate Library file
c] Run Library file
d] None of the above
Ans : A
40. What is built_in Subprogram ?
a] Stored procedure & Function
b] Collection of Subprogram
c] Collection of Packages
d] None of the above
Ans : D
41. GET_BLOCK property is a
a] Restricted procedure
b] Unrestricted procedure
c] Library function
d] None of the above
Oracle India Pvt Ltd Placement Paper
About Oracle India Pvt Ltd
Quickly locate the Oracle India field office; write, click or call for your sales, product, support, education, … Oracle India Private Limited..visit offical website of Oracle India Pvt Ltd for more details.