OCI Architect Associate (1Z0-1072) Database Questions And Answers.

DB 1. Which three types of database systems are available in Oracle Cloud Infrastructure (OCI)? (Choose three) (Choose all correct answers) 1) Bare metal DB systems 2) Exadata DB System 3) Autonomous Data Warehouse 4) Autonomous Transaction Processing 5) VM DB System - Answer-1) Bare metal DB systems 2) Exadata DB System 5) VM DB System DB 2. Which two actions can be performed from the OCI Console for an Oracle Autonomous Database? (Choose two) (Choose all correct answers) 1) Increase network bandwidth 2) Increase storage allocated for database 3) Scale up/down CPU 4) Scale up/down Memory - Answer-2) Increase storage allocated for database 3) Scale up/down CPU DB 3. Which statements are true about Autonomous Transaction Processing? (Choose two) (Choose all correct answers) 1) Missing indexes are detected and created.2) Data is stored in columnar format. 3) Complex SQL queries are optimized. 4) Data is stored in row format. - Answer-1) Missing indexes are detected and created. 4) Data is stored in row format. DB 4. Which three are required for provisioning an Oracle Autonomous Database instance? (Choose three) (Choose all correct answers) 1) Workload Type 2) Number of CPUs 3) Database Name 4) Number of Tablespaces 5) Backup Location FRA Size - Answer-1) Workload Type 3) Database Name DB 5. Which statement is true about Autonomous Data Warehouse? 1) Data is stored in row format. 2) Response time is optimized for queries. 3) Data is stored in columnar format. 4) Missing indexes are detected and created. - Answer-2) Response time is optimized for queries. 3) Data is stored in columnar format. DB 6. Which two are the minimum prerequisites to create a DB system? (Choose two) (Choose all correct answers) 1) Virtual Cloud Network with default service gateway 2) Private key in OpenSSH format 3) Public key in OpenSSH format4) Dynamic Routing Gateway 5) Oracle Database Software Edition must be Enterprise Edition - Extreme Performance 6) Virtual Cloud Network with default security list - Answer-3) Public key in OpenSSH format 6) Virtual Cloud Network with default security list