• Home
  • Blogs
  • [Sep-2021] Updated Oracle Cloud 1Z0-931-20 Exam Questions BUNDLE PACK [Q26-Q51]

[Sep-2021] Updated Oracle Cloud 1Z0-931-20 Exam Questions BUNDLE PACK [Q26-Q51]

Share

[Sep-2021] Updated Oracle Cloud 1Z0-931-20 Exam Questions BUNDLE PACK

Master The Oracle Content 1Z0-931-20 EXAM DUMPS WITH GUARANTEED SUCCESS!

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

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

Answer: D,E

 

NEW QUESTION 27
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? (Choose two.)

  • A. Create projects
  • B. Run SQL Scripts
  • C. Create workspaces
  • D. Create Notebooks
  • E. Create Oracle Machine Learning User

Answer: C,E

Explanation:

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/omlug/get-started-oracle-machine-learning.html#GUID-13452045-6AF6-402B-83CC-C9AFBCEC30CA

 

NEW QUESTION 28
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. None. There are no pre-defined service names in tnsnames.ora.
  • B. Two. They are called ATP and ADW.
  • C. Three. They are called high, medium and low.
  • D. Five. They are called tpurgent, tp, high, medium and low.

Answer: D

Explanation:
The tnsnames.ora file provided with the credentials zip file contains five database service names identifiable as tpurgent, tp, high, medium, and low. The predefined service names provide different levels of performance and concurrency for Autonomous Transaction Processing.
tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
tp: A typical application connection service for transaction processing operations. This connection service does not run with parallelism.
high: A high priority application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.
medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4).
low: A lowest priority application connection service for reporting or batch processing operations. This connection service does not run with parallelism.
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#ATP

 

NEW QUESTION 29
Which statement is NOT correct when setting up compartment quotas?

  • A. Compartment quotas are set by Oracle.
  • B. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
  • C. There are three types of quota policy statements which are set, unset and zero.
  • D. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.

Answer: B

 

NEW QUESTION 30
You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web.
What steps do you need to take?

  • A. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
  • B. Create a database user with the default privileges.
  • C. Create a database user with connect, resource, and object privileges.
  • D. Create an IDCS user. Create a database user with connect, resource, and object privileges.

Answer: A

 

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

  • A. HIGH
  • B. TPPERFORMANT
  • C. MEDIUM
  • D. TPURGENT
  • E. LOW

Answer: B

Explanation:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-
44F1-8FF8-F5AC650F15BE

 

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

  • A. HIGH
  • B. TPPERFORMANT
  • C. MEDIUM
  • D. TPURGENT
  • E. LOW

Answer: B

Explanation:
Predefined Database Service Names for Autonomous Transaction Processing The tnsnames.ora file provided with the credentials zip file contains five database service names identifiable as tpurgent, tp, high, medium, and low. The predefined service names provide different levels of performance and concurrency for Autonomous Transaction Processing.
* tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
* tp: A typical application connection service for transaction processing operations. This connection service does not run with parallelism.
* high: A high priority application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.
* medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4).
* low: A lowest priority application connection service for reporting or batch processing operations. This connection service does not run with parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7

 

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

  • A. Oracle Cloud Infrastructure Console
  • B. Use DBMS_CLOUD_ADMIN package
  • C. SQL/Developer
  • D. Client tools

Answer: C,D

Explanation:
Initially, the Role field shows the role None for existing database users. After adding a user the role Developer is assigned to the user.
Use SQL Dev or Client tools
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-oml.html#GUID-D928B760-513A-4C6D-9EB7-DF992249A26D

 

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

  • A. CREATE ANALYTIC MEASURE
  • B. CREATE ANALYTIC VIEW
  • C. CREATE ATTRIBUTE DIMENSION
  • D. CREATE ANALYTIC LEVEL
  • E. CREATE ANALYTIC HIERARCHY

Answer: B,C

Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-privileges.html
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dwhsg/overview-analytic-views.html#GUID-6F948948-6AE6-4A89-8AAC-5B8952CEF41D

 

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

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

