OCI Professional Exam 2024/2025 Exam
Questions and Correct Answers | New
Update
1. A manufacturing company is planning to migrate their on-premises
database to OCI and has hired you for the migration. Customer has
provided following information regarding their existing on-premises
database:
Database version, host OS and version, database character set, storage
for data staging, acceptable length of system outage.
What additional information do you need from customer in order to
recommend a suitable migration method? Choose 2.
On-premises host OS and version
Elapsed time since database was last patched
Number of active connections
Data types used in the on-premises database
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
1
PRIVACY STATEMENT. ALL RIGHTS RESERVED
,Top 5 longest running queries - 🧠ANSWER ✔✔On-premises host OS and
version
Data types used in the on-premises database
1. An insurance company is storing critical financial data in the OCI block
volume. This volume is currently encrypted using Oracle managed keys.
Due to regulatory compliance, the customer wants to encrypt the data
using the keys that they can control and not the keys which are controlled
by Oracle.
What of the following series of tasks are required to encrypt the block
volume using customer managed keys?
Create a vault, create a master encryption key in the vault, assign this
master encryption key to the block volume
Create a master encryption key, create a data encryption key, decrypt the
block volume using existing Oracle managed keys, encrypt the block
volume using the data encryption key
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
2
PRIVACY STATEMENT. ALL RIGHTS RESERVED
,Create a vault, import your master encryption key into the vault, generate
data encryption key, assign data encryption key to the block volume
Create a master encryption key, create a new version of the encryption
key, decry - 🧠ANSWER ✔✔Create a vault, create a master encryption key
in the vault, assign this master encryption key to the block volume
1. A cloud consultant is working on implementation project on OCI. As part
of the compliance requirements, the objects placed in object storage should
be automatically archived first and then deleted. He is testing a Lifecycle
Policy on Object Storage and created a policy as below:
[("name":"Archive doc", "action":"ARCHIVE",
"objectNameFilter":{"inclusionPrefixes":"doc"] "timeAmount":5,
"timeunit":"DAYS", "isEnabled":true}, ("name":"Delete_doc",
"action":"DELETE", "objectNameFilter":"inclusionPrefixes": {"doc"]
1,"timeAmount":5, "timeunit":"DAYS","isEnabled":true)
What will happen after this policy is applied?
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
3
PRIVACY STATEMENT. ALL RIGHTS RESERVED
, All the objects having file extension ".doc" will be archived 5 days after
object creation
All the objects with names starting with "doc" will be archived 5 days after
object creation and will be deleted 5 days after archival
All objects with names starting with "doc" will be deleted after 5 days of
object c - 🧠ANSWER ✔✔All objects with names starting with "doc" will be
deleted after 5 days of object creation
1. A FinTech startup is developing a new blockchain based application to
provide Smart Contracts using micro-services architecture. The
development team is planning to deploy the application using containers
and looking for a reliable way to build, deploy, and manage their cloud-
native application. Additionally, they need an easy way to store, share, and
manage their application artifacts.
Which option should you recommend for this applicaiton?
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
4
PRIVACY STATEMENT. ALL RIGHTS RESERVED
Questions and Correct Answers | New
Update
1. A manufacturing company is planning to migrate their on-premises
database to OCI and has hired you for the migration. Customer has
provided following information regarding their existing on-premises
database:
Database version, host OS and version, database character set, storage
for data staging, acceptable length of system outage.
What additional information do you need from customer in order to
recommend a suitable migration method? Choose 2.
On-premises host OS and version
Elapsed time since database was last patched
Number of active connections
Data types used in the on-premises database
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
1
PRIVACY STATEMENT. ALL RIGHTS RESERVED
,Top 5 longest running queries - 🧠ANSWER ✔✔On-premises host OS and
version
Data types used in the on-premises database
1. An insurance company is storing critical financial data in the OCI block
volume. This volume is currently encrypted using Oracle managed keys.
Due to regulatory compliance, the customer wants to encrypt the data
using the keys that they can control and not the keys which are controlled
by Oracle.
What of the following series of tasks are required to encrypt the block
volume using customer managed keys?
Create a vault, create a master encryption key in the vault, assign this
master encryption key to the block volume
Create a master encryption key, create a data encryption key, decrypt the
block volume using existing Oracle managed keys, encrypt the block
volume using the data encryption key
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
2
PRIVACY STATEMENT. ALL RIGHTS RESERVED
,Create a vault, import your master encryption key into the vault, generate
data encryption key, assign data encryption key to the block volume
Create a master encryption key, create a new version of the encryption
key, decry - 🧠ANSWER ✔✔Create a vault, create a master encryption key
in the vault, assign this master encryption key to the block volume
1. A cloud consultant is working on implementation project on OCI. As part
of the compliance requirements, the objects placed in object storage should
be automatically archived first and then deleted. He is testing a Lifecycle
Policy on Object Storage and created a policy as below:
[("name":"Archive doc", "action":"ARCHIVE",
"objectNameFilter":{"inclusionPrefixes":"doc"] "timeAmount":5,
"timeunit":"DAYS", "isEnabled":true}, ("name":"Delete_doc",
"action":"DELETE", "objectNameFilter":"inclusionPrefixes": {"doc"]
1,"timeAmount":5, "timeunit":"DAYS","isEnabled":true)
What will happen after this policy is applied?
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
3
PRIVACY STATEMENT. ALL RIGHTS RESERVED
, All the objects having file extension ".doc" will be archived 5 days after
object creation
All the objects with names starting with "doc" will be archived 5 days after
object creation and will be deleted 5 days after archival
All objects with names starting with "doc" will be deleted after 5 days of
object c - 🧠ANSWER ✔✔All objects with names starting with "doc" will be
deleted after 5 days of object creation
1. A FinTech startup is developing a new blockchain based application to
provide Smart Contracts using micro-services architecture. The
development team is planning to deploy the application using containers
and looking for a reliable way to build, deploy, and manage their cloud-
native application. Additionally, they need an easy way to store, share, and
manage their application artifacts.
Which option should you recommend for this applicaiton?
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
4
PRIVACY STATEMENT. ALL RIGHTS RESERVED
