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: Mar 02, 2024

Add To Cart

Question 1

You have provisioned a MySQL HeatWave DB system in your VCN and want to connect using MySQL Shell from your local machine. Which additional configuration is necessary to establish a secure connection?

A : Configure a bastion service in your VCN and access the DB system through the bastion instance's internal IP address.

B : Enable SSH public key authentication on the DB system and utilize the \connect command with the public endpoint IP address and private key.

C : Grant your user account the connect privilege for the database and use the mysql command with the DB system's public endpoint IP address and username/password.

D : Create a route table entry in your VCN routing traffic from your local machine's subnet to the DB system's subnet directly.

E : Configure a VPN connection between your local machine and the VCN containing the DB system and connect using the private endpoint IP address.

Answer: B

Question 2

The following statements are executed successfully:

Which two are true? (Choose two.)

A : The data placement key of the airport table is airport_id.

B : The airport.tbl file is in CSV format.

C : The fields in the airport.tbl file are delimited by comma.

D : The data of the airport table is loaded into the MySQL DB system.

E : Every row in the airport table has a unique airport_id value.

Answer: A,D

Question 3

You need to update the query_cache_size configuration parameter in your MySQL HeatWave service. Which of the following methods is recommended for a production environment with minimal disruption?

A : Modify the my.cnf file and restart the HeatWave service

B : Use the ALTER SYSTEM statement directly in the HeatWave SQL shell

C : Update the parameter through the Oracle Cloud Infrastructure (OCI) Console

D : Use the SET GLOBAL statement in a MySQL client session

Answer: C

Question 4

During a MySQL HeatWave HA cluster upgrade, you initiate a planned switchover. Which two actions are most likely to occur during this process?

A : Automatic failover triggers if the upgrade takes longer than expected.

B : All user connections are paused and resumed to the new primary node.

C : Data is replicated asynchronously to the new primary node during switchover.

D : The previous primary node becomes completely unavailable after the switch.

E : New queries are directed to the secondary node even before the switchover finishes

Answer: B,C

Question 5

You plan to update the HeatWave service version with minimal downtime for ongoing queries. Which update approach and strategy should you utilize to achieve this goal?

A : Perform a rolling update with online schema migration followed by service restart.

B : Apply the update directly to the running service and accept potential query interruptions.

C : Schedule the update during a maintenance window and fully restart the HeatWave service.

D : Migrate queries to a standby HeatWave cluster before updating the primary service.

Answer: A

Page: 1 / 40

Total 200 Questions | Updated On: Mar 02, 2024

Add To Cart