首页 > 代码库 > OCP读书笔记(22) - 题库(ExamB)

OCP读书笔记(22) - 题库(ExamB)

101.Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

A. The user has dropped an important table that needs to be recovered.

B. The database files are corrupted when the database is open.

C. You are not able to start up the database instance because the required database files are missing.

D. The archived log files are missing for which backup is not available.

 

104.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 will be true in this scenario? (Choose

all that apply.)

A. The disk is immediately dropped from the disk group.

B. The ASM tracks the extents that are modified during the outa

C. The ASM migrates the extents from the unavailable disk to the remaining disks.

D. The disk automatically goes offline.

 

105.Which statements are true regarding table compression? (Choose all that apply.)

A. It saves disk space and reduces memory usage.

B. It saves disk space but has no effect on memory usage.

C. It incurs extra CPU overhead during DML as well as direct loading operations.

D. It incurs extra CPU overhead during DML but not direct loading operations.

E. It requires uncompress operation during I/O.

 

108.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 achieve this? (Choose all that apply.)

A. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.

B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.

C. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.

D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.

 

109.Which statement describes the effect of table redefinition on the triggers attached to the table?

A. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table.

B. All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.

C. All triggers on the table remain valid.

D. Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table.

 

116.Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)

A. It can be used to back up all data on ASM disks.

B. It can be used to recover the damaged ASM disk group along with the data.

C. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.

D. It can be used to re-create the ASM disk group with its attributes.

 

118.Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?

A. SQL statements that are part of the AWR baseline only

B. SQL statements based on the AWR top SQL identification

C. SQL statements that are part of the available SQL Tuning Set (STS) only

D. SQL statements that are available in the cursor cache and executed by a user other than SYS

 

120.You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)

A. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.

B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.

C. The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.

D. ASM compatibility controls which features for the ASM will be enabled.

 

121.Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)

A. It creates jobs without considering the priorities associated with them.

B. It translates tasks into jobs for execution by the scheduler.

C. It determines the list of jobs that must be created for each maintenance window.

D. It is spawned by the MMON background process at the start of the maintenance window.

E. It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.

 

122.Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g? (Choose all that apply.)

A. Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository (ADR).

B. The problem key is the same as the incident number.

C. The database sends an incident alert to the Oracle Enterprise Manager Database Home page.

D. Every problem has a problem key, which is a text string that describes the problem.

E. The database makes an entry into the alert log file when problems and incidents occur.

 

130.Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)

A. Undo retention guarantee for the database must be configured.

B. Supplemental log must be enabled for the primary key.

C. Supplemental log must be enabled.

D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.

 

132.You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?

A. parallel image copy backup

B. backup with MAXPIECESIZE configured for the channel

C. parallel backup with MAXPIECESIZE configured for the channe

D. intrafile parallel backup

 

133.You performed the RMAN database backup with the KEEP option. Which two statements are true

regarding this backup? (Choose two.)

A. The backup contains data files, the server parameter file, and the control file even if the control file

autobackup is disabled.

B. The KEEP option overrides the configured retention policy.

C. The backup contains only data files and archived redo log files.

D. The KEEP option is an attribute of an individual backup piece.

 

134.You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:

RMAN>BACKUP

SECTION SIZE 300M

TABLESPACE users;

What configuration should be effected to accomplish faster and optimized backups by using the above

command?

A. The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1.

B. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.

C. The SBT channel must be configured, with the parallelism setting for the SBT device set to 3.

D. The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB.

 

135.The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table?

A. The materialized view should have a complete refresh performed after the online table redefinition is completed.

B. The materialized view should have a fast refresh performed after the online table redefinition is completed.

C. The materialized view, materialized log, and the index should be dropped and re-created after the online table redefinition is complete.

D. The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.

 

136.You issued the following command to mount the DATA disk group in restricted mode:

ALTER DISKGROUP data MOUNT RESTRICT;

What is the implication of this command?

A. The client RDBMS instance can access the file as a read-only file.

B. A new disk cannot be added to a disk group.

C. A disk in a disk group can be taken offline.

D. The client RDBMS instance cannot access the files in the disk group.

 

137.Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture on the production database to record the peak workload. You set up the test RAC database and want to replay the recorded workload on the test machine. Note the following steps that you may require to replay the database workload:

1) Preprocess the captured workload.

2) Restart the database in RESTRICTED mode.

3) Set up the Replay Clients.

4) Restore the test database to the point when the capture started.

5) Remap connections.

Arrange the steps required in the correct sequence to accomplish this task on the test machine.

A. 1, 4, 5, 3 (2 is not required.)

B. 1, 4, 3, 5 (2 is not required.)

C. 1, 2, 4, 5 (3 is not required.)

D. 2, 1, 5, 3, 4

E. 1, 2, 4, 5, 3

 

