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. They also have UNLIMITED QUOTA on the default tablespace USERS.4. They have no other privileges.Examine these commands:SQL> c...【阅读全文】
26、In which state can you back up a database in ARCHIVELOGMODE using RMAN?A. NOMOUNT, MOUNT, AND OPENB. NOMOUNT AND MOUNT ONLYC. OPEN ONLYD. MOUNT AND OPEN ONLYE. OPEN RESTRICTED ONLYCorrect Answer: D【阅读全文】
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> ALTER SYSTEM SET db_recovery_file_dest_size=2G;What is the outcome?A) It changes DB_RECOVERY_FILE_DEST_SIZE to 5G.B) It chan...【阅读全文】
23、Which two are true about data dictionary and dynamic performance views (v$ views)?A) All database users have access to ALL_* views.B) Data dictionary view output is subject to read consistency.C) The defining queries for Oracle supplied dynamic performance views are stored In the...【阅读全文】
22、You are planning a software installation for both Oracle Database 11g Release 1 and Release 2.You plan to have at lease one database for each release managed by Grid Infrastructure for a Standalone Server.Which three are true in this scenario?A) Oracle 11g Release 1 databases mus...【阅读全文】
21、Which two are true about roles?A) A role can be password-protected.B) A role can be granted to another role.C) Only one default role can be granted to a user.D) A role can be granted only multiple system privileges not multiple object privileges.E) A role can be created on...【阅读全文】
20、 Which is true about the SYSTEM and SYSAUX tablespaces?A) The SYSAUX tablespace can be made read-only but the SYSTEM tablespace cannot.B) Both tablespaces can be used for temporary storage if no temporary tablespace is defined.C) Only the SYSTEM tablespace contains data dictionar...【阅读全文】
18、You want to Install Oracle 11g database software and create a database on ASM Immediately after the Install.Your plan is to install both Oracle database and Grid Infrastructure.Which two are true in this scenario?A) Grid Infrastructure must be installed first.B) Both products ...【阅读全文】
17、Which two statements are true about tablespaces?A) A database can contain multiple undo tablespaces.B) A database can contain only a single temporary tablespace.C) A database instance stores undo data In the SYSTEM tablespace If no undo tablespace exists.D) A database instance...【阅读全文】
16、Your database Is configured In archivelog mode.The USERS01 tablespace Is currently online.You are required to take the tablespace offline.Which clause or clauses ensure that no media recovery is requiredwhen the tablespace Is brought back online?A) either the NORMAL or the ...【阅读全文】
14、Which command is used to display files that no longer conform to the backup retention policy?A) REPORT OBSOLETEB) SHOW DATAFILE BACKUP COPIESC) CROSSCHECK BACKUPD) LIST EXPIRED BACKUPAnswer:A【阅读全文】
11、Which three are true about UNDO data?A) It is used to roll back failed transactions.B) It is used to rewind a database by using FLASHBACK DATABASE.C) It is used to recover dropped tables by using FLASHBACK TABLE … TO BEFORE DROP.D) It is used to enable ROLLBACK statements to ...【阅读全文】
10、Which two are true about consistent database backups?A) They can only be taken when a RECOVERY CATALOG is used.B) They can only be taken if the database Is in ARCHIVELOG mode.C) They can only be taken If shutdown NORMAL, TRANSACTIONAL, or IMMEDIATE shutdown has been performed and ...【阅读全文】
6、You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI).You select the "Install and Configure Grid Infrastructure for a Standalone Server" option.Which task is performed by OUI as part of this installation?A) creation and configuration of Enterp...【阅读全文】