Font size
Worksheetsdb2022
Total questions: 62
Worksheet time: 1hrs 2mins
Which two methods can you use to create database users and grant roles in autonomous database?
Using DBMS_CLOUD_ADMIN package
Through the Oracle cloud infrastructure service console
through SQL/developer
Through SQL*Plus
Which three Oracle cloud infrastructure resources do you need to configure before provisioning your autonomous database in a private endpoint?
Subnet
Route Table
Security List
VCN
Network Security Group
Which three event types are supported for autonomous databases? (Choose three)
Update IORM Begin
Maintenance Begin
Terminate End
Change autoscaling compartment
Change compartment begin
1. You see a clock icon in the status column on the SQL monitoring tab of the performance hub. What does it indicate?
The SQL statement is executing
The SQL statement did not complete either due to error or issue
The SQL statement is queued
The SQL statement completed its execution
1. Which three are the use cases for graph studio? (Choose three)
3-D modelling
Churn analysis
Pattern matching
Facial recognition
Clustering
Which native data type is used to store spatial information?
SDO_POSITION
SDO_WITHIN_DISTANCE
SDO_GEOMETRY
SDO_DESTINATION
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?
You cannot use Python with ADB
SQL Developer
The Oracle Client and the cx_Oracle interface for Python
JAVA JDK
1. What is the difference between autonomous data warehouses and autonomous transaction processing databases?
Only ATP manages optimizer statistics
Only ADW supports autoscaling
Only ATP supports automatics backups
Only ADW uses columnar compression by default
Which three options are supported when migrating your existing Oracle database to Autonomous Database (ADB)? (Choose three.)
Use Golden Gate
PDB unplug / plug operation
Use Oracle zero downtime migration (ZDM)
Use data pump
Use Dataguard
1. Which two cloud services are supported to import data pump files to the autonomous database on dedicated infrastructure?
Amazon S3
Oracle Cloud Infrastructure Object Storage
Azure Blob Storage
Google Cloud Storage
Oracle Cloud Infrastructure Object Storage Classic
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)
Select the backup from which restore needs to be done.
Backup and recovery must be done using Recovery Manager(RMAN).
Select the archived redo logs.
Specify the point in time (timestamp) to restore.
Select the snapshot of the backup.
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?(Choose the best answer.)
Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.
Autonomous Data Warehouse workloads are optimized for mixed workloads.
Autonomous Transaction Processing memory Usage optimizes workloads for parallel joins and aggregations.
Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure? (Choose two.)
Users have OS access to the database machine.
It offers greater control and isolation starting at the Exadata cloud infrastructure level.
Users can customize the OS stack and add additional packages.
Users have more control over the maintenance schedule.
Your customer has migrated 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 the autonomous database (ADB)?
Create a database link from source database to the ADB environment and clone the PDB
Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
Unplug to an xml file so database files and xml file can be uploaded to object storage.
Unplug into a pdb archive which can be uploaded to object storage.
Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.Which statement is FALSE?
Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.
Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.
Oracle Data Safe only supports Autonomous Databases.
Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
Which statement is false about setting up compartment quotas?
Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
There are three types of quota policy statements which are set, unset and zero.
Compartment quotas cannot be set on root compartment.
Which two statements are true about using an Autonomous Database with Private Endpoints? (Choose two.)
Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.
You can configure Private Endpoints for an Always Free Autonomous Database.
A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints.
An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.
How do you change the tablespace quota for user MTHEO on an autonomous database on shared infrastructure?
Execute alter tablespace DATA set quota = 10G;
Execute alter tablespace for user MTHEO tablespace DATA quota = 10G;
Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username=>’mtheo’, tablespace_quota=>’UNLIMITED’;
Execute alter user MTHEO quota unlimited on tablespace DATA;
An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a 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? (Choose the best answer.)
Delete the user.
Rotate the instance wallet and share the new wallet with the remaining users.
Shutdown and restart the instance.
Trust the user who left to not access the database.
When cloning from a backup what is the earliest timestamp of the backup allowed?
30 minutes
2 hours
1 hours
24 hours
Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of CPU 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?
The base number of OCPU cores allocated to a database is not guaranteed.
Auto scaling is enabled by default and can be enabled or disabled at any time.
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.
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.
Which statement is false about Oracle autonomous Json database?
JSON data is natively stored in the database.
You can promote JSON database to atp
It supports NoSQL-style, document-centric applications
There is a 20gb storage limit for JSON collections
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 data tools. Which steps do you need to perform?
Create an IDCS user. Create a database user with connect, resource, and object privileges.
Create a REST-enabled database user (with connect and object privileges) and grant the DWROLE role.
Create a database user with the default privileges.
Create a database user with connect, resource, and object privileges.
In the autonomous database on dedicated infrastructure service, what does the fleet administrator use to control OCPU utilization?
Oracle Machine Learning notebook
Compartment quotas
SQL Developer Web Console
Resource Manager settings
1. Which method will not permit you to change the database admin user’s password of an Oracle order numbers database on shared infrastructure?
OS command line from the database server
OCI CLI
SQL developer
Admin page of the cloud console
Which database action tool is used to get information about the entities in your Autonomous Database and to see the effect that changing an object has on other objects?
Data Load
Data Catalog
Data Insights
JSON
Which three are Oracle recommended best practices for autonomous database alarms?
Select the Correct Alarm Interval for your Metric
Suppress Alarms During Investigations
Create multiple alarm metrics
Routinely Tune Your Alarms
Create a single alarm for each metric
Which set of options can be specified when defining the preferred maintenance schedule for the Exadata infrastructure for autonomous database dedicated?
week of the quarter, day of the week, start hour
The month of the quarter, week of the month, day of the week ,start hour
Quarte r of the year, week of the month, day of the week start hour
The month of the year, week of the month, day of the week ,start hour
1. You have been tasked with analyzing a year’s worth of sales data stored in an autonomous data warehouse instance. Which tool would you use to automate data exploration and create pivot tables?
Business models
Data catalog
sql developer web
APEX
1. Which statement is true about the use of access control lists with an autonomous shared infrastructure?
ACL can only be used with private endpoints.
ACL can be set only during creation of an autonomous database on shared infrastructure.
An ACL can be setup for an IP address or virtual cloud network but not both at the same time.
When you restore a database, existing ACS are not overwritten by the restore.
Which statement is correct with respect to the required action to move Oracle autonomous database resources to a different compartment?
Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
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
You do not need to have sufficient access permissions on the compartment that the resource is being moved to.
Moving an Autonomous Database instance does not include its automatic backups.
1. Which option should you use to create graphs with graph studio?
NoSQL configuration
Tables in an autonomous database.
A graph license key
Graph analytics algorithms
With three advanced options can you enable or disable while creating a business model?
Business object security feature
Analytical view transparency view
Autonomous aggregate cache
Display private tables
analytical view base table query transformation
You need to set up a notification for a scheduled shutdown of an autonomous database instance. What should you do?
Add a 'before shutdown on database' trigger within database.
Create a notification alert using DBMS_SNMP package
Create a rule for the oracle cloud infrastructure event for “autonomous database STOP END”.
Create an oracle cloud infrastructure alarm for shutdown metric.
1. Which three of the data sources are available when using Data Load page on Database actions?
Local files
REST API endpoints
Files in aws s3 storage
files in oracle cloud storage
1. Which three options do not change when enabling auto-scaling?
Number of OCPUs displayed in the console.
Amount of storage
parallelism settings
I/O resources
Level of concurrency
1. Which command should you issue to enable application continuity on Oracle autonomous database on shared infrastructure?
alter session set application_continuity ="true"
alter database set application_continuity ="true"
exec dbms_cloud_admin.enable_app_cont(‘’);
alter system set application_continuity ="true"
Autonomous database’s auto-scaling feature allows your database to use up to three times the current base number of o CPU 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?
Auto scaling is enabled by default and can be enabled or disabled at any time.
The base number of CPUs allocated to a database is not guaranteed.
For dedicated, maximum cores depend on the dedicated number of slots available
Auto scaling can be done upto 3 times.
1. Which four file formats are supported when loading data from cloud storage?
parquet
avro
csv
txt
json
Which set of Oracle cloud infrastructure metrics is available only for autonomous databases on dedicated infrastructure?
CPU utilization, storage utilization
IOPS, storage space used by tablespace, apply and transport lag.
Query latency, user calls, execute count
Transaction count, sessions, running statement
Where are customer-managed encryption keys stored for autonomous databases on dedicated infrastructure?
on the exadata infrastructure where autonomous database is hosted
Inside the autonomous database wallet
In a separate key vault external to the Exadata infrastructure.
Inside the backups of the container database.
When using data pump to migrate oracle database to autonomous database, which two objects are imported?
Schemas
Tablespaces
Reports
Data
1. Oracle autonomous database on dedicated infrastructure is composed of which Oracle cloud resources?
Autonomous Exadata infrastructure, autonomous backup, autonomous container database, and autonomous database.
VCN, Compartment, policies and autonomous exadata infrastructure.
fleet administration, database administration, database user, and autonomous exadata infrastructure.
Oracle machine learning zepellin notebook, fleet administration, and database administration.
1. Which two statements are true about data insights?
Data insights is available with on-premise deployments of oracle database.
You can search for data insights against a base table or business model.
It is an additional priced option.
You can retrieve previously executed data insight searches
1. Which two of the following statements are correct?
ODI web edition can be installed from the Oracle cloud infrastructure (OCI) marketplace.
After finding Oracle Data Integrator on Oracle Cloud Marketplace, click put
The data transform card provides access to the Oracle data integrator (ODI) web edition.
It is charged
1. While provisioning a dedicated autonomous container database with backup retention cannot be implemented?
120
60
15
7
1. Which stage of the indexing pipeline divides the text into tokens?
Filter
Sectioner
lexer
Indexing engine
1. Which two actions are available to perform an autonomous database is stopped?
Update license type
Update ADMIN password
Start
Update network options
What happens with the standby database when disabling autonomous data guards?
The standby database is terminated
The database is paused
It provides a backup of the primary database
No action is done.
1. Data guard is enabled for autonomous database and the life cycle state field for primary database indicates that it is stopped. Which statement is true?
The standby state shows failover
The standby database is also stopped
The standby state shows switchover
It keeps running.
1. Which three tools can be used to monitor the usage and activities of the autonomous database on dedicated infrastructure?
Logs
Performance Hub
OCI metrics
Enterprise manager cloud coontrol
1. You have a requirement to create An autonomous transaction processing database that can support up to 300 concurrent statements per CPU as well as parallelism with service will you need to connect to?
HIGH
TP
TP_URGENT
LOW
1. Which tool license types does a customer need to benefit from bring your license (BYOL) leveraging on-premises enterprise database license in Oracle autonomous database?
Active data guard
real application clusters (RAC) but only when scaling beyond 16 OCPUs.
Transparent data encryption
Exadata
Multitenant
1. You need to create a new database by using the OCI interface. Which parameter should you not use?
license-model
is-dedicated
db-type
db-workload
Which statement is correct about service console in an autonomous database?
You can use the service console to move an autonomous database between compartments.
You can use the service console to manage runaway SQL statements on an autonomous database.
You can use the service console to enable or disable autoscaling of an autonomous database
You can use the service console to create manual backups of an autonomous database.
1. In which four ways can Oracle database optimally access data in object storage?
Scan avoidance using blocking skipping for .csv files.
Scan avoidance using columnar pruning for the columnar stores like parquet and orc
Optimized data archive using hybrid partition tables
Optimized data archive using partition external tables
Scan avoidance using columnar pruning for .csv files.
1. Which is not needed to manage Oracle autonomous database with the rest APIs?
User's OCID
Fingerprint of the public key
Tenancy's OCID
Database ADMIN password
1. Which statement is false about autonomous database maintenance on dedicated infrastructure?
Autonomous Exadata infrastructure maintenance takes place atleast once each quarter.
If a scheduled maintenance does not take place, Oracle automatically reschedule the maintenance for the next quarter.
Autonomous Exadata infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating system updates) and include container database patching.
You can change your container database maintenance window or reschedule the maintenance.
1. 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?
The container database in which the autonomous instance should run.
Compartment of the dedicated infrastructure.
The listener endpoint where the autonomous database should register on.
The client credentials wallets.
1. Which statement is true about connecting a marketplace Oracle cloud infrastructure (OCI) image to an autonomous database on shared infrastructure?
The marketplace OCI image can be used with an always-free autonomous database account.
You can provision up to three Always Free Autonomous Databases in the home region of your tenancy.
You can create an Always Free Autonomous Database in any Home Region where Always Free Autonomous Databases are not supported
1. 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 their bottleneck?
Each process reads a recovery checkpoint to its checkpoint file on a regular schedule.
Increase the number of OCPUs allocated to the database.
Restart the database and reload the data as well
If there are I/O waits on the disk subsystems that contain the trail files, don'tput the trails on the fastest disk controller possible.
1. Which three options are available to access data in the autonomous Json database?
Rest API calls to database (not enabled by default)
There is 20gb storage limit on json database
Oracle cloud infrastructure console using the Json online developer tool.
NoSQL statements using Oracle soda drivers.
