Oracle Certified 1z0-915-1 Dumps Questions Valid 1z0-915-1 Materials [Q11-Q29]

5/5 - (1 vote)

Oracle Certified 1z0-915-1 Dumps Questions Valid 1z0-915-1 Materials

Current 1z0-915-1 Exam Dumps [2025] Complete Oracle Exam Smoothly

Oracle 1z0-915-1 Exam Syllabus Topics:

Topic	Details
Topic 1	Data Migrations: For data migration specialists and database administrators, this part of the exam covers creating a DB system with data import, importing data into a DB system, and exporting data from MySQL servers and DB systems.
Topic 2	MySQL HeatWave Configurations: For database administrators and performance tuning specialists, this part of the exam covers creating custom configurations, comparing configurations, describing the effects of changing dynamic and non-dynamic variables, and updating a DB system configuration.
Topic 3	Describe the architecture of the HeatWave cluster, adding a HeatWave cluster to a DB system, and determine whether a query is offloaded to HeatWave cluster for execution.
Topic 4	Managing DB systems: For network administrators and cloud infrastructure specialists, this domain of the exam covers demonstrating a command of DRG and DRG Attachments, applying BGP in the OCI environment, evaluating OCI VPN Services, and validating the various FastConnect products from OCI.
Topic 5	Provisioning and Connecting DB systems: For system administrators and database engineers, this part of the exam covers identifying VCN requirements for provisioning DB systems, connecting to DB systems with OCI Bastion, connecting to DB systems with MySQL Shell, connecting to DB systems with OCI Cloud Shell, connect to DB system with OCI SQL Worksheet, and authenticate DB system with OCI Identify Access Management credentials.
Topic 6	Inbound Replication: For database administrators and replication experts, this section of the exam covers setting up and troubleshoot inbound replication and creating channels.
Topic 7	Read Replicas: For database architects and replication specialists, this domain of the exam covers creating and managing read replicas, describing the read replica load balancer, connecting to a read replica, etc.
Topic 8	HeatWave Cluster: For database performance specialists and cloud architects, this section of the exam covers

QUESTION 11
Which two are true about creating a new DB system with data import? (Choose two.)

The data must be created with the mysqldump client utility.

The files containing the data must be uploaded through OCI Console on the “Create DB system” page.

The data must be stored in an Object Storage bucket in the same OCI region as the new DB system.

A valid pre-authenticated request must be provided to access the data.

The data must be created with MySQL Enterprise Backup.

QUESTION 12
You create a new MySQL DB system. It fails because you use mysql.sys as the administrator username.
What is the reason?

mysql.sys is a reserved username that cannot be used in customer-defined user accounts.

The username can contain only uppercase characters.

The username cannot contain non-alphanumeric characters, such as a period.

The username must have at least 10 characters.

QUESTION 13
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?

Create an ingress rule that allows stateless connections on port 3306 and 33060.

Create an egress rule that allows stateful connections on port 3306 and 33060.

Create an ingress rule that allows stateful connections on port 3306 and 33060.

Create an egress rule that allows stateless connections on port 3306 and 33060.

QUESTION 14
Which is true about automatic DB system version upgrades?

You must specify the next version to be used before the upgrade.

The DB system is never upgraded automatically.

The DB system is upgraded to the next release in sequence.

The DB system is upgraded to the most recent release.

QUESTION 15
Which two are true about creating a Bastion service to connect to a MySQL DB system? (Choose two.)

The Bastion service must have a public IP address.

The Bastion service must be in the same VCN as the DB system.

The Bastion CIDR block allowlist must include the IP address of all valid client machines.

The Bastion CIDR block allowlist must include the IP address of the DB system.

TheBastion subnet must have an ingress rule to allow stateful connections on the MvSQL DB system port number.

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

The target column must be numeric.

The target column and all feature columns must be stored in a single table.

All feature columns must be numeric.

There must be at least two feature columns.

The target column must have at least two distinct values.

QUESTION 17
Which two methods can you use to import data into a MySQL DB system by using MySQL Shell? (Choose two.)

util.importTable()

util.dumpInstance()

util.dumpSchemas()

util.loadDump()

