What are the only contents of the dump file a 1 non

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: a set of tablespaces. What are the only contents of the dump file? A. 1. Non-partitioned tables in the tablespace set 2. Partitioned tables that have all their partitions in the tablespace set 3. Indexes on all the exported tables Actualtests.com - The Power of Knowing 1Z0-030 B. 1. Non-partitioned tables in the tablespace set 2. Partitioned tables that have at least one partition in the tablespace set 3. Indexes on all the exported tables C. 1. Non-partitioned tables in the tablespace set 2. Partitioned tables that have all their partitions in the tablespace set 3. Indexes on the exported tables if the indexes are in the tablespace set or have at least one partition in the tablespace set D. 1. Non-partitioned tables in the tablespace set 2. Partitioned tables that have at least one partition in the tablespace set 3. Tables (including all partitions, if they exist) that have an index in the tablespace set 4. Indexes on all the exported tables Answer: B Explanation: If you use the TABLESPACES option of the Export command to export the contents of a set of tablespaces, content of dump file will be: non-partitioned tables in the tablespace set, partitioned tables that have at least one partition in the tablespace set, indexes on all the exported tables. Incorrect Answers A: It's not required that partitioned tables have to have ALL their partitions in the tablespace set them to be exported with this option. C: It's not required that partitioned tables have to have ALL their partitions in the tablespace set them to be exported with this option. Also ALL indexes on all the exported tables will be exported. D: Tables that have an index in the tablespace set will not be exported. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 49-51 Chapter 2: Availability Enhancements QUESTION 32: What are three characteristics of the Data Guard Broker? (Choose three.) A. It runs as a process called DMON B. It can be controlled through the Data Guard Manager GUI and command-line interface C. It is started by setting the DRS_START parameter to TRUE in your initialization file D. It uses a configuration file stored on the primary database server and, optionally, on one of your standby database servers Answer: A, B, C Explanation: The Data Guard Broker has next characteristics: it runs as a process called DMON, it can Actualtests.com - The Power of Knowing 1Z0-030 be controlled through the Data Guard Manager GUI and command-line interface and it is started by setting the DRS_START parameter to TRUE in your initialization file. DRS_START enables Oracle to determine whether or not the DRMON (Disaster Recovery Monitor) process should be started. DRMON is a non-fatal Oracle background process and exists as long as the instance exists. Incorrect Answers D: It does not use a configuration file stored on the primary database server and, optionally, on one of your standby database servers OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 51-74 Chapter 2: Availability Enhancements Oracle 9i New Features...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online