Oracle 1Z0-931

1. Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in
order to execute API calls?
A. Navigate to Identity, select Users panel on the console and select "Add Public Key".

B. SSH keys cannot be added from console. They have to be added using REST APIs only.
C. On the Autonomous Database Console.
D. SSH keys are not required In Oracle Cloud Infrastructure.
Answer: A

2 Which two statements are true about the The Oracle Cloud Infrastructure (OCI)?
A. Because availability domains do not share infrastructure such as power or cooling, or the internal
availability domain network, a failure at one availability domain within a region is unlikely to impact the
availability of the others within the same region.

B. Regions are dependent on other regions and must be located within 5 thousand kilometres of each
other.

C. An OCI region is a localized geographic area, and an availability domain is one or more data centers
located within a region.
D. A single fault domain can be associated with multiple regions and availability domains.
Answer: A,C

3. A Corporation is building a web application to allow its customers to schedule service requests online.
There is also a need to run operational reports at times during non-peak hours. The architecture team is
debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA
Manager does not want to add anymore admin responsibility to the team and is looking for a database
option that's low to zero maintenance, but meets their strict performance requirements as well. Which
Oracle Cloud Infrastructure database service is appropriate for this scenario?
A. ATP. Using 'tpurgent and 'high' TNS services to separate connection types

B. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
C. Since the application needs to be highly available, It should be deployed on a Kubernetes Cluster.

D. ADW since operational reporting is a higher priority in this scenario.

Answer: A

4. Which three statements are true regarding how Autonomous Database provides data security?
A. Data is encrypted at rest using transparent data encryption.

B. Oracle automatically applies security updates to ensure data is not vulnerable to known attack
vectors.

C. Users are given OS logins or SYSDBA privileges to prevent phishing attacks.

D. Network connections from clients to Autonomous Database are encrypted using the client
credentials wallet.
Answer:A,B, D
5. Which is correct about security features that are available in Oracle Autonomous Database?
A. TDE but not Data Redaction
B. Neither Data Redaction nor TDE are supported .
C. Data Redaction and TDE are both supported

D. Data Redaction but not TDE

Answer:C

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

A. Mask your sensitive data
B. Patching the database
C. Backing up the database

D. Automatically optimize the workload

Answer: A

7. Which three tasks by default are taken care of by the Autonomous Database?
A. Firmware Patching
B. Database Upgrades

C. Backups
D. Application User Creation
E. Data Loading
Answer: A,B,C

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

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. Adding, removing, or modifying tablespaces is allowed.

Answer: B

9. 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 ie. data format Is columnar.
Answer: D

10. What are two security features enabled by default by the Autonomous Database?
A. One SYSDBA account
B. Transparent Data Encryption
C. SQL Net Encryption
D. Encrypted Database Links
E. Read Only access to OS Audit logs
Answer: B, C

11. Which of these database features is NOT part of the Autonomous Database?
A. Flashback Database

B. Online Indexing
C. Real Application Clusters (RAC)

D. Java in the Database

Answer: D

12. 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?
A. 12c Release 2 onwards

B. Any version
C. 18.1 onwards
D. 17.4 onwards
Answer: C

13. Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction
Processing instance?
A. TPURGENT
B. TPPERFORMANT

C. MEDIUM
D. LOW
E. HIGH
Answer: B
14. Which is NOT required to connect to Autonomous Database from SQL developer?
A. Service name

B. Username and password

C. Wallet file
D. Database name
Answer: D

15. 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. cwallet.sso
C. ojdbc.properties
D. keystore.jks
E. sqlnet.ora
Answer: A

16. Which statement is true regarding database client credentials file required to connect to your
Autonomous Database?
A. the Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect
to your database.

B. Store credential files in a secure location and share the files only with authorized users to
prevent unauthorized access to the database.

C. When you share the credential files with authorized users, mail the wallet password and the file in
the same email.
D. Place the credential files on a share drive that all users can use to connect to the database.
Answer: B

17. How many predefined service names are configured in tnsnames.ora for a single Autonomous
Transaction Processing database instance, and what are they called?
A. None. There are no predefined service names in tnsnames.ora.

B. Three. They are called high, medium and low.

