Free Oracle 1z0-915-1 Exam Dumps Questions & Answers

What must you do before deleting a DB system?

• A.Stop the instance if it is running.
• B.Stop and remove any connected HeatWave Cluster.
• C.Disable delete protection if it is enabled.
• D.Take a manual backup

You have an inbound replication channel that replicates data from one DB system to another DB system. Both DB systems are created with the default configuration.
You encountered the following error on the target DB system:

What is the possible cause?

• A.The administrator has deleted the binary log files from the source DB system.
• B.The target DB system relay log file destination is full.
• C.The channel has been disabled for more than 2 hours.
• D.The missingGTID set has been archived to object storage and is no longer available.

You want to train a model that predicts sales based on the available data the company holds.
This is an excerpt of thesalestable:

Which command trains the model?

• A.CALL sys.ML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'regression'), @model);
• B.CALL sys.mML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'forecasting'), @model);
• C.CALL sys.ML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'anomaly_detection'),
  @model);
• D.CALL sys.ML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'classification'), @model);

A MySQL DB system has an endpoint in an OCI VCN subnet. The VCN is not configured with VCN peering, VPN access, and FastConnect. You want to connect to the MySQL DB system directly from an OCI Cloud Shell session.
Which two are true? (Choose two.)

• A.The VCN subnet of the Cloud Shell session must have a Service Gateway in its route table.
• B.You must install mysql client programs in the Cloud Shell session.
• C.The VCN subnet of the Cloud Shell session must have an Internet Gateway in its route table.
• D.You must attach the Cloud Shell session to a VCN subnet that can connect to the MySQL DB system.
• E.The MySQL DB system subnet must be in the Cloud Shell tenancy home region.

Which is true about dynamic variables in MySQL HeatWave configurations?

• A.Changes in dynamic variables require a server restart.
• B.All user variables are dynamic.
• C.Dynamic variables in a custom configuration can be changed without copying the configuration to a new configuration.
• D.Initialization variables are not dynamic.