1Z0-931-20 Exam Questions

Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?

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

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?

For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

Which three event types are supported for Autonomous Database?

You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements: - Autonomous Transaction Processing - License Included - Shared Inf...

Which Autonomous Database Service is NOT used to conned to an Autonomous Transaction Processing instance?

When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?

Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

Which is NOT required to connect to Autonomous Database from SQL developer?

What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database? (Choose two.)

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

Which is the correct subset of services offered via OCI-CLI (command line interface) for Autonomous Database (ABD) via calls made to the OCI API's?

What two methods can you use to define Machine Learning Users? (Choose two.)

Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating (access to) a storage ob...

Which Java Database Connectivity (JDBC) thin client version supports the use of HTTP proxy settings that does NOT support TCP to connect to Autonomous Data Warehouse?

Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production. How should the...

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...

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

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

When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?

Users are required to select a service when connecting to Autonomous Data Warehouse and these services match to one of three different consumer groups: High, Medium, and Low. Which...

Which two choices are true for Autonomous Data Warehouse (ADW)? (Choose two.)

Where do you find the tnsnames.ora for your Autonomous Data Warehouse (ADW) database?

The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?

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

Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)

Which of these database features is NOT part of the Autonomous Database?

Which two statements are true with regards to Oracle Data Sync? (Choose two.)

Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?

What is the predefined role that exists in Autonomous Database that includes common privileges that are

Which two options are valid for loading data directly into Autonomous Data Warehouse (ADW)? (Choose two.)

Which statement is true regarding Autonomous Transaction Processing (ATP)?

Which two system privileges does a user need to create analytic views? (Choose two.)

What are three methods to load data into the Autonomous Database? (Choose three.)

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

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

Which three statements are correct when the Autonomous Database is stopped? (Choose three.)

Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.)

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

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?

You have hired a new employee to run reports from the Autonomous Data Warehouse (ADW) and are not confident in their SQL writing ability. Into which consumer group will you assign...

You have provisioned an Autonomous Data Warehouse (ADW) database with 16 enabled OCPUs and need to configure the consumer group for your application. Which two are true when decidi...

Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP en...

The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usemames and init.ora parameters. The de...

A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum r...

Which statement is true regarding database client credentials file required to connect to your Autonomous Database?

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