cnblogs_5359

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

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

摘要： USER1 grants SELECT and UPDATE privileges on USER1.EMP to USER2。 SYS executes this command： SQL> REVOKE SELECT ON user1.emp FROM user1; What will be t 阅读全文

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

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

摘要： Your database is open in ARCHIVELOG mode. LOG_ARCHIVE_DEST is set to Fast Recovery Area (FRA) and It is 100% full when a log switch takes place. No al 阅读全文

摘要： Which two are true about the Fast Recovery Area (FRA)? A)It should be larger than the database. B)Only consistent backups can be stored in the FRA. C) 阅读全文

摘要： Which two statements are true about the Automatic Diagnostic Repository (ADR) ? A)It only exists if DIAGNOSTIC_DEST is configured in the SPFILE. B)It 阅读全文

摘要： Which is true about the Automatic Diagnostic Repository (ADR) ? A) It is used only if the DIAGNOSTIC_DEST parameter is manually configured. B) It only 阅读全文

摘要： Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? A)It improves database performance by automatically implementing Oracle ‘ 阅读全文