1z0-931-25 Free Practice Test

Which three options do NOT change when enabling auto scaling? (Choose three.)

1. A. Amount of storage
2. B. Parallelism settings
3. C. I/O resources
4. D. Number of OCPUs displayed in the console
5. E. Level of concurrency

Correct Answer: ABE

Which option should you use to create a graph with Graph Studio?

1. A. Tables in an Autonomous Database instance
2. B. Graph analytics algorithms
3. C. NoSQL configuration
4. D. Graph created by a special tool downloaded from oracle.com
5. E. A graph license key

Correct Answer: A

You want to enable automatic indexing in a database, but any new auto indexes should be created as invisible indexes, so that they cannot be used in SQL statements. Which command will you use?

1. A. EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','IMPLEMENT')
2. B. EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','OFF')
3. C. EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','REPORT ONLY')
4. D. EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','INVISIBLE')

Correct Answer: C

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure Console?

1. A. Using the DBCA on the database server
2. B. Connecting to the cloud infrastructure console using the SSH wallet
3. C. It cannot be done
4. D. Using the cloud infrastructure command line interface or REST API calls

Correct Answer: D

Which predefined service connection should you use when running lots of high concurrent queries in an Autonomous Database?

1. A. DBNAME_LOW
2. B. DBNAME_MEDIUM
3. C. DBNAME_HIGH
4. D. DBNAME_CONCURRENT

Correct Answer: A