Oracle 1Z0-1094-22 Online Practice Questions and Exam Preparation

Oracle 1Z0-1094-22 Online Questions & Answers

• Question 11:

  Which migration method gives you the least downtime?

  A. Data Guard
  B. RMAN point-in-time recovery
  C. Transportable Tablespaces
  D. Data pump
  A. Data Guard

• Question 12:

  You are looking at migrating a large data centre to the Oracle Cloud while trying to consolidate many Oracle Databases at the same time. Which Oracle Data Management Service helps you achieve this?

  A. oracle ExadataCloud Service
  B. oracle Data Safe
  C. oracle MySQL Cloud Service
  D. oracle Autonomous Database
  A. oracle ExadataCloud Service

• Question 13:

  Which TWO object types should be excluded from an Autonomous Transaction Processing database? (Choose all correct answers)

  A. SCHEMA
  B. DB -LINK
  C. constraint
  D. cluster
  B. DB -LINK
  D. cluster

• Question 14:

  You encounter error ORA-00245 while performing ZeroDowntime Migration of an Oracle RAC database. What might be the reason for this?

  A. The RAC instances are running in Archivelog mode.
  B. Port 1521 is open.
  C. TDE Wallet is configured.
  D. SNAPSHOT CONTROL is not pointing to a shared location on all OracleRAC instances.
  D. SNAPSHOT CONTROL is not pointing to a shared location on all OracleRAC instances.

• Question 15:

  Which technologies can you use for Zero Downtime physical migration? (Choose two.) (Choose all correct answers)

  A. Data Guard
  B. OracleGoldenGate
  C. Data Pump
  D. RMAN
  A. Data Guard
  D. RMAN

• Question 16:

  Which Autonomous Data Warehouse (ADW) package is leveraged by the Business Intelligence Cloud Connector (BICC) Loading Knowledge Modules, when using Oracle Data Integrator (ODI)?

  A. Dbms_cloud_admin
  B. Dbms_cloud
  C. sa_audit_admin
  D. Dbms_cloud_macadm
  A. Dbms_cloud_admin

• Question 17:

  Which are TWObenefits of Extract-Load-Transform (ELT) over traditional Extract- Transform-Load (ETL) architectures? (Choose all correct answers)

  A. ELT architecture reduces the amount of network traffic over traditional ETL tools, which use a dedicated server.
  B. ELT architecture can easily become a bottleneck by placing excessive loads on the target servers.
  C. ELT architecture does not require dedicated hardware and leverages native data management engines, such as Big Data and RDBMs.
  D. Traditional ETL tools use a dedicated server, which provides better performance as it can be sized to any workload.
  A. ELT architecture reduces the amount of network traffic over traditional ETL tools, which use a dedicated server.
  C. ELT architecture does not require dedicated hardware and leverages native data management engines, such as Big Data and RDBMs.

• Question 18:

  Which knowledge modules are supported by Oracle Data Integrator (ODI)?

  A. IDB DB2
  B. All of the options
  C. Spark
  D. Hive
  E. ADW
  B. All of the options

• Question 19:

  What can you use to quickly load data into a cloud database by dragging and dropping a file in a web browser?

  A. Remote cloning a pluggable database (PDB)
  B. RMAN Transportable Tablespace
  C. Data Pump Transportable Tablespaces
  D. DataLoad tab of the SQL worksheet in Database Actions
  D. DataLoad tab of the SQL worksheet in Database Actions

• Question 20:

  When migrating an Oracle database, you must be aware of source and target requirements. Which TWO statements are true about using Oracle Zero DowntimeMigration (ZDM)? (Choose all correct answers)

  A. Source Oracle Single Instance Databases can be migrated to Oracle RAC Databases with Oracle ZDM-.
  B. Oracle ZDM supports cross-edition migration, allowing Standard Edition Databases to be migrated toEnterprise Edition Databases.
  C. When migrating with Oracle ZDM and the target database is at a higher patch level than the source database, the data patch utility runs on the target database as a post-migration task.
  D. Source Oracle Real Application Clusters (RAC) Databases can be migrated to Single Instance Databases with Oracle ZDM.
  A. Source Oracle Single Instance Databases can be migrated to Oracle RAC Databases with Oracle ZDM-.
  D. Source Oracle Real Application Clusters (RAC) Databases can be migrated to Single Instance Databases with Oracle ZDM.