Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-1094-23

Oracle 1z0-1094-23 Exam Practice Questions (P. 3)

  • Full Access (54 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #11
For a source database to be successfully migrated, you must view and apply the prerequisites.
Which two prerequisites must be addressed before the source database can be migrated using Oracle Zero Downtime Migration (ZDM)? (Choose two.)
  1. A
    The database must be running an Archive Log mode.
  2. B
    The database must have Transparent Data Encryption (TDE) enabled.
  3. C
    The database must be stored in an Automatic Storage Management Cluster File System (ACFS).
  4. D
    The source database server must allow incoming connections from the ZDM service host on to Port 22.
  5. E
    The database must have a configured TDE wallet if the version is Oracle Database 11g Release 2 or 12c Release 1.

Correct Answer:
AD

Question #12
Projector components in a mapping hides attributes from preceding components. All succeeding components can only use the attributes from projector component.
Which three components below are NOT a projector component in Oracle Data Integrator (ODI)? (Choose three.)
  1. A
    Aggregate
  2. B
    Sort
  3. C
    Filter
  4. D
    Distinct
  5. E
    Join

Correct Answer:
BCE

Question #13
You are trying to load a denormalized target table C and the source attributes come from table A and Table B in Oracle Data Integrator (ODI).
Which statement is true?
  1. A
    You can join table A and table B, as required by the data model and load target C in a single mapping.
  2. B
    A mapping can have only one source and one target. You need to create 2 mappings to load target C.
  3. C
    You are required to do outer join between table A and table B in order to load target C.
  4. D
    You are required to do inner join between table A and table B in order to load target C.

Correct Answer:
A

Question #14
You are migrating a non TDE encrypted on-premises Database to an OCI Database Service Instance using RMAN.
You set up the DB Cloud Backup Module, but when executing the RMAN command to create your Cloud Backup you see the following error:
RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 08/15/2014 11:10:57
ORA-19914: unable to encrypt backup
ORA-28361: master key not yet set
What are the two causes of this error? (Choose two.)
  1. A
    The SET ENCRYPTION ON command was executed.
  2. B
    The SET ENCRYPTION IDENTIFIED BY <password> only command was executed.
  3. C
    The SET DECRYPTION IDENTIFIED BY <password> RMAN command was not executed.
  4. D
    The OCI Object Storage encryption at rest key is missing.
  5. E
    The SET ENCRYPTION IDENTIFIED BY <password> command was executed.

Correct Answer:
AB

Question #15
You took a backup to DISK on the on-premises database and copied it to an Object Storage bucket to be used to instantiate a new Database Cloud Service.
Which RMAN operation is required before the backup can be restored?
  1. A
    uncompress backup
  2. B
    export backuppiece
  3. C
    decrypt backup
  4. D
    encrypt backup

Correct Answer:
C

Previous Questions Next Questions

All Pages