ADB Certification Exam with precise answers
|!| |!| |!| |!| |!|
What happens with the standby database when disabling ADG?
|!| |!| |!| |!| |!| |!| |!| |!|
-the standby database is started read/write
|!| |!| |!| |!| |!|
-the standby database is terminated
|!| |!| |!| |!|
-the standby database is started read-only
|!| |!| |!| |!| |!|
-the standby database is transformed in a refreshable clone - correct
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
answer✔✔The standby database is terminated |!| |!| |!| |!|
Data Guard is enabled for your Autonomous Database and the Lifecycle
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
State field for the primary database indicates that it is Stopped. Which
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
statement is true? |!| |!|
-Failover is automatically initiated.|!| |!| |!|
-The standby database is also stopped.
|!| |!| |!| |!| |!| |!|
-The standby database is terminated.
|!| |!| |!| |!|
-Switchover is automatically initiated. - correct answer✔✔The standby
|!| |!| |!| |!| |!| |!| |!| |!|
database is also stopped |!| |!| |!|
Which Statement is false about setting up compartment quotas?
|!| |!| |!| |!| |!| |!| |!| |!| |!|
-Compartment quotas use policies that allow allocation of resources with a |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
high level of flexibility.
|!| |!| |!|
-You cannot manage quotas in a compartment, unless you belong to a
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
group that has the correct permissions.
|!| |!| |!| |!| |!|
-Compartment quotas cannot be set on the root compartment. |!| |!| |!| |!| |!| |!| |!| |!| |!|
-Quotas set on a parent compartment override quotas set on child
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
compartments. - correct answer✔✔Compartment quotas cannot be set on |!| |!| |!| |!| |!| |!| |!| |!| |!|
the root compartment
|!| |!|
,Which statement is false about Oracle Data Safe?
|!| |!| |!| |!| |!| |!| |!|
-It helps you evaluate risks to data, assess user security, monitor user
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
activity, and address data security compliance requirements.
|!| |!| |!| |!| |!| |!|
-It evaluates user types, how users are authenticated, and the password
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
policies assigned to each user. |!| |!| |!| |!|
-It supports only Autonomous Databases.
|!| |!| |!| |!| |!|
-It helps you assess the security of your cloud database configurations by
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
analyzing database configurations. |!| |!|
-It helps you find and mask sensitive data in your database by inspecting
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
the actual data in your database and its data dictionary. - correct
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
answer✔✔It supports only ADB |!| |!| |!|
What option should you use to create a graph with Graph Studio?
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
A graph license key
|!| |!| |!|
Tables in an Autonomous Database instance
|!| |!| |!| |!| |!| |!|
Graph created by a special tool downloaded from oracle.com
|!| |!| |!| |!| |!| |!| |!| |!|
Graph analytics algorithms|!| |!|
NoSQL configuration - correct answer✔✔Tables in an ADB instance
|!| |!| |!| |!| |!| |!| |!| |!|
Which three are use cases for Graph Studio?
|!| |!| |!| |!| |!| |!| |!|
Clustring |!|
Facial recognition |!|
Churn analysis |!|
Pattern matching |!| |!|
3-D modeling - correct answer✔✔Clustering
|!| |!| |!| |!|
Facial Recognition |!| |!|
Pattern Matching |!|
,Which two of the following statements are correct? (Choose all correct
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
answers)
Options are : |!| |!|
All of the capabilities of ODI Classic are available with ODI Web Edition.
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
ODI Web Edition is available only on Oracle Linux.
|!| |!| |!| |!| |!| |!| |!| |!|
ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI)
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
Marketplace. |!|
The Data Transforms Card provides access to Oracle Data Integrator (ODI)
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
Web Edition. - correct answer✔✔All of the capabilities of ODI Classic are
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
available with ODI web edition |!| |!| |!| |!|
ODI Web edition can be installed from OCI marketplace
|!| |!| |!| |!| |!| |!| |!| |!|
Which four file formats are supported when loading data from Cloud
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
Storage? (Choose all correct answers) |!| |!| |!| |!|
AVRO |!|
JSON |!|
DOC
DDL
CSV |!|
Parquet - correct answer✔✔AVRO |!| |!| |!|
JSON
CSV
Parquet
In which four ways can Oracle Database optimally access data in Object
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
Storage? (Choose all correct answers) |!| |!| |!| |!|
Options are : |!| |!|
Scan avoidance using columnar pruning for .csv files
|!| |!| |!| |!| |!| |!| |!|
Optimized data archive using hybrid partitioned tables |!| |!| |!| |!| |!| |!| |!|
, Sean avoidance using columnar pruning for columnar stores like parquet
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
and orc |!| |!|
Optimized data archive using partitioned external tables
|!| |!| |!| |!| |!| |!| |!|
Scan avoidance using partitioned external tables
|!| |!| |!| |!| |!|
Scan avoidance using block skipping when reading parquet and orc files -
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
correct answer✔✔Optimized data archive using hybrid partitioned tables
|!| |!| |!| |!| |!| |!| |!| |!|
Scan avoidance using columnar pruning for columnar stores like parquet
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
and orc |!| |!|
Optimized data archive using partitioned external tables
|!| |!| |!| |!| |!| |!| |!|
Scan avoidance using partitioned external tables
|!| |!| |!| |!| |!|
Which statement is true about the use of Access Control Lists (ACLs) with
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
an Autonomous Database on Shared Infrastructure?
|!| |!| |!| |!| |!|
Options are : |!| |!|
When you restore a database, the existing ACLs are not overwritten by the
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
restore.
|!|
an ACL can only be set during the creation of an Autonomous Database on
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
Shared Infrastructure.
|!| |!|
an ACL can be set up for an IP address or a virtual cloud network (VCN)
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
but not both at the same time.
|!| |!| |!| |!| |!| |!|
ACLs can only be used with private endpoints. - correct answer✔✔When
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
you restore a database, the existing ACLs are not overwritten by the
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
restore.
Which two statements are true about using an Oracle Autonomous
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
Database with private endpoints? (Choose all correct answers)
|!| |!| |!| |!| |!| |!| |!|
Options are : |!| |!|
An Autonomous Database with private endpoints can be accessed from the
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
public Internet by adding your IP address to an Access Control List.
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
|!| |!| |!| |!| |!|
What happens with the standby database when disabling ADG?
|!| |!| |!| |!| |!| |!| |!| |!|
-the standby database is started read/write
|!| |!| |!| |!| |!|
-the standby database is terminated
|!| |!| |!| |!|
-the standby database is started read-only
|!| |!| |!| |!| |!|
-the standby database is transformed in a refreshable clone - correct
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
answer✔✔The standby database is terminated |!| |!| |!| |!|
Data Guard is enabled for your Autonomous Database and the Lifecycle
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
State field for the primary database indicates that it is Stopped. Which
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
statement is true? |!| |!|
-Failover is automatically initiated.|!| |!| |!|
-The standby database is also stopped.
|!| |!| |!| |!| |!| |!|
-The standby database is terminated.
|!| |!| |!| |!|
-Switchover is automatically initiated. - correct answer✔✔The standby
|!| |!| |!| |!| |!| |!| |!| |!|
database is also stopped |!| |!| |!|
Which Statement is false about setting up compartment quotas?
|!| |!| |!| |!| |!| |!| |!| |!| |!|
-Compartment quotas use policies that allow allocation of resources with a |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
high level of flexibility.
|!| |!| |!|
-You cannot manage quotas in a compartment, unless you belong to a
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
group that has the correct permissions.
|!| |!| |!| |!| |!|
-Compartment quotas cannot be set on the root compartment. |!| |!| |!| |!| |!| |!| |!| |!| |!|
-Quotas set on a parent compartment override quotas set on child
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
compartments. - correct answer✔✔Compartment quotas cannot be set on |!| |!| |!| |!| |!| |!| |!| |!| |!|
the root compartment
|!| |!|
,Which statement is false about Oracle Data Safe?
|!| |!| |!| |!| |!| |!| |!|
-It helps you evaluate risks to data, assess user security, monitor user
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
activity, and address data security compliance requirements.
|!| |!| |!| |!| |!| |!|
-It evaluates user types, how users are authenticated, and the password
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
policies assigned to each user. |!| |!| |!| |!|
-It supports only Autonomous Databases.
|!| |!| |!| |!| |!|
-It helps you assess the security of your cloud database configurations by
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
analyzing database configurations. |!| |!|
-It helps you find and mask sensitive data in your database by inspecting
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
the actual data in your database and its data dictionary. - correct
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
answer✔✔It supports only ADB |!| |!| |!|
What option should you use to create a graph with Graph Studio?
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
A graph license key
|!| |!| |!|
Tables in an Autonomous Database instance
|!| |!| |!| |!| |!| |!|
Graph created by a special tool downloaded from oracle.com
|!| |!| |!| |!| |!| |!| |!| |!|
Graph analytics algorithms|!| |!|
NoSQL configuration - correct answer✔✔Tables in an ADB instance
|!| |!| |!| |!| |!| |!| |!| |!|
Which three are use cases for Graph Studio?
|!| |!| |!| |!| |!| |!| |!|
Clustring |!|
Facial recognition |!|
Churn analysis |!|
Pattern matching |!| |!|
3-D modeling - correct answer✔✔Clustering
|!| |!| |!| |!|
Facial Recognition |!| |!|
Pattern Matching |!|
,Which two of the following statements are correct? (Choose all correct
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
answers)
Options are : |!| |!|
All of the capabilities of ODI Classic are available with ODI Web Edition.
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
ODI Web Edition is available only on Oracle Linux.
|!| |!| |!| |!| |!| |!| |!| |!|
ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI)
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
Marketplace. |!|
The Data Transforms Card provides access to Oracle Data Integrator (ODI)
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
Web Edition. - correct answer✔✔All of the capabilities of ODI Classic are
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
available with ODI web edition |!| |!| |!| |!|
ODI Web edition can be installed from OCI marketplace
|!| |!| |!| |!| |!| |!| |!| |!|
Which four file formats are supported when loading data from Cloud
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
Storage? (Choose all correct answers) |!| |!| |!| |!|
AVRO |!|
JSON |!|
DOC
DDL
CSV |!|
Parquet - correct answer✔✔AVRO |!| |!| |!|
JSON
CSV
Parquet
In which four ways can Oracle Database optimally access data in Object
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
Storage? (Choose all correct answers) |!| |!| |!| |!|
Options are : |!| |!|
Scan avoidance using columnar pruning for .csv files
|!| |!| |!| |!| |!| |!| |!|
Optimized data archive using hybrid partitioned tables |!| |!| |!| |!| |!| |!| |!|
, Sean avoidance using columnar pruning for columnar stores like parquet
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
and orc |!| |!|
Optimized data archive using partitioned external tables
|!| |!| |!| |!| |!| |!| |!|
Scan avoidance using partitioned external tables
|!| |!| |!| |!| |!|
Scan avoidance using block skipping when reading parquet and orc files -
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
correct answer✔✔Optimized data archive using hybrid partitioned tables
|!| |!| |!| |!| |!| |!| |!| |!|
Scan avoidance using columnar pruning for columnar stores like parquet
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
and orc |!| |!|
Optimized data archive using partitioned external tables
|!| |!| |!| |!| |!| |!| |!|
Scan avoidance using partitioned external tables
|!| |!| |!| |!| |!|
Which statement is true about the use of Access Control Lists (ACLs) with
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
an Autonomous Database on Shared Infrastructure?
|!| |!| |!| |!| |!|
Options are : |!| |!|
When you restore a database, the existing ACLs are not overwritten by the
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
restore.
|!|
an ACL can only be set during the creation of an Autonomous Database on
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
Shared Infrastructure.
|!| |!|
an ACL can be set up for an IP address or a virtual cloud network (VCN)
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
but not both at the same time.
|!| |!| |!| |!| |!| |!|
ACLs can only be used with private endpoints. - correct answer✔✔When
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
you restore a database, the existing ACLs are not overwritten by the
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
restore.
Which two statements are true about using an Oracle Autonomous
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
Database with private endpoints? (Choose all correct answers)
|!| |!| |!| |!| |!| |!| |!|
Options are : |!| |!|
An Autonomous Database with private endpoints can be accessed from the
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
public Internet by adding your IP address to an Access Control List.
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|
