1z0-931 Free Practice Test

Which can be Scaled independently of the number of CPUs in an Autonomous Database?

1. A. Concurency
2. B. Memory
3. C. Parallelism
4. D. Storage
5. E. Sessions

Correct Answer: B

The default eight day retention period for Autonomous Database performance data can be modifiedusing whichDBMS_WORKLOAD_REPOSITORY subprogram procedure?

1. A. MODIFY_SNAPSHOT_SETTINGS
2. B. UPDATE_OBJECT_INFO
3. C. CREATE_BASELINE_TEMPLATE
4. D. UPDATE_OBJECT_INFO

Correct Answer: A
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/monitor-performance-intro.html#

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

1. A. Autonomous Data Warehouse workloads are optimized for mixed workloads.
2. B. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
3. C. Data that Is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format Is columnar.
4. D. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.

Correct Answer: A

Which statement about the Export Wizard used to export database objects and data is NOT correct?

1. A. If "Dependents" is checked as a DDL Option, for non-privileged users, only dependent objects in their schema are exported.
2. B. Export DDL includes features such as "Show schema," "Storage," and "Terminator."
3. C. If "Grants" Is checked as a DDL Option, GRANT statements are Included for any grant objects on the exported objects, including those owned by the SYS schema.
4. D. If "Clipboard" is selected as the "Output," the output will be placed on the system clipboard, so that it can be pasted into a file, a command line, or other location appropriate for the format.

Correct Answer: C

What is the default retention period for both Automatic and Manual Autonomous Database Backups?

1. A. One Year
2. B. 90 days
3. C. 7 days
4. D. 30 days
5. E. 60 days

Correct Answer: D