NO.1 Examine these Data Pump commands to import objects to non-existent users hr1 and oe1.

S expdp system/manager Schemas =hr,oe directory =EXP_ DIR include = table

$ impdp system/manager Schemas = hr1,oe1 Directory = EXP_DIR Dumpfile = export.dat

Remap_schema =hr:hr1,oe :oe1

What would be achieved by running the above commands?

A. expdp will fail because no path has been defined for the dumpfile.

B. expdp will succeed but Impdp will fail because users do not exist.

C. impdp will create two users called hrl and oe1 and import all objects to the new schemas

D. impdp will create two users called hrl and oe1 and import tables owned by hr and oe schemas to

hr1 and oe1 schemas, respectively.

Answer: B

NO.2 Which statements are true regarding system-partitioned tables? (Choose all that apply.)

A. Only a single partitioning key column can be specified.

B. All DML statements must use partition-extended syntax.

C. The same physical attributes must be specified for each partition.

D. Unique local indexes cannot be created on a system-partitioned table.

E. Traditional partition pruning and partitionwise joins are not supported on these tables.

Answer: D,E

NO.3 You want to track and store all transactional changes to a table over its lifetime.

To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years.

After some time, the business requirement changed and you were asked to change the

retention from 5 years to 3 years.

To accomplish this, you issued the following command:

ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;

What is the implication of this command?

A. The command produces an error because the retention time cannot be reduced.

B. All historical data is retained but the subsequent flashback data archives are maintained for only

three years.

C. All historical data is purged and the new flashback data archives are maintained for three years.

D. All historical data older than three years is purged from the flashback archive FLA1.

Answer: D

NO.4 You create two resource plans, one for data warehouse loading jobs at night and the other for

application jobs at day time. You want the resource plans to activate automatically so that the

resource allocation is optimum as desired by the activity.

How would you achieve this?

A. Implement job classes

B. Implement Scheduler windows

C. Implement the mapping rule for the consumer groups

D. Set the SWITCH_TIME resource plan directive for both the resource plans

Answer: B

NO.5 You issued the following commands to configure settings in RMAN:

RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO Sbt;

RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;

RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;

RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Then you issued the following command to take the backup:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which statement is true about the execution of the above command?

A. The backup will terminate because the FORMAT clause was not configured for the channel

B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

C. It backs up the data files and archived log files to disk, making two copies of each data file and

archived logfile

D. It backs up the data files and archived log files to tape, making two copies of each data file and

archived logfile

Answer: D

NO.6 Identify two options that Oracle recommends while configuring the backup and recovery

environment for your recovery catalog. (Choose two.)

A. configuring control file autobackup to be ON

B. backing up data filed only and not the archived redo log files

C. running the recovery catalog database in NOARCHIVELOG mode.

D. setting the retention policy to a REDUNDANCY value greater than 1

E. backing up the recovery catalog to the same disk as that of the target database

Answer: A,D

NO.7 Which three tasks can be performed using a duplicate database? (Choose three.)

A. Testing the backup and recovery procedures

B. Testing the upgrade of an Oracle database to a new release

C. Testing the effect of an application changes on database performance

D. Continuously updating archive log files from the target database to support failover

Answer: A,B,C

NO.8 Which data dictionary view would you query to find the name of the default permanent

tablespace of the database?

A. DICTIONARY

B. DBA_TABLESPACES

C. DBA_DIRECTORIES

D. DBA_STORED_SETTINGS

E. DATABASE_PROPERTIES

F. DBA_TABLESPACE_GROUPS

Answer: E