单项选择题
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）
A.Use the Database Resource Manager.
B.Set the limits in the profiles used by users.
C.Modify the SESSIONS initialization parameter.
D.Set the warning threshold for the Current Logons Count metric.
相关考题
-
多项选择题
WhichtwostatementsregardingtheLOGGINGclauseoftheCREATETABLESPACE...statementarecorrect？（）
A.This clause is not valid for a temporary or undo tablespace.
B.If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.
C.The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.
D.The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels. -
单项选择题
WhichtwooperationscanbeflashedbackusingtheFlashbacktechnology？（）
A.DROP USER SMITH；
B.DROP TABLE EMPLOYEES；
C.DROP TABLESPACE USERS；
D.ALTER TABLE SALES_REP DROP PARTITION P1；
E.ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID； -
单项选择题
Yourdatabaseishavingtwocontrolfiles，threeredologfilegroupswithtwomembersineachgroup.Failureofwhichfilewouldcauseaninstancetoshutdown？（）
A.any control file
B.any archive log file
C.one of the redo log members
D.loss of the initialization parameter file
E.any data file belonging to the default permanent tablespac
