Oracle 1Z0-083 Oracle Database Administration II Exam Exam Practice Test Questions

• Question 1

  Choose three. Which three are true about upgrading an application in an application container?

  • An application root clone gets created automatically.
  • The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED.
  • After an application upgrade, the application container's PDBs remain synchronized with the existing application root.
  • The upgrade must be performed when connected to CDB$ROOT.
  • An application name and version number must be specified to upgrade the application.
  • After an application upgrade, the application container's PDBs are automatically synchronized with the application root clone.

  Show Answer Answer: A,E,F Next

• Question 2

  Choose two. Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup?

  • Backups can be taken only if a fast recovery area is configured.
  • Backups can be written only to disk.
  • Backups can be taken only for data files.
  • Binary compression cannot be applied to the backup.
  • Backups can be written only if checksums are stored for each block.
  • Backups can be written only to media.

  Show Answer Answer: B,D Next

• Question 3

  choose three Which three are true about unified auditing in full mode?

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

  Show Answer Answer: A,D,E Next

• Question 4

  Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)

  • The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
  • Oracle DBCA templates can store only logical structure and not database files.
  • New templates can only be created by modifying an existing user-created template.
  • The Data Warehouse template is most suitable when transaction response time is the key criterion.
  • Oracle DBCA templates can be used to create new databases and duplicate existing databases.

  Show Answer Answer: A,E Next

• Question 5

  You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?

  • Database Replay
  • Automatic Database Diagnostic Monitor (ADDM) Compare Period report
  • Active Session History (ASH) report
  • SQL Performance Analyzer

  Show Answer Answer: B Next