Oracle 1z0-915-1 Exam Questions

Question 6 of 65

You want to connect to a DB system with MySQL Shell.
DB system endpoint IP address: 10.0.1.221

Username: admin -

Password: MySQL8.0 -
Which two commands work? (Choose two.)

mysqlsh -h 10.0.1.221 -u admin -p MySQL8.0

mysqlsh mysql://MySQL8.0:admin@10.0.1.221

mysqlsh mysql://admin:MySQL8.0@10.0.1.221

mysqlsh -h10.0.1.221 -uadmin -pMySQL8.0

mysqlsh -host 10.0.1.221 -user admin -password MySQL8.0

Correct Answer: C, E

Question 7 of 65

Which sequence of steps must you perform to change the configuration of a high-availability DB system?

Disable high availability, edit the DB system, change the configuration, and enable high availability.

Stop the DB system, edit the DB system, change the configuration, and start the DB system.

Edit and change the configuration of all secondary instances, switch over to a secondary instance, and edit and change the configuration of the former primary instance.

Edit the DB system and change the configuration.

Correct Answer: C

Question 8 of 65

Why would you select "Source cannot use GTID auto-positioning" when creating a channel?

The target DB system is a high-availability DB system.

Some tables have no primary key.

The binary log offset is unknown.

The source gtid_mode is OFF.

Correct Answer: D

Question 9 of 65

You have an inbound replication channel that replicates data from one DB system to another DB system. Both DB systems are created with the default configuration.
You encountered the following error on the target DB system:
Exam 1z0-915-1: Question 9 - Image 1

What is the possible cause?

The missing GTID set has been archived to object storage and is no longer available.

The target DB system relay log file destination is full.

The channel has been disabled for more than 2 hours.

The administrator has deleted the binary log files from the source DB system.

Correct Answer: D

Question 10 of 65

What happens when you perform a switchover of a high-availability DB system with an attached HeatWave cluster?

The HeatWave cluster is deleted and a new HeatWave cluster is attached to the new primary instance.

The HeatWave cluster is attached to the new primary instance.

The HeatWave cluster remains attached to the same DB system and the new primary instance redirects queries to that cluster.

The HeatWave cluster is no longer valid; you must re-create the HeatWave cluster.

Correct Answer: A