Oracle OCP 1Z0-050（16-20题）解析

QUESTION 16:

While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced.

Which two statements describe the consequences? (Choose two.)

A. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.

B. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.

C. The plan baselines can be evolved over time to produce better performance.

D. The newly generated plans are directly placed into the SQL plan baseline without being verified.

正确答案：B、C

 

QUESTION 17:

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements.

What would you do with these SQL statements?

A. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

B. Capture the plans from the previous version using STS and then load them into the stored outline.

C. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.

D. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).

正确答案：D

 

QUESTION 18:

Evaluate the following statements:

CREATE TABLE purchase_orders

(po_id NUMBER(4),

po_date TIMESTAMP,

supplier_id NUMBER(6),

po_total NUMBER(8,2),

CONSTRAINT order_pk PRIMARY KEY(po_id))

PARTITION BY RANGE(po_date)

(PARTITION Q1 VALUES LESS THAN (TO_DATE(?1-apr-2007?d-mon-yyyy?),

PARTITION Q2 VALUES LESS THAN (TO_DATE(?1-jul-2007?d-mon-yyyy?),

PARTITION Q3 VALUES LESS THAN (TO_DATE(?1-oct -2007?d-mon-yyyy?),

PARTITION Q4 VALUES LESS THAN (TO_DATE(?1-jan-2008?d-mon-yyyy?));

CREATE TABLE purchase_order_items

(po_id NUMBER(4) NOT NULL,

product_id NUMBER(6) NOT NULL,

unit_price NUMBER(8,2),

quantity NUMBER(8),

CONSTRAINT po_items_fk

FOREIGN KEY (po_id) REFERENCES purchase_orders(po_id))

PARTITION BY REFERENCE(po_items_fk);

What are the two consequences of the above statements? (Choose two.)

A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.

B. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.

C. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.

D. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

E. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.

正确答案：C、E

 

QUESTION 19:

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 thatapply.)

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.

正确答案：B、C、D

 

QUESTION 20:

Examine the following RMAN command:

BACKUP DATABASE

TAG TESTDB

KEEP UNTIL 'SYSDATE+1'

RESTORE POINT TESTDB06;

Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)

A. Archived redo logs are backed up only if the database is open during the backup.

B. The backup is deleted after one day, regardless of the default retention policy settings.

C. The backup becomes obsolete after one day, regardless of the default retention policy settings.

D. Only data files and the control file are backed up.

正确答案：A、C

【解析】

参考文档

https://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta007.htm#RCMRF90048

 

keep Option

Overrides any configured retention policy for this backup so that the backup is not considered obsolete, as shown in Example 2-26. You can use the KEEP syntax to generate archival database backups that satisfy business or legal requirements. The KEEP setting is an attribute of the backup set (not individual backup piece) or image copy. Note: You cannot use KEEP with BACKUP BACKUPSET. With the KEEP syntax, you can keep the backups so that they are considered obsolete after a specified time (KEEP UNTIL), or make them never obsolete (KEEP FOREVER). As shown in Example 2-27, you must be connected to a recovery catalog when you specify KEEP FOREVER. Note: You can use CHANGE to alter the status of a backup generated with KEEP. See Also: keepOption for more information about backups made with the KEEP option

 

Creating a Consistent Database Backup for Archival Purposes

This example uses a keepOption to create an archival backup set that cannot be considered obsolete for one year. The example backs up the database, archives the redo in the current online logs to ensure that this new backup is consistent, and backs up only those archived redo log files needed to restore the data file backup to a consistent state.

The BACKUP command also creates a restore point to match the SCN at which this backup is consistent. The FORMAT parameter must be capable of creating multiple backup pieces in multiple backup sets.

 

Example 2-26 Creating a Consistent Database Backup for Archival Purposes

 

This example uses a keepOption to create an archival backup set that cannot be considered obsolete for one year. The example backs up the database, archives the redo in the current online logs to ensure that this new backup is consistent, and backs up only those archived redo log files needed to restore the data file backup to a consistent state.

The BACKUP command also creates a restore point to match the SCN at which this backup is consistent. The FORMAT parameter must be capable of creating multiple backup pieces in multiple backup sets.

BACKUP DATABASE

  FORMAT '/disk1/archival_backups/db_%U.bck'

  TAG quarterly

  KEEP UNTIL TIME 'SYSDATE + 365'

  RESTORE POINT Q1FY06;