Online Access Free Oracle.1Z0-931.v2021-12-07.q70 Practice Test (Page 6)

1Z0-931 Exam Question 21

Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database.
Which statement is true regarding the default configuration of the Autonomous Data Warehouse?

A.In Autonomous Data Warehouse direct access to the database node and the local file system is allowed.

B.Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands.

C.Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to.

D.Adding, removing, or modifying tablespaces is allowed.

1Z0-931 Exam Question 22

Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database.
Which statement is true regarding the default configuration of the Autonomous Data Warehouse?

A.In Autonomous Data Warehouse direct access to the database node and the local file system is allowed.

B.Adding, removing, or modifying tablespaces is allowed.

C.Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands.

D.Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to.

1Z0-931 Exam Question 23

What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.)

A.Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.

B.Data Pump is platform independent - it can migrate Oracle Databases running on any platform.

C.Data Pump is faster to migrate database than using RMAN.

D.Data Pump creates the tablespaces used by your Autonomous Database.

1Z0-931 Exam Question 24

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

A.Using Database Configuration Assistant (DBCA) on the database server.

B.It cannot be done.

C.Connecting to the Cloud Infrastructure Command console via SSH wallet.

D.Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

1Z0-931 Exam Question 25

Given the steps:
1. Create Oracle Machine Learning User
2. Create projects
3. Create workspaces
4. Create Notebooks
5. Run SQL Scripts
Which two steps are out of order when working with Oracle Machine learning? (Choose two.)

A.Create Oracle Machine Learning User

B.Create workspaces

C.Create Notebooks

D.Run SQL Scripts

E.Create projects

1Z0-931 Exam Question 21

1Z0-931 Exam Question 22

1Z0-931 Exam Question 23

1Z0-931 Exam Question 24

1Z0-931 Exam Question 25

Download PDF File