Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

1z0-931 by Oracle - Page 1 | ExamCademy

Mode Selection

Question 1

Question 2

Question 3

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

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

Question 4

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

A Active transactions continue running unaffected.
B Active transactions are paused.
C Scaling cannot happen while there are active transactions in the database.
D Active transactions are terminated and rolled back.

Question 5

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

A User with DWROLE can still access the database.
B Tools are no longer able to connect to a stopped instance.
C CPU billing is halted based on full-hour cycles of usage.
D In-flight transactions and queries are stopped.

Question 6

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

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 on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
C Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
D Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials. E. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.

Question 7

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.

Question 8

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 tnsnames.ora
B keystore.jks
C sqlnet.ora
D cwallet.sso
E ojdbc.properties

Question 9

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 environment. The Oracle adviser recommends to use Oracle Data Sync for this.
Which statement is true regarding Oracle Data Sync?

A Data Sync can only load files into tables (insert-only), the customer has to write the additional code.
B Data Sync can not transform your data while loading it into the destination table.
C Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files.
D Data Sync can only load data from one source into one destination table.

Question 10

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 decision was made to adhere to the suggested migration method using an instant client and the datapump version that was suggested (and came with it).
Which statement is true about the migration of the application's database success?

A The migration can be technically a success but the 3-rd party vendor needs to support the result.
B The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful.
C The tablespace names will result in a blocking error during datapump import because of ADB limitations.
D The migration can be a success, both technically and functional due to datapump enhancements.

Question 11

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 reassurance of their end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronised with the ADB Instance for a switch back.
Which statement about the migration using Golden Gate is correct?

A Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB.
B Only the migration to ADB is possible from an on-premise installation of Golden Gate.
C Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service exists for this.
D The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB.
E The described scenario is correct, can be used for migration and fallback scenarios.

Question 12

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

A UPDATE_OBJECT_INFO
B MODIFY_SNAPSHOT_SETTINGS
C CREATE_BASELINE_TEMPLATE
D MODIFY_BASELINE_WINDOW_SIZE

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 3 • Questions 1-25 of 60

1 2 3

→

Know a question that should be here? Contribute to this exam

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.

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

A Oracle GoldenGate
B Transportable Tablespace
C RMAN Restore
D Oracle Data Pump
E SQL*Loader