Which two methods can you use to create users and grant
roles in Autonomous Database?
A.
using DBMS_CLOUD_ADMIN package X
B.
through the Oracle Cloud Infrastructure service
console
C. through SQL/Developers ✔
D. through SQL*Plus
Answer
C,D
When running lots of high concurrent queries in Autonomous
Database, you should use which predefined service connection?
A.
DBNAME_MEDIUM
B.
DBNAME_HIGH
C.
DBNAME_CONCURRENT
D. DBNAME_LOW
Answer
D
Where can a user's public ssh key be added on the Oracle
Cloud Infrastructure Console in order to execute API calls?
A.
SSH keys are not required in Oracle Cloud
Infrastructure
B.
SSH keys cannot be added from console. They have
to be added using REST APIs only.
C.
On the Autonomous Database Console.
D. Navigate to Identity, select
Users panel on the console and select "Add Public Key"
Answer
D
Which three Oracle Cloud Infrastructure (OCI) resources do
you need to configure before provisioning your Autonomous Database with Private
Endpoint?
A.
Security List
B.
Route Table
C. Subnet
D. VCN
E.
Network Security Group
Answer
C,D,E
Q5. Which three event types are supported for Autonomous
Database? (Choose three.)
A.
Update IORM Begin
B. Maintenance Begin
C. Terminate End
D.
Change Autoscaling Configuration Compartment
E. Change Compartment Begin
Answer
B,C,E
When in the SQL Monitoring tab of the Performance Hub you
see a clock icon in the status column, What does this mean?
A.
The SQL statement is executing
B.
The SQL statement did not complete either due to
an error
C. The SQL statement is queued
D.
The SQL statement completed its execution
Answer
C
Which three are use cases for Graph Studio? (Choose three.)
A. 3-D modelling
B.
Churn analysis
C. Pattern matching
D.
Facial recognition
E. Clustering
Answer
A,C,E
When enabling auto-scaling, which two options change?
(Choose two.)
A. Number of OCPUs displayed in the
console
B.
Amount of storage
C.
Parallelism settings
D. I/O resources
E.
Level of concurrency
Answer
A,D
Which can be Scaled independently of the number of CPUs in
an Autonomous Database?
A.
Sessions
B. Storage
C.
Parallelism
D.
Concurency
Answer
B
What happened with the standby database when disabling
Autonomous Data Guard?
A.
The standby database is started readwrite
B.
The standby database is transformed in a
refreshable clone
C. The standby database is
terminated
D.
The standby database is started read only
Answer
C
You have an Autonomous Transaction Processing Database with
three OCPUs and auto scaling turned on and your application is using the
TPURGENT service.
The load on the database increases from three OCPUs to nine
OCPUs.
What is the total number of concurrent statements that the
TPURGENT service can support?
A. 2700
B.
1500
C.
900
D.
1800
Answer
A
Which Autonomous Database Service is NOT used to connect to
an Autonomous Transaction Processing instance ?
A.
HIGH
B.
MEDIUM
C. TPPERFORMANT
D.
TPURGENT
Answer
C
Which statement is FALSE about Oracle Autonomous JSON
Database?
A.
JSON data is stored natively in the database
B.
You can promote Autonomous JSON Database to
Autonomous Transaction Processing
C.
It supports NoSQL-style, document-centric
application
D. There is a 20 GB limit on JSON
collection
Answer
D
Which data file format is NOT supported when using the
package DBMS_CLOUD on Shared Exadata Infrastructure?
A.
Avro X
B.
Parquet
C.
JSON
D.
Microsoft SQL Server (.mdf)
Answer
D
Which cloud service is NOT supported to import data pump files
from using Dedicated Exadata Infrastructure?
A.
Oracle Cloud Infrastructure Object Storage
B. Google Cloud Storage
C.
Amazon S3
D.
Oracle Cloud Infrastructure Object Storage
Classic
Answer
B
In the Autonomous Database (ADB) Dedicated service, what
does the fleet administrator use to control OCPU utilization?
A.
Oracle Machine Learning notebook
B.
Compartment quotas
C.
SQL Developer Web Console
D.
Resource Manager settings
Answer
B
Which statement is not correct when the Autonomous Database
is stopped?
A.
In-flight transactions queries are stopped
B.
Tools are no longer able to connect to a stopped
instance
C. User with DWROLE can still
access the database
D.
CPU billing is halted
Answer
C
According to Oracle documentation, What is a best practice
when planning and instituting Access Controls for your Autonomous Dedicated
environment regarding Subnets, Compartments and User Groups?
A. Create at least 2 of each
resource
B.
Only 1 Subnet and 1 Compartment are allowed,
multiple Groups highly advised
C.
Only 1 of each is allowed to be allocated per
environment
D.
Create a Separate VCN that contains only public
subnets
Answer
A
How do you change the tablespace quota for a user MTHEO on
Autonomous Database on Shared Infrastructure?
A.
Execute alter tablespace DATA set quota = 10G
B.
Execute alter tablespace for user ADBUSER
tablespace DATA quota = 10G
C. Execute
DBMS_CLOUD_ADMIN.GRANT_TABLESPACE QUOTA (username => ‘MTHEO’
,tablespace_quota => UNLIMITED)
D.
Execute alter user ADBUSER quota unlimited on
tablespace DATA
Answer
C
Which statement is true about connecting an OCI compute
instance to a Shared Autonomous Database?
A.
A Private Endpoint is required to connect to the
Shared-Autonomous Database
B.
The Autonomous Database must belong to a Network
Security Group (NSG)
C.
The Autonomous Database must be in the same VCN
and Subnet as the Compute instance
D. The OCI compute instance can be
used with an Always-Free Autonomous Database account
E.
The OCI compute instance does not support
connecting to a Shared Autonomous Database
Answer
D
Which two options are available to restore an Autonomous
Data Warehouse? (Choose two.)
A.
Select the snapshot of the backup
B.
Select the backup from which restore needs to be done
C.
Backup and recovery must be done using Recovery
Manager (RMAN)
D.
Select the archived redo logs
E.
Specify the point in time (timestamp) to restore
Answer
B,E
Which statement is correct about the Service console in an
Autonomous Database?
A.
You can use Service console to enable or disable
auto scaling of Autonomous DB
B. You can use Service console to
manage runaway SQL statements on Autonomous DB
C.
You can use Service console to move Autonomous
DB between compartments
D.
You can use Service console to create manual
backups of Autonomous database.
Answer
B
Which Autonomous Database Cloud service ignores hints in SQL
Statements by default?
A.
Autonomous Transaction Processing
B. Autonomous Data Warehouse
C.
Neither service ignores hints by default
D.
Both services ignore hints by default
Answer
B
You are the admin of an Autonomous Database (ADB) instance,
and a new developer has requested a new workspace in APEX. What statement
describes the step to provide the developer a new workspace in APEX? (Choose
two.)
A.
Create a new developer account
B. Access the APEX Administration
Services and create the workspace for the developer
C.
Create a database user with the APEX role
D.
Create an IDCS user with the APEX role
Answer
B
Which method will NOT permit you to change the database
Admin Password of a Autonomous Database on Shared Infrastructure?
A. OS command line from the database
server
B.
OCI CLI
C.
Admin page of the Cloud Service Console
D.
SQLDeveloper
Answer
A
While Autonomous Transaction Processing and Autonomous Data
Warehouse use the same Oracle database, which statement is true about the
workloads?
A.
Autonomous Transaction Processing memory usage
optimizes workloads for parallel joins and aggregations
B.
Autonomous Data Warehouse workloads are
optimized for mixed workloads
C.
Autonomous Transaction Processing workloads are
optimized for data warehouse, data mart, and data lake
D. Data that is bulk loaded, by
default, uses the row format in Autonomous Transaction Processing where
Autonomous Data Warehouse data format is columnar
Answer
D
What are two differentiators of Oracle Autonomous Database
Dedicated Infrastructure? (Choose two.)
A.
Users have OS access to the database machine
B. It offers greater control and
isolation starting at the Exadata cloud infrastructure level
C.
Users can customize the OS stack and add
additional packages
D.
Users have SYS privileges in the database
E. Users have more control over the
maintenance schedule
Answer
B,E
Which Database Actions tool is used to get information about
the entries on your Oracle Autonomous Database and to see the effect that
changing an object has on other objects?
A.
Data Load
B.
Catalog
C.
JSON
D.
Data Insight
Answer
B
You are the admin user of an Autonomous Database (ADB)
instance. A new business analyst has joined the team and would like to explore
ADB tables using SQL Developer Web.
What steps do you need to take?
A.
Create an IDCS user. Create a database user with
connect, resource, and object privileges
B.
Create a database user with the default
privileges
C.
Create a database user with connect, resource,
and object privileges
D. Create a database user (with
connect, resource, object privileges), enable the schema to use SQL Developer
and provide the user with the user-specific modified URL
Answer
D
Which statement is FALSE for Oracle Data Safe? (Choose the
best answer.)
A.
Oracle Data Safe helps you assess the security
of your cloud database. configurations by analyzing database configurations
B.
Oracle Data Safe evaluates user types, how users
are authenticated, and the password policies assigned to each user
C. Oracle Data Safe only supports
Autonomous Databases
D.
Oracle Data Safe helps you find sensitive data
in your database by inspecting the actual data in your database and its data
dictionary
Answer
C
Which three are Oracle-recommended best practices for
Autonomous Database alarms? (Choose three)
A. Select the correct alarm
interval for your metric
B.
Create multiple alarm metrics
C. Routinely tune your alarms
D. Suppress alarms during
investigations
E.
Create a single alarm for each metric
F.
Use a single interval for all alarms
Answer
A,C,D
Which statement is true when you provision an Autonomous
Database using the cloning method?
A. A clone database source can be a
running database instance
B.
A clone database source can be from a
point-in-time backup that is less than 2 hours old
C.
There is only one type of cloning option
available in Autonomous Database
D.
You can clone a database in a security zone to
create a database that isn't in a security zone
Answer
A
Which set of options can be specified when defining the
preferred maintenance schedule of the Exadata infrastructure for Autonomous
Database Dedicated?
A.
Week of the Quarter, Day of the Week, Start Hour
B.
Month of the Year, Week of the Month, Day of the
Week, Start Hour
C.
Quarter of the Year, Month of the Quarter, Date
of the Month, Start Hour
D. Month of the Quarter, Week of
the Month, Day of the Week, Start Hour
Answer
D
Which statement is NOT correct when setting up compartment
quotas?
A.
Compartment quotas use policies that allow
allocation of resources with a high level of flexibility
B.
Along with compartment budgets, compartment
quotas create a powerful toolset to manage your spending
C. Compartment quotas are set by
Oracle
D.
There are three types of quota policy statements
which are set, unset and zero
Answer
C
You are requested to analyze a year's stock purchase data
which is stored in Autonomous Data Warehouse instance.
Which tool would you use to automate data exploration and
create pivot tables?
A. Business Models
B.
Data Load
C.
SQL Developer Web
D.
APEX
Answer
A
An Autonomous Database (ADB) user with an instance wallet
has left the company and shared database user id with other users when
accessing ADB. Other than changing the shared user password, what can the admin
do to protect the instance?
A.
Delete the user
B. Rotate the instance wallet and
share the new wallet with the remaining users
C.
Shutdown and restart the instance
D.
Trust the user who left, not to access the
database
Answer
B
When you are cloning from a backup, what is the earliest
timestamp of the backup is allowed in Autonomous Database?
A. 2 hours
B.
30 minutes
C.
1 hours
D.
24 HOURS
Answer
A
Which workload type does the Autonomous Database on
dedicated infrastructure service currently support?
A.
Autonomous Data Warehouse only
B.
Hybrid Columnar compression
C.
Autonomous Transaction Processing only
D.
ATP and ADW
Answer
D
In Graph Studio which you can use to create a graph?
A.
A graph license key
B. Tables in an Autonomous Database
instance
C.
NoSQL configuration
D.
Graph analytics algorithms
E.
Graph created by a special tool downloaded from
Oracle.com
Answer
B
Which two statements are correct about Autonomous Data
Warehouse on Shared Exadata Infrastructure? (Choose two.)
A.
You have direct access to the database node
B. Compression is enabled by
default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all
tables by default.
C. Oracle Database Result Cache is
enabled by default for all SQL statements
D.
Parallelism is not enabled by default
Answer
B,C
While creating a business model what advanced options you
can enable or disable? (Choose three)
A.
Business Object Security Feature
B. Analytic View Transparency View
C. Autonomous Aggregate Cache
D.
Display private tables
E. Analytic View Base Table Query
Transformation
Answer
B,C,E
For someone that is not a service administrator to use SQL
Developer Web, what package would you need to use to give them access?
A.
ORDS_ADMIN.GRANT_SCHEMA
B. ORDS_ADMIN.ENABLE_SCHEMA
C.
SQLDEV_ADMIN.GRANT_SCHEMA
D.
ORDS PRIV.ENABLE_SCHEMA
Answer
B
You need to set up a notification for a scheduled shutdown
of an Autonomous Database instance. What should you do?
A.
Add a "BEFORE SHUTDOWN ON DATABASE"
trigger within the database
B. Create a rule for the Oracle
Cloud Infrastructure Event for "Autonomous Database STOP END"
C.
Create a notification alert using DBMS_SNMP
package
D.
Create an Oracle Cloud Infrastructure Alarm for
Shutdown metric
Answer
B
What are three methods to load data into the Autonomous
Database? (Choose three.)
A. Oracle GoldenGate
B. Oracle Data Pump
C.
RMAN Restore
D.
Transportable Tablespace
E. SQL Loader
Answer
A,B,E
Which three methods can be used to migrate your existing
Oracle database to Autonomous Database? (Choose three.)
A.
Use SFTP to copy CSV files into Autonomous
Database
B. Use Oracle Zero Downtime
Migration (ZDM)
C.
Use Recovery Manager (RMAN)
D. Use GoldenGate
E.
Use Data Pump
Answer
B,D,E
What command should you issue to enable application
continuity on Autonomous Database Shared Infrastructure?
A.
alter session set application_continuity=true
B.
alter database set application_continuity=true
C. exec
dbms_cloud_admin.enable_app_cont(" ");
D.
alter system set application_continuity=true
Answer
C
Which statement is FALSE regarding the auto scaling feature?
A.
Auto scaling is enabled by default and can be
enabled or disabled at anytime
B.
For databases on dedicated Exadata
infrastructure, the maximum: number of cores available to a database depends on
the total number of cores available in the Exadata infrastructure instance
C. The base number of OCPU cores
allocated to a database is not guaranteed
Answer
C
In the Autonomous Database (ADB) Dedicated service, what
does the fleet administrator use to control OCPU utilization?
A.
Oracle Machine Learning notebook
B.
Compartment quotas
C.
SQL Developer Web Console
D.
Resource Manager settings
Answer
B
How can an Autonomous Database resource be provisioned
without logging into the Oracle Cloud Infrastructure console?
A.
It cannot be done
B.
Connecting to the Cloud Infrastructure Command
console via SSH wallet
C. Using the Oracle Cloud
Infrastructure Command Line interface tool or REST API calls
D.
Using Database Configuration Assistant (DBCA) on
the database server
Answer
C
Which set of Oracle Cloud Infrastructure metrics is
available only for Autonomous Database on Dedicated Infrastructure?
A.
CPU Utilization, Storage Utilization
B.
Transaction Count, Sessions, Running Statements
C.
Query Latency, User Calls, Execute Count
D. IOPS, Storage Space Used By
Tablespace, Apply and Transport Lag
Answer
D
A new Python developer has joined your team and needs to
access the Autonomous Database (ADB) data.
How does the developer connect to and interact with ADB from
Python?
A. The Oracle Client and the
cx_Oracle interface for Python
B.
You can't use Python with ADB
C.
SQL Developer
D.
JAVA JDK
Answer
A
During the provisioning of an Autonomous Database on
Dedicated hardware, what does the Database Administrator need to select to
determine where the Autonomous Database is created on the Dedicated
infrastructure?
A.
the Compartment of the Dedicated infrastructure
as each compartment only runs one Dedicated environment
B.
the Listener endpoint where the Autonomous
Database should register on
C.
the Client Credentials wallet which is used to
connect to the Autonomous Database
D. the container database in which
the Autonomous instance should run
Answer
D
Your customer wants to permanently disable scheduled
maintenance on Autonomous Dedicated Infrastructure to keep their current database
version(s).
How can they achieve this?
A.
Change the Automatic Maintenance Schedule to
specify a Schedule but do not select any month, week or day
B.
Change the Automatic Maintenance Schedule to No
Preference
C. You cannot permanently disable
scheduled Automatic Maintenance
D.
Change the Automatic Maintenance Schedule to
None
Answer
C
Where are customer-managed encryption keys stored for
Autonomous Database on Dedicated Infrastructure?
A. in a separate key vault external
to the Exadata Infrastructure
B.
on the Exadata Infrastructure where Autonomous
Database Dedicated is hosted
C.
inside the Autonomous Database wallet
D.
inside the backups of the container database
Answer
A
When using Data Pump to migrate your Oracle database to
Autonomous Database, which two objects are imported?
A. Schemas
B.
Tablespaces
C.
Reports
D. Data
Answer
A,D
Oracle Autonomous Database on Dedicated Infrastructure is
composed of which Oracle Cloud resources?
A.
Virtual Cloud Network, Compartments, Policies,
and Autonomous Exadata infrastructure
B.
Fleet Administrator, Database Administrator,
Database User, and Autonomous Exadata infrastructure
C. Autonomous Exadata
infrastructure, Autonomous Backup, Autonomous Container Database, and
Autonomous Database
D.
Oracle Machine Learning Zeppelin Notebook,
Autonomous Exadata infrastructure, Fleet Administrator, and Database
Administrator
Answer
C
What is the role of a Fleet Administrator in Autonomous
Database (ADB) on Dedicated Infrastructure deployments?
A.
Fleet Administrators are responsible for
patching and backups of all container databases
B.
Fleet Administrators create, monitor and manage
Autonomous Databases
C. Fleet administrators create,
monitor and manage Autonomous Exadata Infrastructure and Autonomous Container
Database resources
D.
Fleet Administrator defines and gains access to
the ADMIN administrative user account for the database
Answer
C
Which statement is correct with respect to required action
to move Autonomous Database resources to a different compartment?
A.
Moving the compartment of the Autonomous Database
will also move the Autonomous Container Database and Autonomous Exadata
Infrastructure
B.
Moving an Autonomous Database instance does not
include its automatic backups
C. Autonomous Exadata
Infrastructure instances and Autonomous Container Databases have no dependent
resources that move with them. Associated (non dependent) resources remain in
their current compartments
D.
You do not need to have sufficient access
permissions on the compartment that the resource is being moved to
Answer
C
When working with an Autonomous Exadata Infrastructure
supporting Autonomous Databases, where do you go to view the maintenance
history of the Exadata?
A.
Under Core Infrastructure then Compute then
Autonomous Exadata
B. Under Database then Autonomous
Transaction Processing then Autonomous Exadata
C.
Under Solutions and Platform then Platform
Services then Autonomous Exadata
D.
Under Core Infrastructure then Autonomous
Exadata
Answer
B
Which two statements are true about Data Insights?
A.
Data Insights is available with on-premises
deployments of Oracle Database.
B. You can search for Data Insights
against a base table or business model
C.
Data Insights is an additional priced option
D. You can retrieve previously
executed Data Insights searches
Answer
B,D
Which two methods can you use to create database users and
grant roles in Autonomous Database services?
A.
the DBMS CLOUD_ADMIN package
B. SQL*Plus
C. SQL Developer
D.
the Oracle Cloud Infrastructure service console
Answer
B,C
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?
A.
The standby database is also stopped.
B.
The standby database is terminated.
C.
Switchover is automatically initiated.
D. Failover is automatically
initiated.
Answer
D
Which three advanced options can you enable or disable while
creating a business model?
A. Autonomous Aggregate Cache
B.
Display private tables
C. Analytic View Transparency Views
D.
Business Object Security Feature
E. Analytic View Base Table Query Transformation
Answer
A,C,E
Which three tools can be used to monitor the usage and
activities of Autonomous Database on Dedicated Infrastructure?
A.
Performance Hub
B. OCI Metrics
C. Logs
D. RMAN
E.
Enterprise Manager Cloud Control
Answer
B,C,D
Which two cloud services are supported to import Data Pump
files to Autonomous Database on Dedicated Infrastructure?
A. Oracle Cloud Infrastructure
Object Storage
B.
Amazon 53
C. Oracle Cloud Infrastructure
Object Storage Classic
D.
Google Cloud Storage
E.
Azure Blob Storage
Answer
A,C
Which statement is FALSE about setting up compartment
quotas?
A. You cannot manage quotas in a
compartment, unless you belong to a group that has the correct permissions.
B.
Quotas set on a parent compartment override
quotas set on child compartments.
C.
Compartment quotas use policies that allow
allocation of resources with a high level of flexibility.
D.
Compartment quotas cannot be set on the root
compartment.
Answer
A
Which statement is FALSE about Oracle Data Safe?
A.
It evaluates user types, how users are authenticated,
and the password policies assigned to each user.
B. It supports only Autonomous
Databases.
C.
It helps you assess the security of your cloud
database configurations by analyzing database configurations.
D.
it helps you find and mask sensitive data in
your database by inspecting the actual data in your database and its data dictionary.
E.
it helps you evaluate risks to data, assess user
security, monitor user activity, and address data security compliance
requirements.
Answer
B
Which statement is FALSE about Autonomous Database
maintenance on Dedicated Infrastructure?
A.
Autonomous Exadata infrastructure maintenance
runs are for infrastructure patching (including patching of the Exadata grid infrastructure
code and operating systems updates) and include container database patching.
B. Autonomous Exadata
infrastructure maintenance takes place at least once each quarter.
C.
If a scheduled container database maintenance
run cannot take place, Oracle will automatically reschedule the container database
maintenance for the following quarter.
D.
You can change your container database
maintenance window or reschedule a single container database maintenance run to
ensure that your container database maintenance runs follow infrastructure maintenance
within the same quarter.
Answer
B
Which three options are available to access data in an
Autonomous JSON Database?
A. NOSQL statements using Oracle
SODA drivers
B. REST API calls to the database
(not enabled by default)
C. Oracle JSON Developer tool
downloaded from OTN
D.
Oracle Cloud infrastructure console using the
E.
JSON Online Developer tool
F.
Regular Oracle SQL statements using a connection
through the listener
Answer
A,B,C
A customer wants to increase the throughput of their
inserts. They have discovered that the bottleneck is in the storage I/Os of
their environment.
What should they do to remove this bottleneck?
A.
Ask Support to migrate their setup to a node
without noisy neighbors.
B. Run the DBMS CLOUD. INCREASE
THROUGHPUT procedure.
C.
Remove any non-JSON data from the database.
D.
Increase the number of OCPUS allocated to the
database.
Answer
B
Which two of the following statements are correct?
A. All of the capabilities of ODI
Classic are available with ODI Web Edition.
B.
The Data Transforms Card provides access to Oracle
Data Integrator (ODI) Web Edition.
C. ODI Web Edition can be installed
from Oracle Cloud Infrastructure (OCI) Marketplace.
D.
ODI Web Edition is available only on Oracle
Linux.
Answer
A,C
Which four file formats are supported when loading data from
Cloud Storage?
A. AVRO
B.
DDL
C.
DOC
D. CSV
E. Parquet
F. JSON
Answer
A,D,E,F
Which three options do NOT change when enabling auto
scaling?
A. Parallelism settings
B. Level of concurrency
C. Amount of storage
D.
I/O resources
E.
Number of OCPUS displayed in the console
Answer
A,B,C
Which stage of the indexing pipeline divides text into
tokens?
A.
LEXER
B.
SECTIONER
C.
FILTER
D.
TOKENIZER
Answer
A
In which four ways can Oracle Database optimally access data
in Object Storage?
A.
scan avoidance using columnar pruning for
columnar stores like parquet and orc
B. scan avoidance using block
skipping when reading parquet and orc files
C. optimized data archive using
hybrid partitioned tables
D.
scan avoidance using partitioned external tables
E. scan avoidance using columnar
pruning for.csv files
F.
optimized data archive using partitioned
external tables
Answer
B,C,E
Your customer has upgraded their on-premises 11.2 Database
to 12.2. During this migration, the database was migrated to a pluggable
database and is now in production.
How should the customer unplug their database to migrate to
Autonomous Database (ADB)?
A.
Unplug into an XML file so database files and
XML file can be uploaded to object storage.
B.
Unplug into a PDB archive, which can be uploaded
to object storage.
C. Create a database link from the
source database to the ADB environment and clone the PDB.
D.
Pluggable databases cannot be migrated to ADB
using plug, unplug, or clone.
Answer
C
Autonomous Database's auto scaling feature allows your
database to use up to three times the current base number of OCPU cores at any time.
As demand increases, auto scaling automatically increases the number of cores
in use. Likewise, as demand drops, auto scaling automatically decreases the
number of cores in use.
Which statement is FALSE regarding the auto scaling feature?
A. The base number of OCPU cores
allocated to a database is not guaranteed.
B.
For databases on dedicated Exadata
infrastructure. the maximum number of cores is limited by the number of free
cores that aren't being used by other auto scaling databases to meet high-load
demands.
C.
Auto scaling is enabled by default and can be
enabled or disabled at any time.
D.
For databases on dedicated Exadata
infrastructure. The maximum number of cores available to a database depends on
the total number of cores available in the Exadata infrastructure instance.
Answer
A
Which statement is true about connecting a marketplace
Oracle Cloud Infrastructure (OCI) image
to an
Autonomous Database on Shared Infrastructure?
A. The marketplace OCI image can be
used with an Always Free Autonomous Database account.
B.
The marketplace OCI image does not support connecting
to an Autonomous Database on Shared Infrastructure.
C.
A Private Endpoint is required to connect to the
Autonomous Database on shared Exadata infrastructure.
D.
The Autonomous Database must belong to a Network
Security Group (NSG).
E.
The Autonomous Database can only be in the same
virtual cloud network (VCN) and subnet as the marketplace OCI image.
Answer
A
A new Python developer has joined your team and needs to
access the Autonomous Database (ADB) data.
How does the developer connect to and interact with ADB from
Python?
A.
using JDBC Driver
B. using the Oracle Client and the
ox_Oracle interface
C.
using the Oracle Client and the DBD-Oracle
interface
D.
using SQL Developer
Answer
B
Which option should you use to create a graph with Graph
Studio?
A.
Graph created by a special tool downloaded from oracle.com
B.
A graph license key
C.
Graph analytics algorithms
D.
NOSQL configuration
E. Tables in an Autonomous Database
instance
Answer
E
You need to create a new database by using the Oracle Cloud
Infrastructure (OCI) Command Line Interface (CLI) with the following
requirements:
• Autonomous
Transaction Processing
• License Included
• Shared
Infrastructure
Which parameter would you NOT use?
A. Db-type
B.
Is-defined
C.
Db-worked
D.
License-mode
Answer
A
Which command should you issue to enable application
continuity on Oracle Autonomous Database on Shared Infrastructure?
A.
alter system set application_continuity=true
B.
alter database set application_continuity=true
C. exec dbma_cloud admin.enable
app_cont (‘’):
D.
alter session set application_continuity=true
Answer
C
Which two statements are true about using an Oracle
Autonomous Database with private endpoints?
A.
An Autonomous Database with private endpoints
can be accessed from the public Internet by adding your IP address to an Access
Control List.
B. A Network Security Group is
required within your virtual cloud network before you can provision a Shared
Autonomous Database to use private endpoints.
C. Private endpoints can be
configured when you clone an Autonomous Database on Shared Infrastructure that was
initially created with public endpoints.
D.
You can configure private endpoints for an
Always Free Autonomous Database.
Answer
B,C
Which statement is true about the use of Access Control
Lists (ACLS) with an Autonomous Database on Shared Infrastructure?
A. ACLS can only be used with
private endpoints.
B.
When you restore a database. The existing ACLS
are not overwritten by the restore.
C.
An ACL can be set up for an IP address or a virtual
cloud network (VCN) but not both at the same time.
D.
An ACL can only be set during the creation of an
Autonomous Database on Shared Infrastructure.
Answer
A
When cloning from a backup, what is the earliest timestamp
of the backup allowed?
A.
1 hour
B.
2 hours
C.
24 hours
D.
30 minutes
Answer
B
Which two actions are available to perform when an
Autonomous Database is stopped?
A. Update License Type
B.
Change administrator password
C. Update Network Access
D.
Start
Answer
A,C
Which is NOT needed to manage Oracle Autonomous Database
with REST APIS?
A.
Fingerprint of the public key
B. User's OCID
C.
Database ADMIN password
D.
Tenancy's OCID
Answer
B
While provisioning a dedicated Autonomous Container
Database, which backup retention can NOT be implemented?
A.
7 days
B.
60 days
C. 120 days
D.
15 days
Answer
C
Which three of the following data sources are available when
using the Data Load page on Database Actions?
A. Files in Oracle Cloud Storage
B.
Backup files in block storage
C.
REST endpoints
D. Local Files
E. Files in AWS S3 Storage
Answer
A,D,E
Which two statements are true about accessing Autonomous
Database Tools?
A. Database Actions is accessible
from a server running on the same virtual cloud network (VCN) when the
Autonomous Database is configured with Private Endpoint networking.
B.
Access to Database Actions is available for all
users of Autonomous Database.
C.
SQL Developer Web is available exclusively on
the Autonomous Database.
D.
Oracle Machine Learning is available only with
Autonomous Data Warehouse (ADW) Database.
E. Oracle APEX can be accessed only
from the Developer menu in the Service Console.
Answer
A,E
Which is a difference between Autonomous Data Warehouse
(ADW) and Autonomous Transaction Processing (ATP) databases?
A.
Only ADW supports autoscaling
B. Only ADW uses columnar
compression by default.
C.
Only ATP supports automatic backups.
D.
Only ATP manages optimizer statistics.
Answer
B
You see a clock icon in the Status column on the SQL Monitoring
tab of the Performance Hub.
What does it indicate?
A. The SQL statement is queued.
B.
The SQL statement completed its execution.
C.
The SQL statement is executing
D.
The SQL statement did not complete due to an
error.
Answer
A
You have a requirement to create an Autonomous Transaction
Processing database that can support up to 300 concurrent statements per OCPU
as well as parallelism.
Which service will you need to connect to?
A.
LOW
B.
TP
C. TPURGENT
D.
MEDIUM
Answer
C
Which native data type is used to store spatial information?
A.
SDO_LOCATION
B.
GEO_JSON
C. SDO_GEOMETRY
D.
SDO_RELATE
Answer
C
Which two license types does a customer need to benefit from
Bring Your Own License (BYOL) when leveraging on- premises Enterprise Database
licenses in Oracle Autonomous Database?
A.
Exadata
B. Multitenant
C.
Active Data Guard
D. Real Application Clusters (RAC).
but only when scaling beyond 16 OCPUS
E.
Transparent Data Encryption (TDE)
Answer
B,D
You are the admin user of an Autonomous Database (ADB)
instance. A new business analyst has joined the team and would like to explore
ADB tables using Autonomous Database's Data Tools.
Which steps do you need to perform?
A.
Create a REST-enabled database user (with
connect and object privileges) and grant the DWROLE role.
B.
Create a database user with connect, resource,
and object privileges.
C. Create an IDCS user. Create a
database user with connect. resource. and object privileges.
D.
Create a database user with the default
privileges.
Answer
C
I hope it's helpful for you. If you have any queries, don't hesitate to contact me.
