MCQ on Oracle
a]
Open the Cursor
b]
Fetch the Cursor
c]
Close the Cursor
d] None of the
above
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
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
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
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.
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
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
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.
9. Is it possible to open a cursor which is in a
Package in another procedure ?
a] Yes
b]
No
10. Is it possible to use Transactional control
statements in Database Triggers ?
a]
Yes
b] No
11. Is it possible to Enable or Disable a Database
trigger ?
a] Yes
b]
No
12. PL/SQL
supports datatype(s)
a]
Scalar datatype
b]
Composite datatype
c] All of the
above
d]
None of the above
13. Find the ODD
data type out
a]
VARCHAR2
b] RECORD
c]
BOOLEAN
d]
RAW
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
15. Find the ODD
one out of the following
a]
OPEN
b]
CLOSE
c] INSERT
d]
FETCH
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
17. Which of the
following is NOT VALID in PL/SQL ?
a]
Select ... into
b]
Update
c] Create
d]
Delete
18. What is the
Result of the following 'VIK'||NULL||'RAM' ?
a]
Error
b]
VIK RAM
c] VIKRAM
d]
NULL
19. 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
20. Does the
Database trigger will fire when the table is TRUNCATED ?
a]
Yes
b] No
21.
SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return
a]
ALWAY
b}
S ALWA
c] ALWAYS
22.
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
23. GET_BLOCK
property is a
a]
Restricted procedure
b]
Unrestricted procedure
c]
Library function
d]
None of the above
24.
TRANSLATE('333SQD234','0123456789ABCDPQRST','0123456789') will return
a] 333234
b]
333333
c]
234333
d]
None of the above
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
26. Is it
possible to modify a Data type of a column when column contains data ?
a]
Yes
b] No
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
28. Which is not
part of the Data Definition Language ?
a]
CREATE
b]
ALTER
c] ALTER SESSION
29. The Data
Manipulation Language statements are
a]
INSERT
b]
UPDATE
c]
SELECT
d] All of the
above
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
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
32. What are the
different events in Triggers ?
a]
Define, Create
b]
Drop, Comment
c] Insert,
Update, Delete
d]
All of the above
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
34. Can we pass
RECORD GROUP between FORMS ?
a] Yes
b]
No
35. SHOW_ALERT
function returns
a]
Boolean
b] Number
c]
Character
d]
None of the above
36. What SYSTEM
VARIABLE is used to refer DATABASE TIME ?
a] $$dbtime$$
b]
$$time$$
c]
$$datetime$$
d]
None of the above
37.
:SYSTEM.EFFECTIVE.DATE varaible is
a]
Read only
b]
Read & Write
c] Write only
d]
None of the above
38.. 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
39. When do you
get a .PLL extension ?
a] Save Library
file
b]
Generate Library file
c]
Run Library file
d]
None of the above
40. What is
built_in Subprogram ?
a]
Stored procedure & Function
b]
Collection of Subprogram
c]
Collection of Packages
d] None of the
above
41. Out of the
below data types which can be used for Date & time type?
a) Date
b) Datetimeoffset
c) Time
d) All
42. What is the
ISO synonym for ntext data type?
a) New text
b) Next text
c) National Text
d) None of the above
43. Which data
type is used to store binary data up to the limit of 2,147,483,647?
a) Image
b) Text
c) Ntext
d) None of the above
44. Which data
type can be used to represent position in a hierarchy?
a. Hierarchy
b. Hierarchyid
c. Nhierarchyid
d. None of the above
45. What is the
storage size of smallmoney data type?
a) 3 bytes
b) 2 bytes
c) 4 bytes
d) 8 bytes
46. What is the range of TinyInt data type in SQL
Server?
a) 0-10
b) 0-255
c) -2^15 to 2^15-1
d) None of the above
47. Which data
type in SQL server can be used to store time in the table?
a) Timeonly
b) OnlyTime
c) Time
d) DateTime
48. What is the
ISO synonym for real data type in SQL server?
a) Float(24)
b) Float(8)
c) Float(16)
d) None of the above
49. What is the
default size of n in a column which is defined as VARCHAR(n)?
a) NULL
b) 0
c) 1
d) None of the above
50. Which data
type is used for assigning GUID value?
a) UNIQUE
b) UNIQUEIDENTYFIER
c) GUID
d) None of the above
Comments
Post a Comment