Answer: A,C,D

Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-stop.html#GUID-9AF677F3-027A-43FD-B018-9F4A42D5CDE9

 

NEW QUESTION 36
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. SYS
  • C. ADMIN
  • D. SCOTT

Answer: C

Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users- privileges.html#GUID-50450FAD-9769-4CF7-B0D1-EC14B465B873

 

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

  • A. CREATE ANALYTIC MEASURE
  • B. CREATE ANALYTIC VIEW
  • C. CREATE ATTRIBUTE DIMENSION
  • D. CREATE ANALYTIC LEVEL
  • E. CREATE ANALYTIC HIERARCHY

Answer: B,C

Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-views.html#GUID-6F948948-6AE6-4A89-8AAC-5B8952CEF41D

 

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

  • A. using DBMS_CLOUD_ADMIN package
  • B. through the Oracle Cloud Infrastructure service console
  • C. through SQLPIus
  • D. through SQL/Developer s

Answer: C,D

Explanation:
https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-warehouse-adw-create-service
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqlplus.html#GUID-A3005A6E-9ECF-40CB-8EFC-D1CFF664EC5A
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sql-dev.html#GUID-FB611317-2999-4C8C-8A3B-B3B3D3C5B417
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud-admin.html#GUID-D76B229E-781E-45C0-9F14-CAF30F9E6E3B

 

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

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

Answer: A

Explanation:
When you download the client credentials from the Download Wallet dialog, you must enter a wallet password in the password field and confirm the password in the confirm password field. The password must be at least eight characters long and must include at least one letter and one numeric character or one special character. This password protects the download client credentials wallet. This wallet is not the same as the transparent data encryption wallet for the database. Therefore, a different password is used to protect the client credentials wallet.

 

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

  • A. 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.
  • B. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
  • C. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
  • D. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
  • E. 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 badfile table on Autonomous Data Warehouse.

Answer: A,C,E

Explanation:
DELETE_FILE Procedure
This procedure removes the specified file from the specified directory on Autonomous Data Warehouse.
CREATE_CREDENTIAL Procedure
This procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database. Use stored credentials for data loading or for querying external data residing in the Cloud.
PUTJDBJECT Procedure
This procedure copies a file from Autonomous Data Warehouse to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB).
VALIDATE EXTERNAL TABLE Procedure
This 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 badfile table on Autonomous Data Warehouse.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Data Warehouse.
To use Data Pump from ADB, a credential identifying the Object Storage bucket to use must be defined with a DBMS_CLOUD.CREATE_CREDENTIAL function. This will allow ADB to access objects that are stored in the object store , including dump files. To export an existing database to prepare for import into ADB, use the XTP command and add the ex elude option for database functionality that is not recommended or supported in ADB. This will prevent errors during the imp oil process.
This process is not automatic. And if the logs are not moved, you will receive a warning when running the MDB that the logs are not there. In this example, we're moving the log import.log to object store with a DBMS_CLOUD.PUT_OBJECT command.
VALIDATE_EXTERNAL_TABLE Procedure
This 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 badfile table on Autonomous Database. The overloaded form enables you to use the operation_id parameter.
PUT_OBJECT Procedure
This procedure copies a file from Autonomous Database to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB) DELETE FILE Procedure This procedure removes the specified file from the specified directory on Autonomous Database.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Database.

 

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

  • A. TNSNAMES.ORA
  • B. SQLNET.ORA
  • C. CWALLET.SSO
  • D. OJDBC.PROPERTIES

Answer: C

Explanation:
Create the Autonomous Data Warehouse Connection in Oracle Analytics Cloud.
- Sign in to Oracle Analytics Cloud.
- On the Home page, click Connect to Oracle Autonomous Data Warehouse.
- In Create Connection, enter a Connection Name, for example, MyADW_connection.
- In Description, enter a brief description.
- Click Select next to Client Credentials. In File Upload, select the wallet zip file from your download location. The Client Credentials field is populated with cwallet.sso, and the Service Name field contains a value.
- Enter your Oracle Autonomous Data Warehouse Username and Password.
- From the Service list, select the service for your data, and then click Save.
https://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/oac_ee_dv/create_adwc_connection/html/index.html

 

