Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-915-1

Oracle 1z0-915-1 Exam Practice Questions (P. 2)

  • Full Access (75 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #6
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.)
  1. A
    mysqlsh -h 10.0.1.221 -u admin -p MySQL8.0
  2. B
    mysqlsh mysql://MySQL8.0:[email protected]
  3. C
    mysqlsh mysql://admin:[email protected]
  4. D
    mysqlsh -h10.0.1.221 -uadmin -pMySQL8.0
  5. E
    mysqlsh -host 10.0.1.221 -user admin -password MySQL8.0

Correct Answer: CE ?️

Question #7
Which sequence of steps must you perform to change the configuration of a high-availability DB system?
  1. A
    Disable high availability, edit the DB system, change the configuration, and enable high availability.
  2. B
    Stop the DB system, edit the DB system, change the configuration, and start the DB system.
  3. C
    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.
  4. D
    Edit the DB system and change the configuration.

Correct Answer: C ?️

Question #8
Why would you select "Source cannot use GTID auto-positioning" when creating a channel?
  1. A
    The target DB system is a high-availability DB system.
  2. B
    Some tables have no primary key.
  3. C
    The binary log offset is unknown.
  4. D
    The source gtid_mode is OFF.

Correct Answer: D ?️

Question #9
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:

What is the possible cause?
  1. A
    The missing GTID set has been archived to object storage and is no longer available.
  2. B
    The target DB system relay log file destination is full.
  3. C
    The channel has been disabled for more than 2 hours.
  4. D
    The administrator has deleted the binary log files from the source DB system.

Correct Answer: D ?️

Question #10
What happens when you perform a switchover of a high-availability DB system with an attached HeatWave cluster?
  1. A
    The HeatWave cluster is deleted and a new HeatWave cluster is attached to the new primary instance.
  2. B
    The HeatWave cluster is attached to the new primary instance.
  3. C
    The HeatWave cluster remains attached to the same DB system and the new primary instance redirects queries to that cluster.
  4. D
    The HeatWave cluster is no longer valid; you must re-create the HeatWave cluster.

Correct Answer: A ?️

Previous Questions Next Questions

All Pages