CertsTopics Logo

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Oracle Database 12c 1z0-067 Dumps PDF

Page: 10 / 10
Total 263 questions
Get 1z0-067 Full Access Download 1z0-067 PDF

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP Questions and Answers

Question 37

Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host. What must you do to make the database operational in OUSERVER1?

Options:

A.

Restore the data files by using the NOCATALOG option and use the SET NEWNAME command to change the location

B.

Restore the control file from the backup by using the CATALOG options, restore the data files by using the SET NEWNAME command, and recover the data files

C.

Restore the data files from the backup by using the recovery catalog, use the SWITCH command to change the location, and recover the data files

D.

Restore the control file from the backup by using the NOCATALOG option, and then restore and recover the data files

Question 38

You set the following parameters in the parameter file and restart the database instance:

MEMORY_MAX_TARGET=0

MEMORY__TARGET=500M

PGA_AGGREGATE_TARGET=90M

SGA_TARGET=270M

Which two statements are true?

Options:

A.

The memory_max_target parameter is automatically set to 500 MB.

B.

The pga_aggregate_target and sga_target parameters are automatically set to zero.

C.

The value of the memory_max_target parameter remains zero for the database instance.

D.

The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.

E.

The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

Question 39

Which two statements are true regarding an Automatic Storage Management (ASM) instance?

(Choose two.)

Options:

A.

An ASM instance mounts an ASM control file

B.

An ASM instance uses the ASMB process for rebalancing of disks within a disk group

C.

Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly

D.

An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Page: 10 / 10
Total 263 questions
Get 1z0-067 Full Access Download 1z0-067 PDF