Oracle Oracle Certifications 1Z0-931-21 Questions & Answers

• Question 51:

  Autonomous Database's auto scaling feature allowsyour database to use up to three times the current base number of CPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use.

  Which statement is FALSE regarding the auto scaling feature?

  A. For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meethigh-load demands.

  B. The base number of OCPU cores allocated to a database is not guaranteed.

  C. For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.

  D. Auto scaling is enabled by default and can be enabled or disabled at any time.

  Correct Answer: B

• Question 52:

  You are the admin user of an Autonomous Database (ADB) instance. A new business analysthas 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.

  Correct Answer: A

  https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect- databaseactions.html#GUID-55BA432E-098A-48ED-B2EA-F2960A9EF586

• Question 53:

  Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

  A. Parallelism is not enabled by default.

  B. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.

  C. Oracle Database Result Cache is enabled by default for all SQL statements.

  D. You have direct access tothe database node.

  Correct Answer: BC

  https://docs.oracle.com/en/cloud/paas/autonomous- database/adbsa/appendix-autonomous-database-data-warehouse-workload.html#GUID- 604A08F8-8021-43CE-AA95-823045E14BD8

  

• Question 54:

  Which two methods canyou use to create database users and grant roles in Autonomous Database services? O the Oracle Cloud Infrastructure A. service console

  A. SQL Developer

  B. the DBMS_CLOUD_ADMIN package

  C. SQL *Plus

  Correct Answer: B

• Question 55:

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

  A. through the Oracle Cloud Infrastructure service console

  B. through SQL/Developer s

  C. using DBMS_CLOUD_ADMIN package

  D. through SQLPIus

  Correct Answer: BD

  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/connectsqlplus.html#GUID-A3005A6E-9ECF-40CB-8EFC-D1CFF664EC5A

  https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect- sqldev.html#GUID-FB611317-2999-4C8C-8A3B-B3B3D3C5B417

  https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms- cloudadmin.html#GUID-D76B229E-781E-45C0-9F14-CAF30F9E6E3B

  "To create users in your database, connectto the database as the ADMIN user using any SQL client tool."https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse- cloud/user/manage-userscreate.html#GUID-54CA837B-CD6A-4ED2-A960- 5874535818CB

• Question 56:

  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. is-dedicated

  C. db-type

  D. license-model

  Correct Answer: B

  https://docs.oracle.com/en-us/iaas/tools/oci- cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html

• Question 57:

  What is the default port number for accessing a newly created Autonomous Database?

  A. 1524

  B. 1522

  C. 1521

  D. 1523

  E. 1526

  Correct Answer: B

  https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf

• Question 58:

  According to Oracle documentation, it is a best practice whenplanning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups.

  Which statement is true?

  A. Create a separate VCN that contains only public subnets

  B. Only 1 of each is allowed to be allocated per environment.

  C. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.

  D. Create at least 2 of each resource

  Correct Answer: D

  Refer to Best Practices When Planning and Instituting Access Controls section in the https:// docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/plan-and- create-accessconstraints1.html#GUID-ED48C3D3-FC0F-41D5-882A-FC2D916FD6AA https://docs.oracle.com/en/cloud/ paas/autonomous-database/atpfg/plan-and-create- accessconstraints1.Html

  

• Question 59:

  Which three options are available to access data in an Autonomous JSONDatabase?

  A. Oracle Cloud Infrastructure console using the JSON Online Developer tool

  B. Oracle JSON Developer tool downloaded from OTN

  C. NOSQL statements using Oracle SODA drivers

  D. REST API calls to the database (not enabled by default)

  E. Regular Oracle SQL statements using a connection through the listener

  Correct Answer: ACD

• Question 60:

  Whenyou are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?

  A. 2 hours

  B. 30 minutes

  C. 1 hours

  D. 24 hours

  Correct Answer: A

  Clone Sources You can use a running database to create a clone. For databases running on shared Exadata infrastructure, you can also use a backup as the source of your clone. When using a backup, you can select a listed backup to clone from, or create a point-in-time clone. Point-in-time clones contain all data up to a specified timestamp. The specified timestamp must be in the past. NoteWhen you create a clone from a backup, you must select a backup that is at least two hours old. https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbcloning.htm