cnblogs_5359

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

摘要： 28、Which two are true about external tables? A. They support the ORACLE_DATAPUMP access driver. B. They have extents. C. They support all DML operatio 阅读全文

摘要： 27、Examine these facts about a database: 1. USERS is the database default tablespace. 2. USER1, USER2, AND USER3 have the CREATE SESSION privilege. 3. 阅读全文

摘要： 26、In which state can you back up a database in ARCHIVELOGMODE using RMAN? A. NOMOUNT, MOUNT, AND OPEN B. NOMOUNT AND MOUNT ONLY C. OPEN ONLY D. MOUNT 阅读全文

摘要： 25、Which is true about logical and physical database structures? (Choose the best answer) A. An undo tablespace has a temp file instead of a data file 阅读全文

摘要： 24、 YOUR DB_RECOVERY_FILE_DEST_SIZE Is 8G. Currently, 5G of the space Is used of which 4G consists of obsolete backups. You execute this command: SQL> 阅读全文