1z0-931 Free Practice Test

Which task is NOT automatically performed by the Oracle Autonomous Database?

1. A. Automatically optimize the workload
2. B. Backing up the database
3. C. Mask your sensitive data
4. D. Patching the database

Correct Answer: A

Which operating system can Data Visualization Desktop be run on?

1. A. Linux
2. B. Solaris
3. C. Windows
4. D. AIX

Correct Answer: C
https://www.oracle.com/middleware/technologies/oracle-data-visualization-desktop.html

In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?

1. A. In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.
2. B. In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition.
3. C. In the TEST phase of the wizard, a subset of accepted records are displayed based on your definition.
4. D. In the TEST phase of the wizard a list is generated containing the records that would be rejected during import.

Correct Answer: C

When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?

1. A. Scaling cannot happen while there are active transactions in the database.
2. B. Active transactions are terminated and rolled back.
3. C. Active transactions are paused.
4. D. Active transactions continue running unaffected.

Correct Answer: A

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

1. A. Connecting to the Cloud Infrastructure Command console via SSH wallet.
2. B. It cannot be done.
3. C. Using Database Configuration Assistant (DBCA) on the database server.
4. D. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

Correct Answer: A