ITPub博客

177-Q59: You inadvertently delete some RMAN backups with operation system command. You perform additional backups from RMAN again but you need to remove the deleted backups from the recovery catalog. What commands can you use to clean up the catalog?(Choose all that apply.)A. DELETE EXPIRED...

177-Q54: Your CUSTOMER_ORDER and ORDERJTEMS table is updated daily with both phone orders and Internet orders. During and ad-hoc maintenance operation, an operations specialist accidentally deletes serval items from an order placed last week. Which flashback feature will minimize the loss of rece...

177-Q50: When you perform a whole database backup wuth the command BACKUP DATABASE PLUS ARCHIVELOG, which database objects are included in the backup?(Choose the best answer.)A. All datafiles and archived log files. The control file is included if you add the CONTROLFILE keyword, and the SPFI...

177-Q26: Identify the correct relationships between resource consumer group, resource plan directives, and resource plans.(Choose all that apply.)A. Only one resource plan can be active at a time.B. A user can b a member of only one resource consumer group.C. One resource plan can hav...

177-Q7: You want to ensure the recoverability of the recovery catalog itself. Which of the following steps should you implement to maximize recoverability? (Choose all that apply.)A. Configure the database for ARCHIVELOG mode.B. Use BACKUP DATABASE PLUS ARCHIVELOG when you back up the rec...

177-Q6: Your flash recovery area becomes full when you are running and RMAN backup (and has not yet reached the value specified by DB_RECOVERY_FILE_DEST). It is the destination for archived redo log files and backups. What will happen to the database? (Choose the best answer)A. If you have th...

177-Q161: You want the ability to recover to any time within the last seven days and therefore you configured the recovery window retention policy using the command:RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;After configuring the recovery window, you performed the datab...

117-Q118: You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create the missing disk group by using the ASMCMD md_restore command. Which of these methods would you use to a...

177-Q117: Which three are the valid statements in relation to SQL plan baselines?(Choose three.)A. The plans generated for every SQL statement are stored in the SQL plan baseline by default.B. The plans can be manually loaded to the SQL plan baseline.C. The plan baselines are stored t...

177-Q115: You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements with be true in this scena...

177-Q112: Which of the following parameters is used to display an entire range of supported languages, as well as all other globalization options?A. V$NLS_LANGUAGESB. NLS_LANGC. NLS_DATABASE_PARAMETERSD. V$NLS_VALID_VALUESE. NLS_INSTANCE_PARAMETERSAnswer: D下列哪一个参...

177-Q111: Which of the following is not a valid setting for LOGGING_LEVEL job Class parameter?A. DBMS_SCHEDULAR.LOGGING_FULLB. DBMS_SCHEDULAR.LOGGING_ONC. DBMS_SCHEDULAR.LOGGING_OFFD. DBMS_SCHEDULAR.LOGGING_RUNSAnswer: B

177-Q109: Which of the following database modes is valid while configuring a database to enable Flashback Database?A. MOUNTB. ARCHIVELOGC. NOMOUNTD. NOARCHIVELOGAnswer: B配置数据库启用闪回数据库，下列哪个数据库模式是有效的？数据库必须运行在归档模式下，在MOUNT状态下，才能...

177-Q105: Which of the following clauses is used when RMAN performs an incomplete database recovery prior to the RECOVER command?A. UNTIL CHANGEB. SET UNTIL TIMEC. SET UNTIL CANCELD. UNTIL CANCELAnswer: BRMAN执行不完全数据库恢复，在RECOVER命令之前，使用下列哪个子句？A...

177-Q101: You work as a Database Administrator for Blue-Well Inc. The company uses an Oracle database. The database contains a resource consumer group named QUERY_USERS. You want to specify the maximum number of active sessions allowed in the QUERY_USERS resource consumer group as twenty. Which o...

177-Q95: Which of the following Dynamic Performance views contain information relevant to SQL Tuning? Each correct answer represents a part of the solution.(Choose all that apply.)A. V$SQLSTATSB. V$SQLAREAC. V$SQL_BIND_DATAD. V$SQLAnswer: A B C D下面的动态性能视图包含SQL调...

177-Q94: Which of the following statements about a recovery catalog are true? Each correct answer represents a complete solution.(Choose two.)A. A recovery catalog should not be created in the target database.B. The information in the recovery catalog is obtained from the target database'...

177-Q93: You work as a Database Administrator for Bell Ceramics Inc. The company uses Oracle database. You createa window (a scheduler object) to change the active resource plan based on defined schedules. There are many parameters, such as WINDOWS_NAME, RESOURCE_PLAN, etc. which can be used whil...

177-Q92: Which of the following statements about conventional tablespaces (non-locally managed tablespaces) are true? Each correct answer represents a part of the solution.(Choose two)A. Conventional tablespaces use data dictionary tables for storage space management.B. Conventional table...

177-Q87: You are creating an incident package to send to Oracle support as follow:What kind of packaging are you using?A. Metalink packagingB. Custom packagingC. Quick packagingD. Detailed packagingAnswer: C