Autonomous Database Exam Questions with Correct Answers
Question 1:
What is the OCI Database Service?
Answer:
1. A mission critical, enterprise grade cloud database service with comprehensive offerings to
cover all enterprise database needs. (Exadata, RAC, Bare Metal, VM)
Complete Lifecycle Automation (Provisioning, Patching, Backup & Restore)
High Availability and Scalability (RAC & Data Guard, Dynamic CPU and Storage scaling) Security
(Infrastructure
OCI Platform Integration
Question 2:
The Oracle Autonomous Database consists of which two elements?
Answer:
1. Autonomous Data Warehouse
Question 3:
2. Autonomous Transaction Processing
What is Autonomous Data Warehouse best for?
Answer:
Best for all analytic workloads such as data warehouse, data marts, data lakes, or machine
learning
Question 4:
What is Autonomous Transaction Processing best used for?
Answer:
Best for Transaction Processing and mixed workloads. Ex: Transactions, Batch, Reporting, IoT,
Application Dev, Machine Learning
Question 5:
T/F: Oracle automates end-to-end management of the data warehouse
Answer:
True
, Question 6:
What does the Autonomous Data Warehouse handle?
Answer:
1. Provisioning new databases Growing/shrinking storage and/or compute Patching and
upgrades
Backup and Recovery
Question 7:
T/F: The Full lifecycle is managed using the service console, but alternatively it can be managed
via command-line interface or REST API
Answer:
True
Question 8:
T/F: Autonomous Data Warehouse requires some tuning
Answer:
False; no tuning required
Question 9:
T/F: Autonomous Data Warehouse is designed as a "load and go" service: you start the service;
define tables, load data and then run queries
Answer:
True
Question 10:
T/F: Autonomous Database Warehouse required someone with special database expertise False
T/F: You do not need to consider any details about parallelism, partitioning, indexing, or
compression. The service automatically configures the database for high performance queries
True Fill in the blank: Autonomous Data Warehouse is a completely
Answer:
service elastic
Question 11:
T/F: When you get started with Autonomous Data Warehouse, simply specify the number of
Question 1:
What is the OCI Database Service?
Answer:
1. A mission critical, enterprise grade cloud database service with comprehensive offerings to
cover all enterprise database needs. (Exadata, RAC, Bare Metal, VM)
Complete Lifecycle Automation (Provisioning, Patching, Backup & Restore)
High Availability and Scalability (RAC & Data Guard, Dynamic CPU and Storage scaling) Security
(Infrastructure
OCI Platform Integration
Question 2:
The Oracle Autonomous Database consists of which two elements?
Answer:
1. Autonomous Data Warehouse
Question 3:
2. Autonomous Transaction Processing
What is Autonomous Data Warehouse best for?
Answer:
Best for all analytic workloads such as data warehouse, data marts, data lakes, or machine
learning
Question 4:
What is Autonomous Transaction Processing best used for?
Answer:
Best for Transaction Processing and mixed workloads. Ex: Transactions, Batch, Reporting, IoT,
Application Dev, Machine Learning
Question 5:
T/F: Oracle automates end-to-end management of the data warehouse
Answer:
True
, Question 6:
What does the Autonomous Data Warehouse handle?
Answer:
1. Provisioning new databases Growing/shrinking storage and/or compute Patching and
upgrades
Backup and Recovery
Question 7:
T/F: The Full lifecycle is managed using the service console, but alternatively it can be managed
via command-line interface or REST API
Answer:
True
Question 8:
T/F: Autonomous Data Warehouse requires some tuning
Answer:
False; no tuning required
Question 9:
T/F: Autonomous Data Warehouse is designed as a "load and go" service: you start the service;
define tables, load data and then run queries
Answer:
True
Question 10:
T/F: Autonomous Database Warehouse required someone with special database expertise False
T/F: You do not need to consider any details about parallelism, partitioning, indexing, or
compression. The service automatically configures the database for high performance queries
True Fill in the blank: Autonomous Data Warehouse is a completely
Answer:
service elastic
Question 11:
T/F: When you get started with Autonomous Data Warehouse, simply specify the number of
