多项选择题
Which three statements are true about the privileged connection options available in Oracle9i?()
A.The CONNECT INTERNAL is disallowed.
B.The Server Manager tool is no longer supplied.
C.The listener must be running to make a connection.
D.The use of remote password login file (orapw<sid>) is unchanged.
相关考题
-
单项选择题
Youcancontrolinstancerecoverperformancebysettingparameterstodefinetargetsfor()
A.The size of the redo buffer in SGA.
B.The instance that will perform recovery in Real Application Cluster database.
C.The number of blocks to be read during instance recovery, or the time needed to complete instance recovery.
D.The number of passes through the redo logs made by the recovery process to identify blocks needing recovery. -
单项选择题
TheEMPLOYEEStablehassixindexesandDMLoperationsareslow.WhichcommandbeginsmonitoringtheEMPLOYEE_IDX_FKindextodeterminewhetherithasbeenusedbyanexecutionplan?()
A.ALTER TABLE employees monitor index employee_idx_fk;
B.ALTER INDEX employee_idx_fk monitoring on;
C.ALTER TABLE employees monitor all indexes;
D.ALTER INDEX employee_idx_fk monitoring usage; -
多项选择题
Usingabitmapstructuretomanagedatabaseobjectspacehasseveralbenefitsoverusingfreeliststructures.Whichthreearebenefitsofmanagingspaceusingautomatic-segment-spacemanagedobjects?()
A.It readily responds to dynamic changes for concurrent access.
B.It improves performance and space utilization in a multiple-instance environment.
C.It requires fewer space related options then freelist managed structures.
D.It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.
