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 ( 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 Correctness of this Answer ( The correct answer should be 2  state control)

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

101. When is a .FMB file extension is created in Forms 4.5 ?
a. Generating form
b. Executing form
c. Save form
d. Run form
Ans : C

102. What is a Built_in subprogram ?
a. Library
b. Stored procedure & Function
c. Collection of Subprograms
d. None of the above
Ans : D

103. What is a RADIO GROUP ?
a. Mutually exclusive
b. Select more than one column
c. Above all TRUE
d. Above all FALSE
Ans : A

104. Identify the Odd one of the following statements?
a. Poplist
b. Tlist
c. List of values
d. Combo box
Ans : C

105. What is an ALERT?
a. Modeless window
b. Modal window
c. Both are TRUE
d. None of the above
Ans : B

106. Can an Alert message be changed at runtime?
a. Yes
b. No
Ans : A

107. Can we create an LOV without an RECORD GROUP?
a. Yes
b. No
Ans : B

108. How many no of columns can a RECORD GROUP have?
a. 10
b. 20
c. 50
d. None of the above
Ans: D

109. Oracle precompiler translates the EMBEDDED SQL statemens into
a. Oracle FORMS
b. Oracle REPORTS
c. Oracle LIBRARY
d. None of the above
Ans : D

110. Kind of COMMENT statements placed within SQL statements ?
a Asterisk(*) in column ?
b ANSI SQL style statements(…)
c C-Style comments (/*……*/)
d All the above
Ans : D

111. What is the appropriate destination type to send the output to a
printer ?
a. Screen
b. Previewer
c. Either of the above
d. None of the above
Ans : D

112. What is TERM ?
a. TERM is the terminal definition file that describes the terminal from which you are using R20RUN ( Reports run time )
b. TERM is the terminal definition file that describes the terminal from which you are using R20DES ( Reports designer )
c. There is no Parameter called TERM in Reports 2.0
d. None of the above
Ans : A

113. If the maximum records retrieved property of a query is set to 10, then a summary value will be calculated
a. Only for 10 records
b. For all the records retrieved
c. For all therecords in the referenced table
d. None of the above
Ans : A

114. With which function of a summary item in the COMPUTE AT optio required ?
a. Sum
b. Standard deviation
c. Variance
d. % of Total function
Ans : D

115. For a field in a repeating frame, can the source come from a column which does not exist in
the datagroup which forms the base of the frame ?
a. Yes
b. No
Ans : A

116. What are the different file extensions that are created by Oracle Reports ?
a . RDF file & .RPX file
b . RDX file & .RDF file
c . REP file & .RDF file
d None of the above
Ans : C

117. Is it possible to Disable the Parameter form while running the report?
a. Yes
b. No
Ans : A