C. Two. They are called ATP and ADW.
D. Five. They are called tpurgent, tp, high, medium and low.
Answer: D

18. When you choose to scale your Autonomous Database, which statement is true in regards to
OCPUs and storage?
A. OCPUs and storage can be scaled independently.

B. Storage in TB cannot be larger than the number of OCPUs.

C. OCPUs and storage must remain in sync.
D. Increasing OCPUs will automatically increase storage.
Answer: A
19.Which can be Scaled independently of the number of CPUs in an Autonomous Database?
A. Concurrency

B. Sessions

C. Parallelism

D. Storage

E. Memory
Answer: D

20.What two tasks can be executed from the service console for Autonomous Databases?
A. Creating and scaling of Autonomous Database service.
B. Creating schemas.
C. Autonomous Databases monitoring for usage and query performance.
D. Wizard to download connection wallet for connection from desktop tools.
Answer: C, D

21. When scaling OCPUs in Autonomous Database, which statement is true in regards to active
transactions?
A. Active transactions are terminated and rolled back.
B. Active transactions are paused.
C. Scaling cannot happen while there are active transactions in the database.

D. Active transactions continue running unaffected.

Answer: D

22. Which two options are available to restore an Autonomous Data Warehouse?
A. Select the snapshot of the backup.
B. Select the archived redo logs.
C. Specify the point in time (timestamp) to restore
D. Select the backup from which restore needs to be done.
E. Backup and recovery must be done using Recovery Manager (RMAN).
Answer: C, D

23.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 an 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 cannot 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.
Answer: C
24. Which two statements are true when running DBMS_CLOUD.COPY_DATA?
A. valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA
procedure.

B. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the
Object Store.

C. The target table will be created in Autonomous Database if it does not already exist.
D. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA
procedure finishes successfully.

E. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob
storage.
Answer: A, E

25. In which way can a SQL Developer help you test your data loading scenario to Autonomous
Database (ADB)?
A. In the TEST phase, a temporary table will be populated with the records before inserting them
in the destination table.

B. In the TEST phase of the wizard, a subset of accepted records are displayed based on your
definition.

C. In the TEST phase of the wizard a list is generated containing the records that would be rejected
during import.

D. In the Column Definition Phase, the system cross-references with the file-contents and shows
the conflicts with the definition.
Answer: A

26. Which two statements are true with regards to Oracle Data Sync?
A. Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
B. Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server,
MySQL and Teradata.

C. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
D. Data Sync can load your data in parallel in order to speed up the loading process.
Answer: C, D

27. What are three methods to load data into the Autonomous Database?
A. SQL*Loader

B. Transportable Tablespace

C. Oracle Data Pump

D. RMAN Restore
E. Oracle GoldenGate
Answer: A, C, E

Managing Users in Autonomous Database

28. What predefined user is created when an Autonomous Database (ADB) instance is created that
you connect to in order to create other users and grant roles?
A. DWDEV

B. ADMIN
C. SYS
D. SCOTT
Answer: B

29. Which two methods can you use to create users and grant roles in Autonomous Database
services?
A. through SQLPIus

B. through SQL Developer

C. using DBMS_CLOUD_ADMIN package
D. through the Oracle Cloud Infrastructure service console
Answer: A, B

Machine Learning In Autonomous Database

30. When exporting a notebook, what type of file is created?

A. XML
B. SQL

C. ASCII
D. JSON
E. TXT
Answer: D

31. 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?
A. Run SQL Scripts
B. Create Notebooks
C. Create projects
D. Create workspaces
E. Create Oracle Machine Learning User
Answer: C, D

32. What two methods can you use to define Machine Learning Users?
A. Client tools

B. Oracle Cloud Infrastructure Console

C. SQL/Developer
D. Use DBMS_CLOUD_ADMIN package
Answer: A, C

Monitoring & Performance Autonomous Database

33. Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
A. Autonomous Data Warehouse
B. Both services ignore hints by default
C. Neither service ignores hints by default
D. Autonomous Transaction Processing
Answer: A

34. When running lots of high concurrent queries in Autonomous Database, you should use which
predefined service connection?
A. DBNAME_CONCURRENT
B. DBNAME_LOW