142.In which situations will the ASM metadata backup help you recover the ASM disk in a disk group?

(Choose all that apply.)

A. when one or more file directory paths are accidentally deleted from an ASM disk group

B. when one of the disks in a disk group is accidentaly unplugged

C. when the data file on an ASM disk group gets corrupted

D. when one or more disks in an ASM disk group are lost

 

143.Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)

A. Database must be running in archivelog mode.

B. Automatic undo management must be enabled.

C. Undo retention guarantee must be enabled.

D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

 

144.In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the

initialization parameter file. You issued the following command:

SQL>SELECT /*+ RESULT_CACHE */ sale_category, sum(sale_amt)

FROM sales

GROUP BY sale_category;

Where would the result of this query be stored?

A. database buffer cache

B. shared pool

C. PGA

D. large pool

 

147.You installed Oracle Database 11g afresh. Which statements are true regarding the default audit

settings in this database? (Choose all that apply.)

A. The audit trail is stored in an operating system file.

B. Auditing is disabled for all privileges.

C. The audit trail is stored in the database.

D. Auditing is enabled for all privileges.

E. Auditing is enabled for certain privileges related to database security.

 

148.Which dependent object will get invalidated even if it is not affected by the table edefinition?

A. packages

B. triggers

C. synonyms

D. views

 

151.Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)

A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if

MEMORY_MAX_TARGET is set to a value greater than zero

B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set

C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.

D. MEMORY_TARGET is static and cannot be modified without shutting down the instance

 

152.You are performing incomplete recovery using RMAN. You execute the following RUN block:

RUN

{

SET UNTIL SCN 1107600;

RESTORE DATABASE;

RECOVER DATABASE;

}

Which statement is true about the result?

A.RMAN restores all datafiles from the most recent backup available since the failure and applies the redo logs necessary to recover the database to SCN 1107600

B.RMAN restores all datafiles needed to restore the database through SCN 1107599 and applies the redo logs necessary to recover the database through SCN 1107599.

C.RMAN restores all datafiles and control files from the most recent backup

D.The RUN block fails because you did not specify an UNTIL clause in your RECOVER DATABASE command

 

153.You are managing an ASM instance. You previously issued the following statements:

ALTER DISKGROUP dg1 DROP DISK disk2;

ALTER DISKGROUP dg1 DROP DISK disk3;

ALTER DISKGROUP dg1 DROP DISK disk5;

You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you

issue?

A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;

B. ALTER DISKGROUP dg1 UNDROP;

C. ALTER DISKGROUP dg1 UNDROP DISKS;

D. You cannot cancel the pending disk drops.

 

157.The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be

performed?

A. The Oracle database will perform block checking for the index blocks only

B. The Oracle database will not perform block checking for any of the data blocks

C. The Oracle database will perform block checking for the default permanent tablespace only

D. The Oracle database will perform block checking for the data blocks in all user tablespaces

E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

 

161.You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups.

Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups. Identify two options for completing this task. (Choose two.)

A. Reregistering the target database in recovery catalog

B. Transporting the new tablespaces to the recovery catalog database

C. Syncronizing the recovery catalog with the target database control file

D. Performing a fresh backup of the target database to include the new data files in the catalog database

 

163.View the Exhibit to observe the error.

 

You receive this error regularly and have to shut down the database instance to overcome the error. What

can the solution be to reduce the chance of this error in future, when implemented?

A. setting the PRE_PAGE_SGA parameter to TRUE

B. locking the SGA in memory

C. increasing the value of SGA_MAX_SIZE

D. automatic memory management

 

165.View the Exhibit exhibit1.

 

 

In the CUSTOMERS_OBE table, when the value of CUST_STATE_PROVINCE is "CA", the value of

COUNTRY_ID is "US."

View the Exhibit exhibit2 to examine the commands and query plans. The optimizer can sense 8 rows instead of 29 rows, which is the actual number of rows in the table. What can you do to make the optimizer detect the actual selectivity?

A. Change the STALE_PERCENT value for the CUSTOMERS_OBE table.

B. Set the STATISTICS_LEVEL parameter to TYPICAL.

C. Create extended statistics for the CUST_STATE_PROVINCE and CUSTOMERS_OBE columns.

D. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE.

 

166.Exhibit:

 

View the Exhibit and examine the output.

You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:

ALTER TABLE exchange_rate FLASHBACK ARCHIVE;

What is the outcome of this command?

A. The Flashback Archive is created on the same tablespace where the tables are stored.

B. The Flashback Archive is created on the SYSAUX tablespace.

C. The command generates an error because no Flashback Archive name is specified and there is no default Flashback Archive.

D. The table uses the default Flashback Archive.

 

170.ASM supports all but which of the following file types? (Choose all that apply.)

A. Database files

B. Spfiles

C. Redo-log files

