Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-915-1

Free Oracle 1Z0-915-1 Exam Questions (page: 2)

Page 2 of 10
PDF with 75 Questions

You can perform a node estimate when adding a HeatWave cluster to a DB system in OCI Console.
Which two tasks are performed by the node estimate process? (Choose two.)

  1. Generate a load command to activate Auto Parallel Load.
  2. Estimate the number of OCPUs required to process selected user tables.
  3. Estimate the memory required for each user table.
  4. Generate a set of alter statements to load selected tables into the HeatWave cluster.
  5. Estimate the disk storage required for each user table.

Answer(s): B,C



What must you do before deleting a DB system?

  1. Take a manual backup
  2. Stop the instance if it is running.
  3. Disable delete protection if it is enabled.
  4. Stop and remove any connected HeatWave Cluster.

Answer(s): C



You want to create a new DB system with data import. How do you prepare the data?

  1. Export the data into the file system with a MySQL Shell dump utility
  2. Export the data into an Object Storage bucket with a MySQL Shell dump utility.
  3. Back up the database into an Object Storage bucket with MySQL Enterprise Backup.
  4. Export the data into the file system with the mysqldump client utility.

Answer(s): B



Which two are available when creating a new MySQL DB system in OCI Console? (Choose two.)

  1. High availability
  2. Lakehouse
  3. Standalone server
  4. Read replica
  5. HeatWave cluster

Answer(s): A,C



You want to train a classification model with MySQL HeatWave AutoML.
Which two are requirements of the training data set? (Choose two.)

  1. The target column must be numeric.
  2. The target column and all feature columns must be stored in a single table.
  3. All feature columns must be numeric.
  4. There must be at least two feature columns.
  5. The target column must have at least two distinct values.

Answer(s): B,E



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. mysqlsh -h 10.0.1.221 -u admin -p MySQL8.0
  2. mysqlsh mysql://MySQL8.0:admin@10.0.1.221
  3. mysqlsh mysql://admin:MySQL8.0@10.0.1.221
  4. mysqlsh -h10.0.1.221 -uadmin -pMySQL8.0
  5. mysqlsh -host 10.0.1.221 -user admin -password MySQL8.0

Answer(s): C,E



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

  1. Disable high availability, edit the DB system, change the configuration, and enable high availability.
  2. Stop the DB system, edit the DB system, change the configuration, and start the DB system.
  3. 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. Edit the DB system and change the configuration.

Answer(s): C



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

  1. The target DB system is a high-availability DB system.
  2. Some tables have no primary key
  3. The binary log offset is unknown.
  4. The source gtid mode is OFF.

Answer(s): D



Viewing page 2 of 10



Post your Comments and Discuss Oracle 1Z0-915-1 exam prep with other Community members:

1Z0-915-1 Exam Discussions & Posts