Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials

Here you have the best Oracle 1z0-338 practice exam questions

You have 81 total questions to study from
Each page has 5 questions, making a total of 17 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on October 28, 2025
This site is not affiliated with or endorsed by Oracle.

Question 1 of 81

A cloud user is assigned the Service Administrator role.
Which cloud actions can this user perform?

Perform all tasks in the My Services application, including user and role management tasks.

View, create, update, and delete Oracle Compute Cloud Service resources.

View only the Oracle Compute Cloud resources.

Work with one or more Oracle Cloud services only and use the My Services application to manage his or her own password and security challenge questions.

Perform cloud backups of a specific instance.

Correct Answer: B

Question 2 of 81

You notice that a database node has hung, so you open a Service Request via My Oracle Support.
What diagnostic output will you send to My Oracle Support by default?

pkginfo

oswatcher

AWR

v$session output

list of database users

Correct Answer: C

By default, the diagnostic output that you would send to My Oracle Support when a database node hangs is AWR (Automatic Workload Repository) report. AWR collects and maintains performance statistics and metrics. It is the primary tool used for Oracle database performance diagnostics and tuning.

Question 3 of 81

Which three items are the main elements of Oracle Database Resource Manager? (Choose three.)

SQL Explain Plan

resource plan

resource consumer group

resource plan directive

IORMPLAN object

Correct Answer: B, C, D

Question 4 of 81

In a customers ACFS filesystem, they would like you to set up replication between the existing local primary and the remote standby Exadata system.
Which tool would you use to administer the replication process?

Replication is controlled by using Enterprise Manager Cloud Control.

Replication is controlled by using sqlplus while you are logged in as SYSASM.

Replication is controlled by using the acfsutil command-line tool.

Replication of ACFS filesystems for non-database files on Exadata is not supported.

Replication is controlled by using the exacli command-line tool.

Correct Answer: C

Question 5 of 81

Which two statements are true about troubleshooting failed patching activities? (Choose two.)

Dependency issues found during yum updates should be ignored by using the force option.

Failed storage cell patches are rolled back to the previous release automatically.

Failed OS patches on database servers can be rolled back.

Dependency issues that are found during yum updates require rolling back to a previous release before retrying.

Bundle patches applied by using opatch auto cannot roll back only the database or the grid infrastructure home.

Database server OS updates can be rolled back by using opatch auto –rollback.

Correct Answer: C, E

Failed OS patches on database servers can be rolled back, as this is a common procedure to revert unintended changes and restore functionality. Bundle patches applied using opatch auto have limitations in their rollback capabilities, specifically not allowing the rollback of only the database or the grid infrastructure home separately.