Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Oracle Mig > 1 > Flashcards

1 Flashcards

Oracle

1
Q

Which Three backup mediums are supported when migrating a database with oracle zero downtime migration?

A
  • Oracle Zero data loss recovery appliance
  • Object Storage
  • NFS Storage
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which FOUR Oracle Database Cloud Services are supported as a target database using Oracle Zero Downtime Migration ?

A
  • Exadata cloud service
  • Oracle database cloud service
  • Exadata cloud @customer
  • Autonomous database
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which three Oracle technologies are leveraged by Oracle Zero Downtime Migration Physical Online Workflow?

A
  • Recovery Manager
  • Oracle Data Guard
  • SQL*Net
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Your data warehouse load consists of extracting data from order header and order line items table. What kind of journalizing type should you use in Oracle Data Integration (ODI) to make sure referential integrity is maintained in the target?

A

• Consistent

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

You have executed the mappings with Change Data Capture (CDC) on the source data store and you are now going through the code in the operator log for debugging. Which two tables or view do you need to inspect in the database to see whether the CDC process is writing changed data or not in Oracle Data Integration (ODI )?

A
  • JV$D

* JV$

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which four Oracle database version are supported for source databases when migrating with Oracle Zero Downtime Migration?

A

• 11gR2 and above

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which three Oracle technologies are leveraged by Oracle Zero Downtime Migration Physical Online Workflow?

A
  • Recovery Manager
  • Oracle Data Guard
  • SQL*Net
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

You have decided to use Oracle Data Integrator (ODI) on Marketplace to load data from an On-premises Oracle Database to Autonomous Database on Oracle Cloud Infrastructure (OCI). Which TWO methods can be used to connect to the on premises Oracle Database from OCI?

A
  • Fast Connect

* VPN Connect

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Your source tables are in an On-premises Oracle Database. You are creating a data server in Oracle Data Integrator (ODI) topology. Which THREE configuration items are needed to successfully test an On-premises Oracle Database connection ?

A
  • Network name or IP address
  • Oracle SID
  • Listener port
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Which TWO methods should you use when migrating a target database with different endianness than the source database?

A
  • RMAN CONVERT

* RMAN Transportable Tablespaces with Data Pump

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

• Data Load tab of the SQL worksheet in Database actions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

You have a requirement to join data from an Oracle database table and a flat file and load into target DB2 table, using Oracle Data Integrator (ODI). Which statement is correct about this?
.

A

• It is possible to mix heterogeneous source connection type and load into any supported target connection type in a single mapping

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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?

A

• You can join table A and table B, as required by the data model and load target C in a single mapping

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

You are migrating an On-premises Linux 11.2.0.4 Database to a Database Cloud Service by using the Cross•Platform Transportable Tablespace Backup Set. Which statement is true?

A

• The database could service target version must be 11.2.0.4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which TWO methods support a difference in endian format when migrating a database from onpremises to Oracle Cloud?

A
  • RMAN cross•Platform Transportable PDB

* Datapump Conventional export/import

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which THREE methods can be used to migrate an On-premises Oracle Database to Oracle Autonomous Database?

A
  • Enterprise manager
  • Datapump export and import
  • Oracle zero downtime migration
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Which TWO target database environments provide both high availability (HA) and disaster recovery (DR) options in the cloud?

A
  • Exadata Cloud service

* Autonomous database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

When selecting a migration method for moving your database to the cloud, what would you NOT take into consideration?

A

• Schema name

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Which TWO methods are supported by Oracle Zero Downtime Migration (ZDM) for migrating On-premises databases to Autonomous Database?

A
  • Logical online or offline migration using database link

* Logical online or offline migration using OCI Object storage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Which TWO products/utilities does Oracle Zero Downtime Migration use as part of its migration workflows to Autonomous Database?

A
  • Golden gate

* Data pump

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

For a source database to be successfully migrated, you must view and apply the prerequisites. Which TWO prerequisites must pass before the source database can be migrated using Oracle Zero Downtime Migration (ZDM)

A
  • Port 22 on source database server must allow incoming connections from ZDM
  • Archivelog must be enabled
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Which are THREE target database prerequisites for database cloud migration with Oracle Zero Downtime Migration?

A
  • The TDE wallet must be open
  • The database db_name must be same as source
  • TDE must be enabled
23
Q

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

A
  • Source Oracle single instance can be migrated to Oracle RAC
  • Oracle RAC can be migrated to single instance database
24
Q

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

25
Q

Which THREE Fusion SaaS components from the Oracle Data Integrator (ODI) Loading Knowledge Modules can be used to extract data out of Fusion SaaS applications and load it into Autonomous Data Warehouse (ADW)?

A
  • REST API
  • Enterprise Scheduler Service SOAP API
  • BI Cloud connector
26
Q

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 Exadata cloud service

27
Q

You have an On-premises non•TDE•encrypted Linux 19c container database (CDB) that is already being regularly backed up to Oracle Cloud Infrastructure (OCI) Object Storage via the Database Backup Cloud Service. You plan on using Recovery Manager (RMAN) to migrate it to Database Cloud Service. What is the valid strategy to migrate?

A

• Create New DB instance, delete the existing database, manually install the DB cloud backup service, perform a complete RMAN restore as encryption enabled

28
Q

You are migrating a non TDE encrypted On-premises Database to an OCT Database Service Instance ising 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: AANA RMAN•03009:
failure of backup command on ORA_SBT_TAPE 1 channel at:
08/18/2014 11: ORA~19914: unable to encrypt backup ORA~29361
master key not yet set.
What are the TWO causes of this error?

A
  • Set encryption is on

