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

129. NOARCHIEVELOG parameter is used to enable the database in Archieve mode
a. TRUE
b. FALSE
Ans : B

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

131. It is very difficult to grant and manage common priveleges needed by
different groups of database users using roles
a. TRUE
b. FALSE
Ans : 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
Ans : D

133. Explicitly we can assign transaction to a rollback segment
a. TRUE
b. FALSE
Ans : 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
Ans : A