QUESTION 18
The first query has an estimated cost of 100,000,000 and is offloaded to a HeatWave cluster for execution:
SELECT flightno, departure, country FROM flight JOIN airport_geo ON ‘from’=airport_id; The second query has an estimated cost of 10,000 and is NOT offloaded to the Heatwave cluster for execution:
SELECT DISTINCT country FROM airport_geo ORDER BY country;
Which two methods can offload the second query to the Heatwave cluster for execution? (Choose two.)

SET use_secondary_engine=FORCED;

SET secondary_engine_cost_threshold=1000;

SET optimizer_trace=”enabled=on”;

CALL sys.heatwave_load(‘[“airport_geo”]’);

CALL sys.heatwave_advisor(JSON_OBJECT(“auto_enc”, JSON_OBJECT(“mode”, “recommend”)));

QUESTION 19
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.)

Generate a load command to activate Auto Parallel Load.

Estimate the number of OCPUs required to process selected user tables.

Estimate the memory required for each user table.

Generate a set of alter statements to load selected tables into the HeatWave cluster.

Estimate the disk storage required for each user table.

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

Primary instance: AD1-FD1; Secondary instance 1: AD2-FD2; Secondary instance 2: AD3-FD3

Primary instance: AD1-FD3; Secondary instance 1: AD2-FD2; Secondary instance 2: AD3-FD3

Primary instance: AD1-FD1; Secondary instance 1: AD1-FD2; Secondary instance 2: AD1-FD3

Primary instance: AD1-FD3; Secondary instance 1: AD1-FD2; Secondary instance 2: AD1-FD3

QUESTION 21
Automatic backup retention of a DB system is disabled. Which operation deletes all automatic backups of the DB system?

Enabling point-in-time recovery

Disabling delete protection

Deleting the DB system

Disabling point-in-time recovery

QUESTION 22
Which type of configuration variables CANNOT be modified in MySQL custom configurations?

Initialization variables

User variables

System variables

Default user variables

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

Create read replicas.

Add HeatWave cluster.

Enable crash recovery.

Enable high availability.

QUESTION 24
What is the benefit of creating a new DB system with data import?

Faster import with minimal logging

Smaller storage size with better compression

Faster backup with a first full backup

Consistent data with no user connection

QUESTION 25
A DB system has been deleted successfully. Which two operations are allowed on the deleted DB system?
(Choose two.)

Change the storage size.

Create a manual backup.

Restore the DB system from an existing manual backup.

View the metrics.

View the API call logs on the Audit page.

QUESTION 26
The following statements execute successfully:
CALL sys.ML_TRAIN(‘ml_data.iris’, ‘class’, NULL, @model);
SELECT @model;
Which three are true? (Choose three.)

The statements validate the data set but do not create a model.

The generated model handle is shown in the output.

The statements create a classification model.

The training data set is obtained from the ml_data table in the iris schema.

The target column is class.

QUESTION 27
You want to create a second user called admin2 with the same privileges as the administrator specified when creating the DB system.
Which statement helps you achieve this?

CREATE USER admin2 IDENTIFIED BY ‘Password’ DEFAULT ROLE ‘administrator’;

CREATE USER admin2 IDENTIFIED BY ‘Password’; GRANT SUPER ON *.* TO admin2 WITH GRANT OPTION;

CREATE USER admin2 IDENTIFIED BY ‘Password’; GRANT AUDIT_ADMIN,
BACKUP_ADMIN, SESSION_VARIABLES_ADMIN ON *.* TO admin2 WITH GRANT OPTION;

CREATE USER admin2 IDENTIFIED BY ‘Password’; GRANT ALL PRIVILEGES ON *.* TO admin2 WITH GRANT OPTION;

QUESTION 28
You want to determine which version of MySQL is running on your DB system.
Which two SQL statements show the MySQL version? (Choose two.)

SELECT * FROM performance_schema.global_status WHERE VARIABLE_NAME=’version’;

select @@version;

SHOW VARIABLES LIKE ‘version’;

SHOW STATUS LIKE ‘version’;

SELECT @version;

QUESTION 29
You want to change the configuration of an active stand-alone DB system. The DB system is configured as the target of a channel, and the channel is currently active.
Which sequence of steps must you perform?

Edit the DB system and change the configuration.

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

Delete the channel, edit the DB system, change the configuration, and re-create the channel.

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