Oracle Database Question Bank ...9
(Pages 1 2
3 4
5 6
7 8 9 10)
51. 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
52. 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
53. 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
54. 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 environmets
d] All of the above
Ans : D
55. 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
56. Is it possible to open a cursor which is in a Package in another
procedure ?
a] Yes
b] No
Ans : A
57. Is it possible to use Transactional control statements in Database
Triggers ?
a] Yes
b] No
Ans : B
58. Is it possible to Enable or Disable a Database trigger ?
a] Yes
b] No
Ans : A
59. PL/SQL supports datatype(s)
a] Scalar datatype
b] Composite datatype
c] All of the above
d] None of the above
Ans C
60. Find the ODD datatype out
a] VARCHAR2
b] RECORD
c] BOOLEAN
d] RAW
Ans : B
61. Which of the following is not correct about the "TABLE" datatype ?
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
62. Find the ODD one out of the following
a] OPEN
b] CLOSE
c] INSERT
d] FETCH
Ans C
63. 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
64. Which of the following is NOT VALID in PL/SQL ?
a] Select ... into
b] Update
c] Create
d] Delete
Ans : C
65. What is the Result of the following 'VIK'||NULL||'RAM' ?
a] Error
b] VIK RAM
c] VIKRAM
d] NULL
Ans : C
66. 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
67. Does the Database trigger will fire when the table is TRUNCATED ?
a] Yes
b] No
Ans : B
68. SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return
a] ALWAY
b} S ALWA
c] ALWAYS
Ans : C
69. 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
70. TRANSLATE('333SQD234','0123456789ABCDPQRST','0123456789') will return
a] 333234
b] 333333
c] 234333
d] None of the above
Ans : A
71. 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
72. Is it possible to modify a Datatype of a column when column contains
data ?
a] Yes
b] No
Ans B
73. Which of the following is not correct about a View ?
a] To protect some of the columns of a table from other users
b] Ocuupies data storage space
c] To hide complexity of a query
d] To hide complexity of a calculations
Ans : B
74. Which is not part of the Data Definiton Language ?
a] CREATE
b] ALTER
c] ALTER SESSION
Ans : C
75. The Data Manipulation Language statements are
a] INSERT
b] UPDATE
c] SELECT
d] All of the above
Ans : D
76. 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
77. 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
78. What are the different events in Triggers ?
a] Define, Create
b] Drop, Comment
c] Insert, Update, Delete
d] All of the above
Ans : C
79. 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
80. Can we pass RECORD GROUP between FORMS ?
a] Yes
b] No
Ans : A
81. SHOW_ALERT function returns
a] Boolean
b] Number
c] Character
d] None of the above
Ans : B
82. What SYSTEM VARIABLE is used to refer DATABASE TIME ?
a] $$dbtime$$
b] $$time$$
c] $$datetime$$
d] None of the above
Ans : A
83. :SYSTEM.EFFECTIVE.DATE varaible is
a] Read only
b] Read & Write
c] Write only
d] None of the above
Ans : C
84. 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
86. What is built_in Subprogram ?
a] Stored procedure & Function
b] Collection of Subprogram
c] Collection of Packages
d] None of the above
Ans : D
87. GET_BLOCK property is a
a] Restricted procedure
b] Unrestricted procedure
c] Library function
d] None of the above
Ans : D
88. A CONTROL BLOCK can sometimes refer to a BASETABLE ?
a] TRUE
b] FALSE
Ans : B
89. What do you mean by CHECK BOX ?
a] Two state control
b] One state control
c] Three state control
d] none of the above
Ans : C - Please check the Correcness of this Answer ( The correct answer
is 2 )
90. List of Values (LOV) supports
a] Single column
b] Multi column
c] Single or Multi column
d] None of the above
Ans : C
91. What is Library in Forms 4.0 ?
a] Collection of External field
b] Collection of built_in packages
c] Collection of PL/SQl functions, procedures and packages
d] Collection of PL/SQL procedures & triggers
Ans : C
92. Can we use a RESTRICTED packaged procedure in WHEN_TEXT_ITEM trigger ?
a] Yes
b] No
Ans : B
93. Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
a] Yes
b] No
Ans : B
94. What type of file is used for porting Forms 4.5 applications to various
platforms ?
a] .FMB file
b] .FMX file
c] .FMT file
d] .EXE file
Ans : C
95. What built_in procedure is used to get IMAGES in Forms 4.5 ?
a] READ_IMAGE_FILE
b] GET_IMAGE_FILE
c] READ_FILE
d] GET_FILE
Ans A
96. When a form is invoked with CALL_FORM does Oracle forms issues
SAVEPOINT ?
a] Yes
b] No
Ans : A
97. Can we attach the same LOV to different fields in Design time ?
a] Yes
b] No
Ans : A
98. How do you pass values from one form to another form ?
a] LOV
b] Parameters
c] Local variables
d] None of the above
Ans : B
99. Can you copy the PROGRAM UNIT into an Object group ?
a] Yes
b] No
Ans : B
100. Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5 ?
a] Yes
b] No
Ans : A.