oracle 1Z0-915-1 Exam Questions
Questions for the 1Z0-915-1 were updated on : Dec 01 ,2025
Page 1 out of 5. Viewing questions 1-15 out of 65
Question 1
There are more than 10 concurrent users running queries on the DB system. The airport_geo table
has been loaded successfully into a HeatWave cluster.
You want to run this query:
SELECT DISTINCT country FROM airport_geo ORDER BY country;
How do you determine whether the query is offloaded to the HeatWave cluster for execution?
- A. View the Query Execution Plan of the query by running EXPLAIN.
- B. Check the value of the rapid_query_offload_count global status variable.
- C. Query the rpd_tables table in performance_schema.
- D. Check the value of the hw_data_scanned global status variable.
Answer:
A
Question 2
How can you determine the uptime of a DB system?
- A. By using the Audit section in Logging information in the OCI Web console
- B. By checking the DB system details in the OCI Web console
- C. By querying performance_schema.global_status from a connected MySQL client
- D. By executing mysql db-system get --db-system-id with OCI CLI
Answer:
C
Question 3
You have obtained a new tenancy on Oracle Cloud Infrastructure. You first create a VCN by using the
VCN Wizard, and then create a MySQL DB system. You want to create a Connection in Database tools
to use the SQL Worksheet feature.
Which three steps are required? (Choose three.)
- A. Create an OCI password.
- B. Create an encryption key.
- C. Create an OCI vault.
- D. Create an OCI secret.
- E. Import an X.509 certificate into the OCI vault.
Answer:
B, C, D
Question 4
Which two are true about creating a Bastion service to connect to a MySQL DB system? (Choose
two.)
- A. The Bastion service must have a public IP address.
- B. The Bastion service must be in the same VCN as the DB system.
- C. The Bastion CIDR block allowlist must include the IP address of all valid client machines.
- D. The Bastion CIDR block allowlist must include the IP address of the DB system.
- E. The Bastion subnet must have an ingress rule to allow stateful connections on the MvSQL DB system port number.
Answer:
B, C
Question 5
Which table option defines a Lakehouse external table based on a CSV file?
- A. ENGINE=csv SECONDARY_ENGINE=rapid ENGINE_ATTRIBUTE=’{“file”: [{“region”: “us-ashburn-1”, “namespace”: “mytenant”, “bucket”: “bucket01”, “name”: “airport.csv”}] }’
- B. ENGINE=csv SECONDARY_ENGINE=lakehouse ENGINE_ATTRIBUTE=’{“file”: [{“region”: “us- ashburn-1”, “namespace”: “mytenant”, “bucket”: “bucket01”, “name”: “airport.csv”}] }’
- C. ENGINE=lakehouse SECONDARY_ENGINE=csv ENGINE_ATTRIBUTE=’{“file”: [{“region”: “us- ashburn-1”, “namespace”: “mytenant”, “bucket”: “bucket01”, “name”: “airport.csv”}] }’
- D. ENGINE=lakehouse SECONDARY_ENGINE=rapid ENGINE_ATTRIBUTE=’{“file”: [{“region”: “us- ashburn-1”, “namespace”: “mytenant”, “bucket”: “bucket01”, “name”: “airport.csv”}] }’
Answer:
C
Question 6
Which two are true about MySQL HeatWave configuration resources? (Choose two.)
- A. You can set a value for any global MySQL variable in a configuration.
- B. You must copy the configuration before changing any variable values.
- C. You can view custom configuration sets with the OCI CLI oci mysql db-system get command.
- D. You can compare configurations in the same compartment in OCI console.
Answer:
A, D
Question 7
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?
- A. Edit the DB system and change the configuration.
- B. Stop the DB system, edit the DB system, change the configuration, and start the DB system.
- C. Delete the channel, edit the DB system, change the configuration, and re-create the channel.
- D. Stop the channel, edit the DB system, change the configuration, and start the channel.
Answer:
D
Question 8
You want to migrate an on-premises MySQL database to MySQL HeatWave by exporting the MySQL
database with MySQL Shell util.dumpInstance.
What is the purpose of the ocimds: true option?
- A. It launches a new DB system and imports the data concurrently with the export operation.
- B. It enables all MySQL HeatWave compatibility options.
- C. It returns an error if the database has any incompatibilities with MySQL HeatWave.
- D. It stores the exported files in OCI Object Storage.
Answer:
B
Question 9
You have a MySQL DB system with five active read replicas. The workload consists of 5% writes and
95% reads.
Which connection method provides the fastest query response time?
- A. Connect to the source DB system to perform read-only operations.
- B. Connect to a specific read replica to perform read-only operations.
- C. Connect to the read replica load balancer to perform read-only operations.
- D. Connect to the read replica load balancer to perform read/write operations.
Answer:
C
Question 10
You want to restore a stand-alone DB system to a high-availability DB system with a point-in-time
recovery.
Which three are required? (Choose three.)
- A. Every user table must have a primary key.
- B. Point-in-time recovery must be enabled before the point in time to which you want to restore.
- C. An automatic backup taken before the selected point in time must be available.
- D. A manual backup taken before the selected point in time must be available.
- E. The stand-alone DB system must remain active during the restore.
Answer:
B, C, D
Question 11
Which three are features of MySQL AutoPilot? (Choose three.)
- A. Auto backup
- B. Auto thread pooling
- C. Auto encoding
- D. Auto provisioning
- E. AutoML
Answer:
B, C, D
Question 12
You want to deploy a high-availability MySQL DB system in a region with multiple availability
domains.
Which two types of subnet provide maximum redundancy? (Choose two.)
- A. A public AD-specific subnet
- B. A private regional subnet
- C. A public regional subnet
- D. A private AD-specific subnet
Answer:
B, C
Question 13
Which is true about exporting data to Object Storage with MySQL Shell util.dumpInstance?
- A. You must have a valid OCI CLI configuration.
- B. You must specify ociParManifest: true.
- C. You must specify ocimds: true.
- D. You must provide an OCI username and password to gain write access to Object Storage.
Answer:
C
Question 14
The following statements are executed successfully:
Which two are true? (Choose two.)
- A. The data placement key of the airport table is airport_id.
- B. The airport.tbl file is in CSV format.
- C. The fields in the airport.tbl file are delimited by comma.
- D. The data of the airport table is loaded into the MySQL DB system.
- E. Every row in the airport table has a unique airport_id value.
Answer:
A, D
Question 15
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?
- A. CREATE USER admin2 IDENTIFIED BY ‘Password’ DEFAULT ROLE ‘administrator’;
- B. CREATE USER admin2 IDENTIFIED BY ‘Password’; GRANT SUPER ON *.* TO admin2 WITH GRANT OPTION;
- C. CREATE USER admin2 IDENTIFIED BY ‘Password’; GRANT AUDIT_ADMIN, BACKUP_ADMIN, SESSION_VARIABLES_ADMIN ON *.* TO admin2 WITH GRANT OPTION;
- D. CREATE USER admin2 IDENTIFIED BY ‘Password’; GRANT ALL PRIVILEGES ON *.* TO admin2 WITH GRANT OPTION;
Answer:
D