Free Oracle 1Z0-915-1 Exam Questions

Become Oracle Certified with updated 1Z0-915-1 exam questions and correct answers

Page: 1 / 40

Total 200 Questions | Updated On: Aug 06, 2025

Add To Cart

Question 1

You have obtained a new tenancy on Oracle Cloud Infrastructure. You first create a VCN by using the VCN Wizard, and then create a MySQL DB system. You want to create a Connection in Database tools to use the SQL Worksheet feature. Which three steps are required? (Choose three.)

A : Create an OCI password.

B : Create an encryption key.

C : Create an OCI vault.

D : Create an OCI secret.

E : Import an X.509 certificate into the OCI vault.

Answer: A,D,E

Question 2

You are successfully connected to your MySQL HeatWave DB system using MySQL Shell. Which command can you use to verify the connection and confirm you are accessing the HeatWave layer?

A : SHOW SCHEMAS; - This command lists all available schemas in the database.

B : SELECT * FROM SYS.STORAGE_POOL; - This command retrieves information about the HeatWave storage pool.

C : SHOW ENGINE; - This command displays the currently active storage engine, indicating HeatWave if connected correctly.

D : SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES; - This command counts the total number of tables in the database.

E : SHOW VARIABLES WHERE VARIABLE_NAME LIKE '%HEATWAVE%'; - This command displays all MySQL variables related to HeatWave settings.

Answer: C

Question 3

You want to set up automatic backups for your MySQL HeatWave service in OCI. Which three configuration options are essential for a robust backup strategy?

A : Retention policy for archived backups

B : Encryption options for backup files

C : Scheduling for incremental backups

D : Backup storage destination in OCI Object Storage

E : Integration with Oracle Cloud Infrastructure Notifications

Answer: A,B,D

Question 4

You need to set up inbound replication for a specific schema in your on-premises MySQL database to a dedicated table in your MySQL HeatWave replica. Which channel configuration should you utilize?

A : Use a single channel with a table filter to include only the desired schema from the source.

B : Configure a multi-source channel capturing all changes from the on-premises database and filter specific tables during apply on the HeatWave side.

C : Create a dedicated channel for the target table in the HeatWave replica and specify the source schema and table during channel creation.

D : Implement a statement-based filter on the source database replication plugin to selectively capture changes for the target table.

Answer: C

Question 5

Which type of configuration variables CANNOT be modified in MySQL custom configurations?

A : Initialization variables

B : User variables

C : System variables

D : Default user variables

Answer: A

Page: 1 / 40

Total 200 Questions | Updated On: Aug 06, 2025

Add To Cart