C. DBNAME_HIGH
D. DBNAME_MEDIUM
Answer: B

35. 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. UPDATE_OBJECT_INFO
D. CREATE_BASELINE_TEMPLATE
Answer: B

36. As a database architect you are tasked with configuring a high concurrency, production OLTP
application to connect to an Autonomous Transaction Processing database with a requirement to
have some reporting queries run in parallel mode. Which connection service is appropriate for such a
workload?
A. TP
B. TPURGENT

C. HIGH
C
D. MEDIUM
Answer: D

37. 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 statement
about these consumer groups is correct?
A. High provides highest resources, lowest concurrency, and DoP is 1.

B. Low provides highest concurrency, lowest resources, and DoP =1.

C. Medium provides intermediate resource and concurrency, and queries run in a serial.
D. High provides highest concurrency and lowest resources, and DoP is i.
Answer: D

Managing Autonomous Database Using REST API | CLI | Terraform

38.What REST verb is used to create an Autonomous Database service using REST APIs?
A. A "PUT" REST call

B. A "GET" REST call

C. A "POST" REST call
D. An "INSERT" REST call
Answer: C

39. Which is the correct subset of services offered via OCI-CLI (command line interface) for
Autonomous Database (ADB) via calls made to the OCI API's?
A. Start, Delete, Update, Query, Stop

B. Create, Query, Update, List, Start

C. Create, Query, List, Stop, Restore

D. Create, Get, List, Stop, Restore

Answer: D

40. How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud
Infrastructure console?
A. It cannot be done.
B. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
C. Using Database Configuration Assistant (DBCA) on the database server.
D. Connecting to the Cloud Infrastructure Command console via SSH wallet.
Answer: B
41. Which open source orchestration tool can be used to provision autonomous database resources in
Oracle Cloud Infrastructure?
A. REST API

B. Terraform
C. Enterprise Manager
D. Docker
Answer: B

Migrating Oracle Database To Autonomous Database

42. What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous
Database?
A. Data Pump is platform independent - it can migrate Oracle Databases running on any
platform.

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

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

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

43.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. The fallback scenario is not possible using Golden Gate because the capture-process cannot be
installed on ADB.

C. Golden Gate on premise Is not certified with ADB because Golden Gate Cloud Service exists for this.

D. The described scenario is correct, can be used for migration and fallback scenarios.
E. Only the migration to ADB is possible from an on-premise installation of Golden Gate.

Answer: B
44. Which method can be used to migrate on-premises databases to Autonomous Databases in
cloud?
A. RMAN backup & restore
B. Original Import/Export tools

C. Physical migration method like database cloning

D. Data Pump
Answer: D

45. 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 object/location,
running data-pump export and running a data-pump import. Which three statements are true for SQL
Developer (18.3 and up) in combination with ADB Data Loading?
A. SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps.
B. SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon
S3 Object storage.
C. SQL Developer can import .csv files into ADB which are located on the system where SQL Developer
is running.
D. SQL Developer can only export/move/import files using datapump from databases running on Linux
systems.

Answer: A,C,D

46. The 3rd party application that your customer wants to migrate to Autonomous Database (ADB)
has some specific demands like tablespace names, usernames and init.ora parameters. The decision
was made to adhere to the suggested migration method using an instant client and the data-pump
version that was suggested (and came with it). Which statement is true about the migration of the
application's database success?
A. The suggested data-pump version will create an alias for non-standard tablespace names so the
migration is successful.

B. The migration can be technically a success but the 3-rd party vendor needs to support the result.
C. The tablespace names will result in a blocking error during data-pump import because of ADB
limitations.

D. The migration can be a success, both technically and functional due to data-pump
enhancements.
Answer: A

47. Which statement about the Export Wizard used to export database objects and data is NOT correct?
A. Export DDL includes features such as "Show schema," "Storage," and "Terminator."

B. If "Clipboard" is selected as the "Output," the output will be placed on the system clipboard, so that
it can be pasted into a file, a command line, or other location appropriate for the format.
C. If "Dependents" is checked as a DDL Option, for non-privileged users, only dependent objects in
their schema are exported.
D. If "Grants" Is checked as a DDL Option, GRANT statements are Included for any grant objects
on the exported objects, including those owned by the SYS schema.
Answer: D

