Practice Questions

Which service is used to load data from Object Storage into Autonomous Database?

A. DBMS_SQL B. DBMS_CLOUD C. DBMS_DATA D. DBMS_LOAD

What type of encryption is enabled by default in Autonomous Database?

A. Manual encryption B. Transparent Data Encryption (TDE) C. SSL encryption only D. No encryption

Which feature automatically creates and manages indexes?

A. Auto Scaling B. C. D. Answer: B. Automatic Indexing C. SQL Plan Baselines D. AWR

What is the primary purpose of OCI Compartments?

A. Data storage B. Network isolation C. Resource organization and access control D. Backup management

Which tool provides performance insights and workload analysis?

A. SQL Loader B. Performance Hub C. Data Pump D. RMAN

What happens when auto-scaling is enabled?

A. Storage decreases automatically B. CPU resources adjust based on workload C. Database shuts down during low usage D. Manual intervention is required