1Z0-931-21 Online Practice Questions and Answers

While creating a business model what advanced options you can enable or disable? (Choose three)

A. Business Object Security Feature

B. Analytic View Transparency View

C. Autonomous Aggregate Cache

D. Display private tables

E. Analytic View Base Table Query Transformation

Which can be Scaled Independently of the number of CPUs In an Autonomous Database?

A. Parallelism

B. Storage

C. Concurency

D. Memory

E. Sessions

Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?

A. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule thecontainer database maintenance for the following quarter.

B. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is

mandatory.

C. You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.

D. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of theExadata grid infrastructure code and operating systems updates), and include database patching.

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

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.

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 name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator

B. the Client Credentials wallet which is used to connect to the Autonomous Database

C. the 'High Availability Container Database' in which the Autonomous instance should run

D. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment

E. the Listener endpoint where the Autonomous Database should register on

What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

A. Users have OS access to the database machine.

B. Users can customize the maintenance schedule.

C. It offers greater control and isolation starting at theExadata cloud infrastructure level.

D. Users have SYS privileges in the database.

E. Users can customize the OS stack and add additional packages

Which statement is true about the use of Access Control Lists (ACLS) with an Autonomous Database on Shared Infrastructure?

A. When you restore a database, the existing ACLs are not overwritten by the restore.

B. An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.

C. ACLs can only be used with private endpoints.

D. An ACL can be set up for an IP address or a virtual cloud network (VCN) but not both at the same time.

How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?

A. Execute alter database for user MTHEO tablespace DATA quota = 10G;

B. Execute alter user MTHEO quota unlimited on tablespace DATA;

C. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);

D. Execute alter tablespace DATA setquota = 10G;

Which is NOT needed to manage Oracle Autonomous Database with REST APIS?

A. User's OCID

B. Tenancy's OCID

C. Database ADMIN password

D. Fingerprint of the public key