1z0-931-25 Oracle Exam Questions and Free Practice Test

Question 31

Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

A. Autonomous Transaction Processing only

B. Hybrid Columnar Compression

C. ATP and ADW

D. Autonomous Data Warehouse only

Correct Answer:C

Question 32

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

A. 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.

B. 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.

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

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

Correct Answer:B

Question 33

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 .csv files

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

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

E. Optimized data archive using hybrid partitioned tables

F. Optimized data archive using partitioned external tables

Correct Answer:ADEF

Question 34

Which is a feature of a graph query language?

A. Run key-value queries

B. Scripting language

C. Object-oriented language

D. Ability to specify patterns

Correct Answer:D

Question 35

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

A. Map visualization

B. Custom SQL queries

C. Spatial analysis

D. Geocoding

E. Spatial data editing

Correct Answer:ACE

Question 36

Which stage of the indexing pipeline divides text into tokens?

A. Sectioner

B. Tokenizer

C. Filter

D. Lexer

Correct Answer:D

START 1z0-931-25 EXAM