1Z0-931 Exam Questions

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?

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

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 used by a Data Warehouse developer?

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)?

Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?

Which statement is true in regards to database links?

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

Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?

Which is correct about security features that are available in Oracle Autonomous Database?

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