Oracle 1Z0-083 Online Practice Questions and Exam Preparation

Oracle 1Z0-083 Online Questions & Answers

• Question 181:

  You plan to perform cross-platform PDB transport using XTTS. Which two are true? (Choose two.)

  A. A backup of the PDB must exist, taken using the BACKUP command with the TO PLATFORM clause.
  B. The source PDB must be in MOUNT state.
  C. The source PDB must not be an application root.
  D. The source PDB can be in MOUNT or OPEN state.
  E. The source and target platforms must have the same endianness.
  F. Automatic conversion of endianness occurs.
  B. The source PDB must be in MOUNT state.
  E. The source and target platforms must have the same endianness.

  ---

  Explanation/Reference:

  Reference: https://blog.enmotech.com/2018/01/10/oracle-12cr2-cross-platform-pdb-transport-using-xtts/

• Question 182:

  Which two are true about instance recovery? (Choose two.)

  A. It is not possible if an archived log is missing.
  B. It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.
  C. Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.
  D. It is performed by the Recovery Writer (RVWR) background process.
  E. Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing the log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.
  F. It is performed automatically while the database remains in MOUNT state. Then the database is opened.
  C. Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.
  F. It is performed automatically while the database remains in MOUNT state. Then the database is opened.

  ---

  Explanation/Reference:

• Question 183:

  Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

  A. Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a PDB.
  B. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.
  C. A new PDB is automatically created when importing a non-CDB into a CDB.
  D. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
  E. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.
  F. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.
  B. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.
  D. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.

  ---

  Explanation/Reference:

  E,F ->Incorrect -> tablespace export/import can be conventional or transportable A,C -> Nothing is created automatically you must create what you need.

• Question 184:

  Which three are true about backing up the control file? (Choose three).

  A. It cannot be backed up manually as a binary copy.
  B. It gets backed up automatically by RMAN as a trace file containing SQL statements for control file recreation when a database backup occurs.
  C. It can be backed up manually as a binary copy.
  D. It can get backed up automatically as a binary copy.
  E. It gets backed up automatically by RMAN when the BACKUP SPFILE command is used.
  F. It can be backed up manually as a trace file containing SQL statements for control file recreation.
  C. It can be backed up manually as a binary copy.
  D. It can get backed up automatically as a binary copy.
  F. It can be backed up manually as a trace file containing SQL statements for control file recreation.

• Question 185:

  Which three are true about unified auditing in full mode? (Choose three)

  A. The unified audit trail is written to a read-only table.
  B. The unified audit trail is written to a read-only external file.
  C. Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.
  D. Audit records are created for SYS.
  E. Audit records are created for non-sys users.
  A. The unified audit trail is written to a read-only table.
  D. Audit records are created for SYS.
  E. Audit records are created for non-sys users.

• Question 186:

  Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)? (Choose three.)

  A. the data dictionary in CDB$ROOT
  B. temporary tablespaces
  C. the Process Monitor Process (PMON)
  D. SYSAUX tablespaces
  E. the log writer process (LGWR)
  F. undo tablespaces
  A. the data dictionary in CDB$ROOT
  C. the Process Monitor Process (PMON)
  E. the log writer process (LGWR)

• Question 187:

  Which three statements are true about Flashback Database?

  A. Flashback logs are written sequentially, and are archived.
  B. Flashback Database uses a restored control file to recover a database.
  C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
  D. Flashback Database can recover a database to the state that it was in before a reset logs operation.
  E. Flashback Database can recover a data file that was dropped during the span of time of the flashback.
  F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
  C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
  D. Flashback Database can recover a database to the state that it was in before a reset logs operation.
  F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

• Question 188:

  Which two are true about common objects? (Choose two.)

  A. They can be created only in CDB$ROOT.
  B. They can be only metadata-linked in an application container.
  C. They can exist in user-defined schemas only in application containers.
  D. They can exist in CDB$ROOT and an application root.
  E. They can be extended data-linked in CDB$ROOT.
  F. They can be created only in an application root.
  D. They can exist in CDB$ROOT and an application root.
  F. They can be created only in an application root.

  ---

  Explanation/Reference:

  A common object is defined in either the CDB root or an application root, and can be referenced using metadata links or object links. A local object is every object that is not a common object. Database-supplied common objects are defined in CDB$ROOT and cannot be changed. Oracle Database does not support creation of common objects in CDB$ROOT.

  You can create most schema objects-such as tables, views, PL/SQL and Java program units, sequences, and so on—as common objects in an application root. If the object exists in an application root, then it is called an application common object. ACCORDING THE LECTURE, CORRECT ANSWERS ARE: DF

  D: they can exist in CDB$ROOT and application root.

  F: they can be created only in application root.

  Reference: https://blog.toadworld.com/2017/08/01/oracle-multi-tenant-application-containers-part-iii-sharing-of-data-in-application-common-objects

• Question 189:

  HR_ROOT is an application container with the HR_APP application installed.

  No application PDBs and no application seed have yet been created in HR_ROOT.

  An application PDB, PDB1, must be created so that the HR_APP application's common objects are accessible to it.

  Which two methods can be used? (Choose two.)

  A. Create an application seed, and install HR_APP in it.
  B. Create the PDB1 application PDB and install HR_APP in it.
  C. Create an application seed, synchronize it with HR_ROOT, and then create the PDB1 application PDB.
  D. Create the PBD1 application PDB and synchronize it with HR_ROOT.
  E. Create the PBD1 application PDB and synchronize it with PDB$SEED.
  C. Create an application seed, synchronize it with HR_ROOT, and then create the PDB1 application PDB.
  D. Create the PBD1 application PDB and synchronize it with HR_ROOT.

  ---

  Explanation/Reference:

• Question 190:

  Which three are true about an application container? (Choose three.)

  A. It can contain a single application.
  B. It can contain multiple applications.
  C. It must have an application seed PDB.
  D. It must have an application root PDB.
  E. Two application containers can share an application seed PDB.
  F. An application PDB can belong to multiple application containers.
  A. It can contain a single application.
  B. It can contain multiple applications.
  D. It must have an application root PDB.

  ---

  Explanation/Reference:

  Reference: https://blog.toadworld.com/2017/06/26/oracle-multi-tenant-application-containers-part-i