cnblogs_5359

摘要： 38、Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? A) Its findings are accessible only by using Oracle Enterprise Manager 阅读全文

摘要： 37、USER1 grants SELECT, INSERT, and UPDATE privileges on USER1. EMP to USER2. SYS executes this command: SQL> REVOKE UPDATE ON user1.emp FROM user1; W 阅读全文

摘要： 36、Which two are true about roles? A) A role can be granted a combination of system and object privileges and other roles. B) The CONNECT role Is gran 阅读全文

摘要： 35、Your database is using Automatic Memory Management. Which two SGA components must be managed manually? A) default buffer cache B) redo log buffer C 阅读全文

摘要： 34、Which two can be backed up by using RMAN when a database Is open in ARCHIVELOG mode, so that media recovery can be performed If required? A) contro 阅读全文

摘要： 33、Where Is backup metadata stored for use by Recovery Manager (RMAN)? A) In the control file B) In the SYSAUX tablespace C) in the SPFILE D) in the S 阅读全文

摘要： 32、 Examine these commands and their output: • SQL> SELECT * FROM emp; • ENO ENAME • • 100 Adam • 101 Alan • SQL> INSERT INTO emp VALUES(102,'Ben"); • 阅读全文

摘要： 31、Which two events always request the LGWR to write? A) when LGWR is notified by a server process that performs a Commit or ROLLBACK B) When PMON res 阅读全文

摘要： 30、Which is true when a database instance is shut down? A. Only transactional and normal modes wait for all uncommitted transactions to commit or roll 阅读全文

摘要： 29、In one of your databases: * The database default tablespace is EXAMPLE. * Deferred_segment_creation is false. Examine these commands: SQL> create u 阅读全文