alice9313

摘要： 24、Examine these components: • 1. Execution plan for a non-embedded SQL statement • 2. Local, global, and package variables for a session • 3. Executi 阅读全文

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

摘要： 22、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 阅读全文

摘要： 21、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 阅读全文

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

摘要： 19、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 阅读全文

摘要： 18、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 阅读全文

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

摘要： 16、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 阅读全文

摘要： 14、Which command is used to display files that no longer conform to the backup retention policy? A) REPORT OBSOLETE B) SHOW DATAFILE BACKUP COPIES C) 阅读全文