48. What are the two methods that could be used during the migration of your existing Oracle
database to Autonomous Database?
A. Recovery Manager (RMAN)
B. Data Pump
C. Golden Gate
D. CSV files copied to Autonomous Database block storage
Answer: B, C

49. 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 customer
unplug their database to migrate to Autonomous Database (ADB)?
A. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
B. Unplug to an xml file so database files and xml file can be uploaded to object storage.
C. Unplug into a pdb archive which can be uploaded to object storage.
D. Create a database link from the source database to the ADB environment and clone the PDB.
Answer: A

Autonomous Database For Experienced/Advanced Users

50. Which statement is true in regards to database links?

A. You can call PL/SQL procedures and functions using a database link.
B. Connect to Autonomous Database from remote database using a database link.

C. Create a database link from one Autonomous Database to another Autonomous Database
instance.
D. Connect from Autonomous Database to remote database using a database link.
Answer: B

51.Which three statements are true about procedures in the DBMS_CLOUD package?
A. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external
table, generates log information, and stores the rows that do not match the format options specified
for the external table in a bad file table on Autonomous Data Warehouse.

B. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the
Autonomous Data Warehouse.

C. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the

cloud. You can run queries on external data from the Autonomous Data Warehouse.
D. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the
Autonomous Data Warehouse database.

E. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the

Autonomous Data Warehouse database.
Answer:A, C, D

Autonomous Database Use Cases

52. Which two system privileges does a user need to create analytic views?
A. CREATE ANALYTIC LEVEL
B. CREATE ANALYTIC MEASURE
C. CREATE ANALYTIC HIERARCHY
D. CREATE ANALYTIC VIEW
E. CREATE ATTRIBUTE DIMENSION
Answer: D,E

53.Which operating system can Data Visualization Desktop be run on?

A. Linux

B. Solaris

C. Windows
D. AIX
Answer: C

54.Which two PL/SQL functions can be used to validate an analytic view?

A. VALIDATE_HIERARCHY

B. VALIDATE_LEVELS
C. VALIDATE_ANALYTIC_VIEW
D. VALIDATE_DIMENSION
E. VALIDATE_MEASURES
Answer: A, C

55. Which three data dictionary views contain information about analytic view objects?
A. ALL_ANALYTIC_VIEW_ID_ATTRS

B. ALL_ANALYTIC_VIEW_KEYS
C. ALL_ANALYTIC_VIEW_LVLGRPS
D. ALL_ANALYTIC_VIEW_PATHS
E. ALL_ANALYTIC_VIEW_DIM_CLASS
Answer: BCE

56. When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to
be uploaded?
A. OJDBC.PROPERTIES
B. CWALLET.SSO
C. TNSNAMES.ORA
D. SQLNET.ORA
Answer: B
57. Once you have a connection to the Autonomous Data Warehouse, how do you import tables into
the Oracle Analytics Cloud (OAC)?
A. Load data using Data Pump

B. Create a Data Set

C. Import Table
D. Replicate the table using Golden Gate
Answer: B

58.Which two actions should you perform before you turn over the cluster for production? (Choose
two.)
A . Remove cables connected to the controller until you find the one responsible for the controller
issue.
B . Review AutoSupport messages which could explain the controller state.
C . Execute Config Advisor again to check for new errors.
D . Let the customer know the cluster is operating normally while the amber LED is on.
Answer : A, C

Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?
A . In addition to the Oracle Client Credential Wallet, a user must have a username and password in
order to connect to the Autonomous Database.
B . The Oracle Client Credential file is downloaded as a ZIP file.
C . The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE)
wallet.
D . You MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database.
Ans:A

59.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.
Answer A, C

60.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.
Answer B, C, D

61. what is the default port number for Oracle Autonomous Database?
A.1521
B.1522
C.1525
D.1526
Ans: B

62.How many days is the default retention period for ADB backup?
A. One Year
B. 7 days
C. 60 days
D. 30 days
E. 90 days

Ans:C

63. Data Loading using DBMS_CLOUD package?

A. COPY_DATA
B. LOAD_DATA
C. LOAD_EXTERNAL_DATA
Ans: A