Complete 1z0-062 Oracle Materials

Oracle Database 12c: Installation and Administration Questions and Answers

Question 53

Your database is configured in ARCHIVELOG mode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured.

Loss of which three database files can lead to an incomplete recovery? (Choose three.)

inactive online redo log file group

a data file belonging to the default temporary tablespace

a data file belonging to the SYSAUX tablespace

server parameter ﬁle (SPFILE)

active online redo log ﬁle group

all the control flies

Question 54

A database uses Automatic Storage Management (ASM) as database storage, which has a diskgroup, DATA1, which is created as follows:

What happens when the FAILGRP1 failure group is corrupted?

Mirroring of allocation units occurs within the FAILGRP2 failure group.

Transactions that are using the diskgroup fail.

ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the FAILGRP2 failure group.

Data in the FAILGRP1 failure group is moved to the FAILGRP2 failure group and rebalancing is started.

Question 55

Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup.

In which three scenarios do you need media recovery? (Choose three.)

loss of all the copies of the control file

loss of all the inactive online redo log group members

loss of a data file that belongs to the active undo tablespace

loss of data files that belong to the SYSTEM tablespace

logical corruption of data that is caused by a wrong transaction

abnormal termination of the database instance

Question 56

Which statement is true about the Database as a Service (DBaaS) instances and Database instances in Oracle Public Cloud

An Oracle database instance can support only one DBaaS instance.

A DBaaS instance can support only one Oracle database instance.

An Oracle database instance can support multiple DBaaS instances.

A DBaaS instance can support multiple Oracle database instances.

A DBaaS instance runs in a pluggable database (PDB), which is contained in a multi-tenant container database (CDB).