A. setting the STATISTICS_LEVEL parameter to TYPICAL
B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)
C. enabling Automated Maintenance Task using Oracle Enterprise Manager
D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
第1题:
YouhavejustrunthissyntaxtostartthelistenerfromtheListenerControlutility:LSNRCTL>STARTStarting/mstgelai/oracle/bin/tnslsnr:pleasewait…Systemparameterfileis/u01/oracle/network/admin/listener.oraLogmessageswrittento/u01/oracle/network/log/listener.logListeningon:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stc-sun01-server)(PORT=1521)))Connectingto…ThecommandcompletedsuccessfullyWhatisthenameoftheListeneryoustarted?()
A.TNSLSNR
B.LISTENER
C.LOCAL_LISTENER
D.DEFAULT_LSRN
第2题:
A.SYS
B.SYSTEM
C.PUBLIC
D.DEFAULT
第3题:
建立登录用户时若不指定DEFAULT_DATABASE选项,默认数据库为master数据库。()
第4题:
A.对于UNIX,在$ORACLE_HOME/dbs
B.对于UNIX,在$ORACLE_HOME/dbs/admin
C.对于Linux,在%ORACLE_HOME%\database
D.对于Windows,在%ORACLE_HOME%\dbs
E.对于Windows,在%ORACLE_HOME%\database\admin
第5题:
A.DB_FILES
B.DB_DATAFILES
C.DATABASE_FILES
D.LOG_FILES
第6题:
4、在Oracle中创建用户时,若未提及default tablespace关键字,则系统将哪个表空间分配给用户作为默认表空间?
A.users
B.system
C.sys
D.default