1Z0-931-20 by Oracle Valid Free Exam Practice Test

Question 1

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

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

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 2

How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?

A. Two. They are called ATP and ADW. B. None. There are no pre-defined service names in tnsnames.ora. C. Three. They are called high, medium and low. D. Five. They are called tpurgent, tp, high, medium and low.

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?

A. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure. B. Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments. C. Moving an Autonomous Database instance does not include its automatic backups. D. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.

Correct Answer: B

Question 4

If you need to connect to Autonomous Data Warehouse (ADW) using Java Database Connectivity (JDBC) via an HTTP proxy, where do you set the proxy details?

A. keystore.jks B. sqlnet.ora C. tnsnames.ora D. cwallet.sso E. ojdbc.properties

Correct Answer: B,C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 5

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.

Correct Answer: A,C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 6

Which two are correct actions to take in order to Download the Autonomous Database Credentials?

A. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet. B. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet. C. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet. D. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials. E. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).

Correct Answer: A,E

Question 7

Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure?

A. REST API B. Terraform C. Dlocker D. Enterprise Manager

Correct Answer: B

Question 8

Which statement is true when the Autonomous Database has auto scaling enabled?

A. Increases the number of sessions available to the database. B. Database concurrency is scaled up when needed by the workload. C. Scales the PGA and SGA size when needed for the workload. D. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.

Correct Answer: D

Question 9

Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?

A. Microsoft SQL Server (.mdf) B. JSON C. Text D. Avro E. Data Pump Export File F. Parquet

Correct Answer: D

Oracle Autonomous Database Cloud 2020 Specialist - 1Z0-931-20 Exam Practice Test