3、Which structure can span multiple data files?A) a permanent tablespaceB) a bigfile tablespaceC) a temporary tablespaceD) a segmentE) an extentAnswer:ACD【阅读全文】
2、Which two are true about Optimizer Statistics?? A) They do not persist across Instance restarts.? B) They are automatically updated when DDL statements execute.? C) They are gathered by the Manageability Monitor (MMON) background process.? D) They can be gathered by executing th...【阅读全文】
查看数据库版本SELECT * FROM V$VERSION;查看数据库语言环境SELECT USERENV('LANGUAGE') FROM DUAL;查看ORACLE实例状态SELECT INSTANCE_NAME,HOST_NAME,STARTUP_TIME,STATUS,DATABASE_STATUS FROM V$INSTANCE;查看ORACLE监听状态lsnrctl status 查看数据库归档模式...【阅读全文】