ADB Practice Exam UPDATED ACTUAL
QUESTIONS AND CORRECT ANSWERS
Which is the recommended data loading tool to migrate data from third party databases? -
CORRECT ANSWER SQL Developer Migration Workbench
Which command can you use to create an autonomous database? - CORRECT
ANSWER POST/20160918/autonomouseDatabases
Which terminology is referred to a communication channel for sending messages to a
subscription such as email or sms - CORRECT ANSWER Topic
Which two statements are trye about patching an Autonomous Database? - CORRECT
ANSWER Oracle patches the database during a scheduled maintenance window.
Oracle patching generally does not take more than two hours.
Which are the THREE pre requisites to configure a private endpoint with auntonomous
databases? - CORRECT ANSWER There must be a private subnet with the DHCP
option.
There must be at least one network security group within your VCN.
There must be a VCN within the region of the ADB.
Which two statements are TRUE about access control lists (ACLs) configured for
Autonomous Databases? - CORRECT ANSWER ACLs can be configured for
individuals' IP addresses, CIDR block ranges, and VCNs.
All services that are subsets of an ADB, such as SQL Developer Web, Apex, and OML
notebooks, are also blocked by ACLs.
Which Two statements are true about the OCi command-line interface? - CORRECT
ANSWER Calls OCI REST APIs
Is Easy to use and lightweight to install
, Which role is automatically granted to any user created in the Autonomous Database? -
CORRECT ANSWER DWROLE
How many Network Security Groups (NSGs) can you configure for an autonomous database?
- CORRECT ANSWER Five!
For which resource consumption will you be charged when your Autonomous Database is
stopped temporarily? - CORRECT ANSWER Allocated storage
Which statement is true about auto indexing in an Autonomous Database? - CORRECT
ANSWER It analyzes the application workload and accordingly creates new indexes
and drops the existing underperforming indexes ti improve database performance.
Which feature is available in autonomous database shared but not in autonomous database
dedicated? - CORRECT ANSWER Oracle Machine Learning (OML)Notebook
Which two are TRUE regarding cloning an Autonomous Database? - CORRECT
ANSWER A new autonomous database can be cloned from a live running database
instance.
The cloned database version can be higher than the source database version.
Which TWO tasks are performed by a Fleet Administrator? - CORRECT
ANSWER Provision Autonomous Container Databases
Provision Exadata Infrastructure
Which two statements are true about API signing key? - CORRECT ANSWER It is
required when using OCI API in conjunction with SDK/ CLI.
It is an RSA Key pair in PEM format.
Which database is specialized for developing NoSQL- style applications that uses JavaScript
Object Notation (JSON) - CORRECT ANSWER Autonomous JSON database
QUESTIONS AND CORRECT ANSWERS
Which is the recommended data loading tool to migrate data from third party databases? -
CORRECT ANSWER SQL Developer Migration Workbench
Which command can you use to create an autonomous database? - CORRECT
ANSWER POST/20160918/autonomouseDatabases
Which terminology is referred to a communication channel for sending messages to a
subscription such as email or sms - CORRECT ANSWER Topic
Which two statements are trye about patching an Autonomous Database? - CORRECT
ANSWER Oracle patches the database during a scheduled maintenance window.
Oracle patching generally does not take more than two hours.
Which are the THREE pre requisites to configure a private endpoint with auntonomous
databases? - CORRECT ANSWER There must be a private subnet with the DHCP
option.
There must be at least one network security group within your VCN.
There must be a VCN within the region of the ADB.
Which two statements are TRUE about access control lists (ACLs) configured for
Autonomous Databases? - CORRECT ANSWER ACLs can be configured for
individuals' IP addresses, CIDR block ranges, and VCNs.
All services that are subsets of an ADB, such as SQL Developer Web, Apex, and OML
notebooks, are also blocked by ACLs.
Which Two statements are true about the OCi command-line interface? - CORRECT
ANSWER Calls OCI REST APIs
Is Easy to use and lightweight to install
, Which role is automatically granted to any user created in the Autonomous Database? -
CORRECT ANSWER DWROLE
How many Network Security Groups (NSGs) can you configure for an autonomous database?
- CORRECT ANSWER Five!
For which resource consumption will you be charged when your Autonomous Database is
stopped temporarily? - CORRECT ANSWER Allocated storage
Which statement is true about auto indexing in an Autonomous Database? - CORRECT
ANSWER It analyzes the application workload and accordingly creates new indexes
and drops the existing underperforming indexes ti improve database performance.
Which feature is available in autonomous database shared but not in autonomous database
dedicated? - CORRECT ANSWER Oracle Machine Learning (OML)Notebook
Which two are TRUE regarding cloning an Autonomous Database? - CORRECT
ANSWER A new autonomous database can be cloned from a live running database
instance.
The cloned database version can be higher than the source database version.
Which TWO tasks are performed by a Fleet Administrator? - CORRECT
ANSWER Provision Autonomous Container Databases
Provision Exadata Infrastructure
Which two statements are true about API signing key? - CORRECT ANSWER It is
required when using OCI API in conjunction with SDK/ CLI.
It is an RSA Key pair in PEM format.
Which database is specialized for developing NoSQL- style applications that uses JavaScript
Object Notation (JSON) - CORRECT ANSWER Autonomous JSON database
