Question 1

Which application lifecycle phase could be managed reactively?

Options :

A : Design and development

B : Upgrade or migration

C : Testing

D : Production

E : Deployment

Answer: D

Question 2

Which feature of Oracle Database 19c can be used to maximize query performance by automatically creating and maintaining optimal indexes?

Options :

A : Table Compression

B : Query Rewrite

C : Real Application Testing

D : Automatic Indexing

Answer: D

Question 3

Which of the following is a best practice for index management and tuning in Oracle Database 19c?

Options :

A : Regularly rebuild all indexes to improve performance.

B : Use a higher PCTFREE value to reduce the frequency of index block splits.

C : Use index-organized tables (IOTs) for small lookup tables with few updates.

D : Create bitmap indexes on large tables with low cardinality columns.

Answer: C

Question 4

Which of the following is a benefit of using Automatic Storage Management (ASM) in Oracle Database 19c?

Options :

A : Simplified storage management through automated data striping and rebalancing.

B : Improved database performance through faster I/O operations.

C : Enhanced data availability through redundancy and mirroring.

D : Reduced storage costs through compression and tiering.

Answer: A

Question 5

Which of the following is the best practice when creating indexes in Oracle Database?

Options :

A : Create indexes on all columns of a table.

B : Create indexes on frequently queried columns.

C : Create indexes on columns with high cardinality.

D : Create indexes on all columns used in join conditions.

Answer: B