D. Archived log files

E. RMAN backup sets

F. Password files

G. init.ora files

 

173.Which of the following is not a configurable attribute for an individual disk group?

A. AU_SIZE

B. COMPATIBLE.RDBMS

C. COMPATIBLE.ASM

D. DISK_REPAIR_TIME

E. DG_DROP_TIME

 

175.You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, as

shown here:

Put the tablespaces in backup mode.

Back up the datafiles for all tablespaces.

Take the tablespaces out of backup mode.

Back up all archived redo logs.

Your colleague asks for you to comment on his plan. Which response would be correct?

A. The plan will work as is.

B. The plan needs to be modified to allow for an archive-log switch after step 3.

C. The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.

D. The plan needs to be adjusted to shut down the database after step 1 and to restart the database after

step 2.

E. The plan cannot work as presented.

Answer: B

答案解析:

个人觉得这道题有问题,在非归档模式下,不能将表空间启动到备份模式,不能在切换日志时将日志归档等,错误如下,应该选E?

sys@TEST1107> startup mount

ORACLE instance started.

 

Total System Global Area 1269366784 bytes

Fixed Size                  2227984 bytes

Variable Size             872415472 bytes

Database Buffers          385875968 bytes

Redo Buffers                8847360 bytes

Database mounted.

sys@TEST1107> alter database noarchivelog;

 

Database altered.

 

sys@TEST1107> alter database open;

 

Database altered.

 

sys@TEST1107> alter tablespace users begin backup;

alter tablespace users begin backup

*

ERROR at line 1:

ORA-01123: cannot start online backup; media recovery not enabled

 

182.Which of the following files cannot be backed up by RMAN? (Choose all that apply.)

A. Database datafiles

B. Control files

C. Online redo logs

D. Database pfiles

E. Archived redo logs

 

185.A shoot-out has erupted between your MS development teams using .NET and your Linux

development teams using Java. Knowing that your database is in danger, which command would you use

to back up your NOARCHIVELOG mode database using RMAN with compression?

A. backup database all

B. backup compressed database

C. backup as compressed backupset database;

D. backup as compressed backup database plus archivelog all;

E. backup as compressed backupset database plus compress archivelog all;

 

186.What is the purpose of the RMAN recovery catalog? (Choose all that apply.)

A. Make backups faster

B. Store RMAN metadata

C. Store RMAN scripts

D. Provide the ability to do centralized backup reporting.

E. Make recovery faster

 

189.What RMAN command must you use before you can back up a database using the recovery catalog?

A. create catalog

B. install database

C. catalog database

D. merge Catalog with database

E. register database

 

190.You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive

the following error message:

SQL> startup ORA-01078: failure in processing system parameters LRM-00109:

could not open parameter file ,,

C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORA Using RMAN,

how would you respond to this error?

A. Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.

B. Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.

C. Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.

D. Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.

E. Issue the restore spfile from autobackup command from the RMAN prompt.

 

191.While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 p.m. on September 6, 2008. Which of the following would be the correct commands to use to restore the database to a point in time before the orruption?

A. restore database until time ‘06-SEP-2008 06:30:00‘); recover database until time ‘06-SEP-2008 06:30:00‘); alter database open;

B. restore database until time ‘06-SEP-2008 06:30:00‘); recover database until time ‘06-SEP-2008 06:30:00‘); alter database open resetlogs;

C. restore database until time ‘06-SEP-2008 18:29:55‘); recover database until time ‘06-SEP-2008 18:29:55‘); alter database open resetlogs;

D. restore database until time ‘06-SEP-2008 18:29:55‘); alter database open resetlogs;

E. restore database until time ‘06-SEP-2008 18:29:55‘); recover database; alter database open resetlogs;

 

192.What is the purpose of the until change option of the restore command?

A. It allows you to select the SCN that you want to restore to.

B. It allows you to select the log sequence number you want to restore to.

C. It allows you to select the timestamp you want to restore to.

D. It allows you to manually stop the restore at any time as online redo logs are applied.

E. None of the above.

 

193.What is the purpose of the recover command? (Choose all that apply.)

A. Recover database datafiles from physical disk backup sets.

B. Recover required incremental backups from physical disk backup sets.

C. Recover required archived redo logs from physical disk backup sets.

D. Apply incremental backups to recover the database.

E. Apply archived redo logs to recover the database.

 

196.What is the purpose of the catalog command?

A. To review RMAN control file and recovery catalog metadata and ensure that its correct

B. To delete RMAN backup-related metadata from the recovery catalog

C. To create metadata in the control file and the recovery catalog related to backup set pieces

D. To create a report that lists database backups

E. To rebuild the recovery catalog

 

198.What are the two different types of database duplication? (Choose two.)

A. Active

B. Passive

C. Online

D. Backup-based

E. Failure driven