paper 20

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 option
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

118.What are the SQL clauses supported in the link property sheet ?
a] WHERE & START WITH
b] WHERE & HAVING
c} START WITH & HAVING
d] WHERE, START WITH & HAVING

Ans : D

119. What are the types of Calculated columns available ?
a] Summary, Place holder & Procedure column
b] Summary, Procedure & Formula columns
c] Procedure, Formula & Place holder columns
d] Summary, Formula & Place holder columns

Ans.: D

120. If two groups are not linked in the data model editor, what is the
hierarchy between them?
a] There is no hierarchy between unlinked groups
b] The group that is right ranks higher than the group that is to the
left
c] The group that is above or leftmost ranks higher than the group
that is to right or below
it
d] None of the above

Ans : C

121. Sequence of events takes place while starting a Database is
a] Database opened, File mounted, Instance started
b] Instance started, Database mounted & Database opened
c] Database opened, Instance started & file mounted
d] Files mounted, Instance started & Database opened

Ans : B

122. SYSTEM TABLESPACE can be made off-line
a] Yes
b] No

Ans : B

123. ENQUEUE_RESOURCES parameter information is derived from
a] PROCESS or DDL_LOCKS & DML_LOCKS
b] LOG BUFFER
c] DB_BLOCK_SIZE
d] DB_BLOCK_BUFFERS

Ans : A

124. SMON process is used to write into LOG files
a] TRUE
b] FALSE

Ans : B

125. EXP command is used
a] To take Backup of the Oracle Database
b] To import data from the exported dump file
c] To create Rollback segments
d] None of the above

Ans : A

126. SNAPSHOTS cannot be refreshed automatically
a] TRUE
b] FALSE
Ans : B
127. The User can set Archive file name formats
a] TRUE
b] FALSE

Ans : A

128. The following parameters are optional in init.ora parameter file
DB_BLOCK_SIZE,
PROCESS
a} TRUE
b] FALSE

Ans : B