Free Oracle 1Z0-915-1 Exam Actual Questions

The questions for 1Z0-915-1 were last updated On Dec 20, 2024

Question No. 1

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

Show Answer Hide Answer
Correct Answer: A, B

Question No. 2

Which two are benefits of read replicas? (Choose two.)

Show Answer Hide Answer
Correct Answer: A, D

Question No. 3

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

Show Answer Hide Answer
Correct Answer: A

Question No. 4

Which three are features of MySQL AutoPilot? (Choose three.)

Show Answer Hide Answer
Correct Answer: B, C, D

Question No. 5

Which MySQL HeatWave AutoML routine evaluates a model?

Show Answer Hide Answer
Correct Answer: D