Oracle Oracle Certifications 1Z0-074 Questions & Answers

• Question 71:

  Identify two types of files that are generated by the Pre-Upgrade Information tool as part of the database upgrade prerequisite checks? (Choose two.)

  A. expdp scripts to export database objects belonging to the SYS schema

  B. a log file containing a list of pre-upgrade patches to be applied

  C. RMAN database backup scripts

  D. a log file with tool recommendations and requirements

  E. pre- and post-upgrade fixup scripts

  Correct Answer: DE

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/using-preupgradeinformation-tool-for-oracle-database.html#GUID-C0219AF1- AD43-4097-B358-E53E48958647

• Question 72:

  Which two statements are true about clean restore points in a regular PDB? (Choose two.)

  A. They require a clone instance to be created when used in a PDB flashback operation

  B. They can be created for a PDB when connected to either the PDB or to the root

  C. They require backups to be restored when used in a PDB flashback operation

  D. They are created as guaranteed restore points

  E. They can be created only if shared undo is enabled

  F. They can be created only for a PDB in the mount state

  Correct Answer: EF

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/using-flasbackdatabase-restore-points.html

• Question 73:

  Your CDB has a PDB, EMP_PDB.

  You successfully execute these commands as the SYSTEM USER in CDB$ROOT:

  

  Which two statements are true about C##USR1? (Choose two.)

  A. It can connect to EMP_PDB and view the data only in tables created by common users.

  B. It can connect to EMP_PDB but cannot view the data in any table in it.

  C. It can connect only to the root.

  D. It is a common user.

  E. It is a local user.

  Correct Answer: AE

• Question 74:

  Which two statements are true about application containers? (Choose two.)

  A. A regular PDB can be plugged in to an application container provided it is an Oracle Database 12c Release 2 (12.2) PDB.

  B. An application root can be unplugged from a CDB and plugged in to another CDB.

  C. An application PDB can belong to multiple application containers.

  D. User-created common objects are accessible from the CDB root.

  E. The application root stores user-created common objects and Oracle-supplied common objects.

  F. Multiple application roots can be created in one container database.

  Correct Answer: DE

  Reference: https://blogs.oracle.com/oraclemagazine/multitenant-database-management

• Question 75:

  While performing a cross-platform PDB transport in an Oracle Database 12c Release 2 database, by using XTTS from a Linux (x86-64) server to a Solaris (x86-64) server, this command is executed to back up the files in a compatible format:

  

  What will be the outcome?

  A. It creates the /tmp/pdb_orcl.xml file, which contains the metadata and data of the source database.

  B. The backup fails because the UNPLUG operation for cross-endian platforms is not supported.

  C. It successfully takes a backup but the UNPLUG operation of PDB_ORCL fails.

  D. It successfully completes.

  E. It creates a backupset of the source database in the /home/oracle/backup directory

  Correct Answer: E