NEW QUESTION 42
During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?

  • A. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment
  • B. the Listener endpoint where the Autonomous Database should register on
  • C. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator
  • D. the 'High Availability Container Database' in which the Autonomous instance should run
  • E. the Client Credentials wallet which is used to connect to the Autonomous Database

Answer: E

 

NEW QUESTION 43
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. None. There are no pre-defined service names in tnsnames.ora.
  • B. Two. They are called ATP and ADW.
  • C. Three. They are called high, medium and low.
  • D. Five. They are called tpurgent, tp, high, medium and low.

Answer: D

Explanation:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-
44F1-8FF8-F5AC650F15BE

 

NEW QUESTION 44
Which three data dictionary views contain information about analytic view objects?

  • A. ALL_ANALYTIC_VIEW_PATH
  • B. ALL_ANALYTIC_VIEW_LVLGRPS
  • C. ALL_ANALYTIC VIEW_ID _ATTRS
    https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-views.html#GUID-FC745EA1-721D-48E3-96D1-B4DE1758AFF8
  • D. ALL_ANALYTIC_VIEW_DIM_CLASS
  • E. ALL_ANALYTIC_VIEW_KEYS

Answer: B,D,E

 

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

  • A. Data Redaction and TDE are both supported.
  • B. Neither Data Redaction nor TDE are supported.
  • C. TDE but not Data Redaction.
  • D. Data Redaction but not TDE.

Answer: A

Explanation:
All data is encrypted at rest using transparent data encryption, and data redaction is part of ADB.
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html

 

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

  • A. HIGH
  • B. TPPERFORMANT
  • C. MEDIUM
  • D. TPURGENT
  • E. LOW

Answer: B

Explanation:
Predefined Database Service Names for Autonomous Transaction Processing The tnsnames.ora file provided with the credentials zip file contains five database service names identifiable as tpurgent, tp, high, medium, and low. The predefined service names provide different levels of performance and concurrency for Autonomous Transaction Processing.
* tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
* tp: A typical application connection service for transaction processing operations. This connection service does not run with parallelism.
* high: A high priority application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.
* medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4).
* low: A lowest priority application connection service for reporting or batch processing operations. This connection service does not run with parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7

 

NEW QUESTION 47
On what infrastructure does the Autonomous Database run on?

  • A. Any Oracle Engineered system
  • B. VM on Oracle Cloud Infrastructure
  • C. Bare-metal on Oracle Cloud Infrastructure
  • D. Exadata on Oracle Cloud Infrastructure

Answer: B

 

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

  • A. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType =
    'OLTP'
  • B. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType =
    `DW'
  • C. Allow group ADB-Admins to manage autonomous-database-family in tenancy.
  • D. Allow group ADB-Admins to manage autonomous-database in tenancy.

Answer: A

 

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

  • A. Neither service ignores hints by default.
  • B. Both services ignore hints by default.
  • C. Autonomous Data Warehouse.
  • D. Autonomous Transaction Processing.

Answer: C

Explanation:
http://blog.umairmansoob.com/tag/oracle-autonomous-data-warehouse/

 

NEW QUESTION 50
Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)

  • A. VALIDATE_LEVELS
  • B. VALIDATE_MEASURES
  • C. VALIDATE_DIMENSION
  • D. VALIDATE_ANALYTIC_VIEW
  • E. VALIDATE_HIERARCHY

Answer: D,E

Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/18/dwhsg/overview-analytic-views.html#GUID-6F948948-6AE6-4A89-8AAC-5B8952CEF41D

 

NEW QUESTION 51
......

Pass Oracle 1Z0-931-20 Exam – Experts Are Here To Help You: https://www.test4sure.com/1Z0-931-20-pass4sure-vce.html

Related Blogs

more
Oracle 1Z0-931-20 Certification Practice Exam

Copyright © 2026 TEST4SURE.COM. All rights reserved. All trademarks are the property of their respective owners and we don't provide actual questions from any vendor.