Q 1 Which two are true regarding the Automatic Undo Management feature? (Choose two) A. PMON is responsible
for shrinking undo segments as needed. B. SMON is responsible for shrinking undo segments as needed. C. To use this feature, you must create undo
segments into an undo tablespace. D. Oracle9i automatically creates a fixed number of undo segments per undo tablespace. E. In a Real Application
Cluster environment, you must create one undo tablespace per opened instance. Ans: B & D Q 2. To increase the availability of an Advanced
Replication environment, you can add a new master to a replication group without quiescing the group. This is achieved__________ A. Only when the
new master site already has existing replication groups. B. By issuing a single command to create, populate, and activate the new master. C. When
the master definition site is not the same for all of the master groups. D. Without impacting end users who are executing data manipulation language
(DML) commands on the replicated tables. Ans: D Q 3. When querying the new V$SPPARAMETER view, the column ISSPECIFIED displays the value TRUE for a
number of a parameter. What does this means? A. The value for the parameters is TRUE B. The parameters are specified in the PFILE parameter file. C.
The parameters are specified in the SPFILE parameter file. D. Changes to the parameters are only in the currently running instance. Ans: C Q 4.
Which operation causes an index to be considered В“usedВ” while monitoring is turned on for that particular index? A. Only when the index is
specified in a hint. B. When data is fetched by an execution plan that uses that index. C. When a statement is executed and the execution plan
contains a reference to the index. D. When a statement is parsed and the resulting execution plan contains a reference to the index. Ans: D Q 5. You
need to version enable the MORTGAGE table containing customer mortgage trend information. Which syntax version enables the MORTGAGE table? A.
DBMS_LT.ENABLETABLE (В‘MORTGAGEВ’); B. DBMS_WM.ENABLE_TABLE (В‘MORTGAGEВ’); C. DBMS_LT.ENABLEVERSIONING (В‘MORTGAGEВ’); D. DBMS_WM.ENABLEVERSIONING
(В‘MORTGAGEВ’); Ans: D Q 6. Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution
times automatically, and to perform a switch to a low priority consumer group before they are initiated? (Choose three). A. SWITCH_TIME B.
SWITCH_GROUP C. MAX_SESS_POOL D. SWITCH_ESTIMATE Ans: A, B & D Q 7. The Oracle9i LogMiner needs a data dictionary copy to display the object names.
From which three locations can LogMiner retrieve the data dictionary information? (Choose three). A. separate supplemental log file B. Information
in the control file C. The current online data dictionary D. A Data Dictionary copy stored in the redo log file. E. A Data Dictionary copy stored in
an operating system flat file F. Redo information stored within the redo vectors of the DML operation Ans: C, D & E Q 8. In order to speed foreign
key creation, Orace9i will cache the first _________ primary key values only where there are multirow DML statements. A. 32 B. 128 C. 256 D. 512
Ans: C Q 9. Oracle Enterprise Manage (OEM) can generate database reports. Which statement about this feature is true? A. Generating reports requires
a repository. B. Report generation is scheduled in the job system. C. The report is placed in a table for suitable selects. D. The reports are in
HTML format for viewing in a browser. Ans: D Q.10 You start a multithreaded heterogeneous service agent with this initialization parameter.
MAX_DISPATCHERS = 10 What is the result? A. A maximum of ten dispatcher threads can be active in the agent. B. A maximum of ten sessions can be
connected to the agent simultaneously. C. A maximum of ten concurrent sessions can be connected to each dispatcher. D. A maximum of ten external
dispatcher processes can register with the listener thread. Ans: A

---