Free Oracle 1Z0-931-25 Practice Test & Real Exam Questions, Page 5

Question #57

Which statement is FALSE regarding provisioning an Autonomous Database and configuring private endpoints with security rules to allow incoming and outgoing traffic to and from the Autonomous Database instance?

A. The source is set to the address range you want to allow to connect to your database

B. The IP Protocol is set to TCP

C. A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance

D. The destination port range is set to 1522

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #58

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

A. HIGH

B. TPURGENT

C. MEDIUM

D. TPPERFORMANT

E. LOW

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #59

Which management operation is correct about Autonomous Databases on Shared Exadata Infrastructure?

A. You can choose to use Release Update or Release Update Revision updates for your Autonomous Databases on Shared Infrastructure

B. You cannot configure the scheduling for your Autonomous Databases on Shared Exadata Infrastructure

C. You can skip a scheduled maintenance run. For Autonomous Database on Shared Exadata Infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed

D. You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node on the Autonomous Database is restarted separately while the remaining nodes continue to be available

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #60

Which terminology is used to refer to a communication channel for sending messages to a subscription, such as email or SMS, in Oracle Cloud Infrastructure?

A. Topic

B. Event

C. Notification

D. Subject

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #61

Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?

A. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates) and includes container database patching.

B. If a scheduled container database maintenance run cannot take place, Oracle automatically reschedules the container database maintenance for the following quarter.

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.

D. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #62

Which method does NOT permit you to change the database ADMIN user's password of an Oracle Autonomous Database on Shared Infrastructure?

A. SQL Developer

B. OS command line from the database server

C. OCI CLI

D. Admin page of the Cloud Service Console

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #63

Which statement is correct about the Service Console in an Autonomous Database?

A. You can use the Service Console to create manual backups of an Autonomous Database.

B. You can use the Service Console to manage runaway SQL statements on an Autonomous Database.

C. You can use the Service Console to move an Autonomous Database between compartments.

D. You can use the Service Console to enable or disable auto-scaling of an Autonomous Database.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #64

Which three advanced options can you enable or disable while creating a business model? (Choose three.)

A. Analytic View Base Table Query Transformation

B. Autonomous Aggregate Cache

C. Business Object Security Feature

D. Analytic View Transparency View

E. Display private tables

Discussion 0

Correct Answer: A,B,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #65

What is the correct way to list all files in the default data pump directory?

A. By executing SELECT * FROM DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');

B. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW)

C. By executing SELECT * FROM UTL_FILE.LIST('DATA_PUMP_DIR');

D. Log onto ADW server and issue ls -al on the command line

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #66

In which four ways can Oracle Database optimally access data in Object Storage? (Choose four.)

A. Scan avoidance using partitioned external tables

B. Scan avoidance using columnar pruning for columnar stores like parquet and orc

C. Optimized data archive using hybrid partitioned tables

D. Scan avoidance using columnar pruning for .csv files

E. Scan avoidance using block skipping when reading parquet and orc files

F. Optimized data archive using partitioned external tables

Discussion 0

Correct Answer: A,B,C,F Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #67

What is the difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?

A. Only ATP supports automatic backups.

B. Only ATP manages optimizer statistics.

C. Only ADW uses columnar compression by default.

D. Only ADW supports autoscaling

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #68

Which three functions are provided by Spatial Studio? (Choose three.)

A. Custom SQL queries

B. Spatial data editing

C. Map visualization

D. Geocoding

E. Spatial analysis

Discussion 0

Correct Answer: B,C,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #69

What is a best practice when planning and instituting access controls for your Autonomous Dedicated environment regarding subnets, compartments, and user groups?

A. Create at least 2 of each resource.

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 a separate VCN that contains only public subnets.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #70

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 be set up for an IP Address or a virtual cloud network but not both at the same time

C. ACLs can only be used with private endpoints

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

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Free Oracle 1Z0-931-25 Practice Test & Real Exam Questions

Download Free Oracle 1Z0-931-25 Demo