oracle 1z0-915-1 practice test

You want to import data into a DB system with MySQL Shell util.loadDump().
Which option can speed up the load?

• A. updateGtidSet: off
• B. showMetadata: false
• C. skipBinlog: true
• D. deferTableIndexes: all

You want to restore the backup of a stand-alone DB system to a new DB system.
Which two changes are allowed? (Choose two.)

• A. Use a smaller data storage size for the new DB system.
• B. Use a different subnet for the new DB system.
• C. Use a different shape for the new DB system.
• D. Use a different tenancy for the new DB system.
• E. Use a different region for the new DB system.

Which two are true about read replica load balancer? (Choose two.)

• A. It has the same endpoint as the DB system.
• B. It distributes connections among the source DB system and all read replicas.
• C. User accounts containing a client host name cannot connect to the read replica load balancer.
• D. It is created when the DB system is first created.
• E. It distributes connections among read replicas.

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

Which MySQL HeatWave AutoML routine evaluates a model?

• A. ML_EXPLAIN
• B. ML_EXPLAIN_TABLE
• C. ML_TRAIN
• D. ML_SCORE
• E. ML_PREDICT_TABLE

You want to create a custom configuration for the MySQL DB system in OCI Console. Which three can
you set? (Choose three.)

• A. Shape
• B. VCN
• C. Description
• D. Subnet
• E. Compartment

Which placement is NOT valid for a high-availability DB system? (Note: AD refers to availability
domain and FD refers to fault domain.)

• A. Primary instance: AD1-FD1; Secondary instance 1: AD2-FD2; Secondary instance 2: AD3-FD3
• B. Primary instance: AD1-FD3; Secondary instance 1: AD2-FD2; Secondary instance 2: AD3-FD3
• C. Primary instance: AD1-FD1; Secondary instance 1: AD1-FD2; Secondary instance 2: AD1-FD3
• D. Primary instance: AD1-FD3; Secondary instance 1: AD1-FD2; Secondary instance 2: AD1-FD3

What must you do to minimize a DB system down time caused by automatic maintenance
operations?

• A. Create read replicas.
• B. Add HeatWave cluster.
• C. Enable crash recovery.
• D. Enable high availability.

Which two are true about data loaded into a MySQL HeatWave cluster? (Choose two.)

• A. Data is replicated across cluster nodes for high availability.
• B. Data is partitioned across cluster nodes for scalability.
• C. Data is stored locally in each cluster node's solid state disks (SSD) to increase I/O performance.
• D. Data is stored in hybrid columnar format to speed up analytic queries.
• E. Data rows are sorted on the primary key to speed up range search.

You create a MySQL DB system with default port numbers, and attach it to a subnet.
Which configuration is required on the subnet to enable client applications to connect to the DB
system?

• A. Create an ingress rule that allows stateless connections on port 3306 and 33060.
• B. Create an egress rule that allows stateful connections on port 3306 and 33060.
• C. Create an ingress rule that allows stateful connections on port 3306 and 33060.
• D. Create an egress rule that allows stateless connections on port 3306 and 33060.