Oracle Database Question Bank    ...10


 (Pages   1   2   3   4   5   6   7   8   9   10)


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
Answer: C

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

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

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

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

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

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

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

109. Oracle precompiler translates the EMBEDDED SQL statements into
a] Oracle FORMS
b] Oracle REPORTS
c] Oracle LIBRARY
d] None of the above
Answer: 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
Answer: 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
Answer: 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
Answer: 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 the records in the referenced table
d] None of the above
Answer: 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
Answer: 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
Answer: 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
Answer: C

117. Is it possible to Disable the Parameter form while running the report?
a] Yes
b] No
Answer: 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
Answer: 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
Answer: 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
Answer: 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
Answer: B

122. SYSTEM TABLESPACE can be made off-line
a] Yes
b] No
Answer: 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
Answer: A

124. SMON process is used to write into LOG files
a] TRUE
b] FALSE
Answer: 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
Answer: A

126. SNAPSHOTS cannot be refreshed automatically
a] TRUE
b] FALSE
Answer: B

127. The User can set Archive file name formats
a] TRUE
b] FALSE
Answer: A

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

129. NOARCHIEVELOG parameter is used to enable the database in Archive
mode
a] TRUE
b] FALSE
Answer: B

130. Constraints cannot be exported through Export command?
a] TRUE
b] FALSE
Answer: B

131. It is very difficult to grant and manage common privileges needed by different groups of database users using roles
a] TRUE
b] FALSE
Answer: B

132. The status of the Rollback segment can be viewed through
a] DBA_SEGMENTS
b] DBA_ROLES
c] DBA_FREE_SPACES
d] DBA_ROLLBACK_SEG
Answer: D

133. Explicitly we can assign transaction to a rollback segment
a] TRUE
B] FALSE
Answer: A

134. What file is read by ODBC to load drivers ?
a] ODBC.INI
b] ODBC.DLL
c] ODBCDRV.INI
d] None of the above
Answer: A