* set encryption identified by command was executed

29
Q

You are planning the migration of a 19c Oracle Database from Amazon Web Services Relational Database Service (AWS RDS) using RMAN backups. What is the correct sequence of operations?

A

• Using the AWS tooling, take an RMAN backup of the RDS DB local file storage and move it AWS s3 bucket, copy contents of S3 bucket to OCI object storage, restore the backup from OCI bucket to OCI DB service instance

30
Q

Which are TWO benefits of Extract-Load-Transform (E-LT) over traditional Extract Transform•Load (ETL) architectures?

A
  • ELT doesn’t require dedicated hardware and leverages native data management engines, such as Big data and RDBMS
  • ELT architecture reduces the amount of network traffic over the other ETL tools, which use a dedicated server.
31
Q

If unplug and plug was decided to be used as the tool for the migration to Oracle Cloud Infrastructure (OCD), which two constraints are part of this migration to process for using unplug and plug?

A
  • Target and Source have same Endianness.

* Source and target needs to be container database

32
Q

You are using Oracle Data Integrator (ODI). Which three topology elements are required to extract data out of Fusion SaaS applications and load it into Autonomous Data Warehouse?

A
  • Object storage
  • BI cloud connector
  • File
33
Q

Which two migration methodologies can you use for migrating On-premises databases to Autonomous Database with Oracle Zero Downtime Migration (ZDM)?

A
  • Logical online

* Logical offline

34
Q

Which Oracle Database Cloud Service takes care of all routine database tasks ensuring higher performance, reliability, security, and operational efficiency?

A

• Oracle autonomous database

35
Q

Which type of checks is NOT supported by Oracle Data Integrator (ODI)?

A

• Business rules

36
Q

Which supported platform can the source Oracle Database be running on when migrating with Oracle Zero Downtime Migration?

A

• Linux x86-64

37
Q

Which TWO options are valid when using the unplug/plug a PDB method to migrate?

A
  • Non-CDB databases can be consolidated and migrated

* Source database versions are 12c and higher

38
Q

Which TWO statements are true about online pluggable database (PDB) relocation?

A
  • Online PDB relocation can achieve a zero-downtime upgrade

* PDB relocation with no version change can be performed with near•zero downtime

39
Q

When integrating data from multiple sources into a Data Warehouse schema, you want to check a length constraint that you have imposed on one of the target columns before the rows arrive in the target table. All the rows that do not pass this quality check will have to be isolated in error tables.
For this, you have chosen an Integration Knowledge Module (IKM) that supports flow control.
You have also chosen the value true for this parameter to enable this check.
At compile time, you see that Oracle Data Integrator (ODI) throws an error and the execution cannot start. What is the reason?

A

• The check knowledge module was not set in physical design

40
Q

Which TWO statements are true about cross-endian migration using Transportable Tablespaces?

A
  • Tablespaces must be converted by either RMAN CONVERT or DBMS_FILE_TRANSFER
  • Tablespaces may not be encrypted
41
Q

What TWO ways does Data Pump use to move data to the cloud

A
  • Import dump file from OCI object storage

* Import over database link

42
Q

Which FOUR key parameters should you include in your export command when migrating an Oracle Database to the Oracle Cloud?

A
  • Exclude=statistics
  • Metrics=yes
  • LOGTIME=all
  • FLASHBACK_TIME=SYSTIMESTAMP
43
Q

Which process does Oracle Data Integrator Enterprise Edition use to process and transform data for disparate relational database management systems or Big Data Engines?

A

Elt

44
Q

Which view is used to measure the replication latency between source and target when using the automatic heartbeat table feature, in GoldenGate?

A

• GG LAG

45
Q

Which FOUR Oracle Data Pump impdp parameters should you use when migrating to Autonomous Database?

A
  • Remap_tablespace=DATA
  • Transform=CONSTRAINT_USE_DEFAULT_INDEX:Y
  • Transform=segment_attributes:N
  • Transform=DWCS_CVT_IOTS:Y
46
Q

Which TWO object types should be excluded from an Autonomous Transaction Processing database?

A
  • Cluster

* DB-LINK

47
Q

You have a security requirement within your organization to separate your resources. There is a team that supports each resource and they are not allowed access to the other resources. Which security control with Oracle Cloud Infrastructure meets this requirement?

A

• Compartments and Policies

48
Q

When building out your private subnet, you realize you need a host within your network in order to get access to the rest of your Oracle Cloud Infrastructure instances. Which type of host should you set up to get around this constraint?

A

• Baston Host

49
Q

In Oracle Zero Downtime Migration, the migrate database command provides several options to ensure a successful Oracle source and target data migration. Which FOUR are valid parameters to use with migrate database?

A
  • tdemasterkey
  • sourcedb
  • sourcesid
  • tgrroot
50
Q

Which TWO statements are true about the Oracle Zero Downtime command line?

A
  • Upon execution of zdmcli, the only way to track the status of migration is querying the ZDM service using the provided job ID
  • When the source is single instance deployed on non•grid, the sourceid option should be used to specify the database name.
51
Q

Which TWO statements are true about the Oracle Zero Downtime command line?

A

• Root user or ssh key-based access to source and target.

52
Q

Oracle Zero Downtime Migration (ZDM) uses MySQL internally, configuring on a default port number. What will ZDM proceed to, if a port number is not specified and the default is not available?

A

• Increase the default port number by one and retry five times.

53
Q

Which migration method gives you the least down time?

A

• Data guard

54
Q

Planning a database migration to Oracle Cloud Infrastructure (OCI) requires understanding the source

A
  • On-premise host operating system version

* Character set of database

Oracle Mig (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions