1z0-915-1 Exam Question 21

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.)
  • 1z0-915-1 Exam Question 22

    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.)
  • 1z0-915-1 Exam Question 23

    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.)
  • 1z0-915-1 Exam Question 24

    The following statements are executed successfully:

    Which two are true? (Choose two.)