Updated Sep-2021 Test Engine or PDF for the Oracle 1Z0-931-20 test to help you quickly prepare for the Oracle exam!
Full 1Z0-931-20 Practice Test and 118 unique questions with explanations waiting just for you, get it now!
NEW QUESTION 16
You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:
* Autonomous Transaction Processing
* License Included
* Shared Infrastructure
Which parameter would you NOT use?
- A. db-workload
- B. db-type
- C. license-model
- D. is-dedicated
Answer: D
NEW QUESTION 17
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?
- A. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
- B. It cannot be done.
- C. Connecting to the Cloud Infrastructure Command console via SSH wallet.
- D. Using Database Configuration Assistant (DBCA) on the database server.
Answer: A
Explanation:
The CLI is a small footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure tasks. The CLI provides the same core functionality as the Console, plus additional commands.
https://blogs.oracle.com/datawarehousing/managing-autonomous-data-warehouse-using-oci-curl Examples of using Autonomous Database managing by REST API
https://oracle.github.io/learning-library/workshops/autonomous-transaction-processing/LabGuide900ConfigureOCI-CLI.md
NEW QUESTION 18
You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service.
The load on the database increases from three OCPUs to nine OCPUs. What is the total number of concurrent statements that the TPURGENT service can support?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
NEW QUESTION 19
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 20
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. ojdbc.properties
- B. keystore.jks
- C. sqlnet.ora
- D. tnsnames.ora
- E. cwallet.sso
Answer: C,D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect- preparing.html#GUID-EFAFA00E-54CC-47C7-8C71-E7868279EF3B
NEW QUESTION 21
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 22
To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?
- A. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB
- B. Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB
- C. Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB
- D. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure
Answer: C
NEW QUESTION 23
What are two security features enabled by default by the Autonomous Database? (Choose two.)
- A. Encrypted Database Links
- B. One SYSDBA account
- C. SQL Net Encryption
- D. Transparent Data Encryption
- E. Read Only access to OS Audit logs
Answer: A,D
Explanation:
https://juliandontcheff.wordpress.com/category/cloud/
NEW QUESTION 24
What is the correct way to list all files in the default data pump directory?
- A. Log onto ADW server and issue is -al on the command line.
- B. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
- C. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
- D. By executing select * from utl_file . list ( 'DATA_PUMP_DIR ' ) ;
Answer: B
NEW QUESTION 25
For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?
- A. SQLDEV_ADMIN.GRANT_SCHEMA
- B. ORDS_PRIV.ENABLE_SCHEMA
- C. ORDS_ADMIN.ENABLE_SCHEMA
- D. ORDS_ADMIN.GRANT_SCHEMA
Answer: D
NEW QUESTION 26
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?
- A. alter system set application_continuity=true
- B. alter session set application_continuity=true
- C. exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ;
- D. alter database set application_continuity=true
Answer: A
NEW QUESTION 27
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?
- A. Autonomous Transaction Processing only
- B. ATP and ADW
- C. Autonomous Data Warehouse only
- D. Hybrid Columnar compression
Answer: C
NEW QUESTION 28
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 29
Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)
- A. A single fault domain can be associated with multiple regions and availability domains.
- B. 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.
- C. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.
- D. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.
Answer: B,C
Explanation:
A region is a localized geographic area, and an availability domain is one or more data centers located within a region.
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.
Oracle Cloud Infrastructure is hosted in regions and availability domains. A region is a localized geographic area. And an availability domain is one or more data centers located within a region. Our region is composed of one or more available domains. Most cloud infrastructure resources are either region-specific, such as virtual cloud networks, or availability-domain-specific, such as compute instance.
Traffic between availability domains and between regions is encrypted. Availability domains are isolated from each other, fault tolerant, and very unlikely to fail simultaneously. Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one domain within a region is unlikely to impact the availability of the others within the same region.
https://docs.cloud.oracle.com/iaas/Content/General/Concepts/regions.htm
NEW QUESTION 30
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?
- A. Active Data Guard
- B. RAC, but only when scaling beyond 16 OCPUs
- C. Transparent Data Encryption
- D. Multitenant
- E. Exadata
Answer: A,B
NEW QUESTION 31
......
Full 1Z0-931-20 Practice Test and 118 unique questions with explanations waiting just for you, get it now: https://www.fast2test.com/1Z0-931-20-premium-file.html