Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Free 1z0-497 Questions Attempt

Page: 4 / 6
Total 150 questions

Oracle Database 12c Essentials Questions and Answers

Question 13

You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?

Options:

A.

You should not install the Oracle Database software into an existing Oracle home from a different release.

B.

A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.

C.

Oracle recommends that you back up the root. sh script after you complete the installation.

D.

Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.

E.

You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.

Question 14

John is a CDB administrator, and Mike and Tim are PDB administrators of their respective databases- John takes a complete CDB backup by using RMAN>Backup Database. Mike and Tim may need point-in-time recovery of their PDBs. Which statement is true?

Options:

A.

Recovery of individual PDBs is not possible, because John did not back up by using RMAN>Backup Pluggable database pdb1 pdb2. However, complete CDB recovery is still possible.

B.

Mike and Tim need to individually take backups of their respective PDBs, because CDB-level backup does not include PDB data dictionary objects.

C.

Mike and Tim do not need to worry, because recovery of individual PDBs is possible.

D.

Recovery of individual PDBs is not possible at all.

Question 15

Which three tasks can you perform in Database Express?

Options:

A.

View performance and status information about the database instance.

B.

Start up the database.

C.

Shut down the database.

D.

Create database structures.

E.

Manage users and security.

Question 16

A standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited forthis scenario?

Options:

A.

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword

B.

ALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements

C.

ALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword

D.

D) ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER Statements

Page: 4 / 6
Total 150 questions