1- What are TWO characteristics of Oracle SQLcl (SQL developer command line)?

 Create isolated development environments

 Tracks database schema changes
 Available in the OCI Cloud Shell by default
 Ability to execute SQL batch file

2- What set of NoSQL-style APIs can be used in autonomous JSON Database?

 DOSA (Document Open Solution Access)

 OSDA (Oracle Simple Document Access)
 SODA (Simple Oracle Document Access)
 OASD (Oracle Application Storage Definition)

3- Which TWO methods can you use to create or modify Oracle Cloud Infrastructure (OCI) resources?

 Serial console connection (SCC)

 OCI Command-line Interface (CLI)
 Remote Desktop Protocol (RDP)
 OCI REST APIs
 Secure Shell (SSH)

4- Which feature allows you to logically group and isolate your Oracle Cloud Infrastructure resources?

 Availability Domain
 Compartments
 Tenancy
 Identity and Access Management Groups

5- Which are TWO characteristics of Autonomous Transaction Processing (ATP)?

 Focuses on creation of indexes

 Create autonomous data summaries
 Stores data in columnar format
 Statistics are gathered as part of bulk load operations
 Optimized for response time

6- What are TWO typical reasons why customers CANNOT move their database into the public cloud?

 Total Cost of Ownership in public cloud is higher than on-premises

 Public cloud does not provide storage for more than 10TB
 Putting data in the cloud would break data residency rules
 Regulation that prevent moving data into the public cloud

7- What is the FINAL release supporting the non-CBS architecture?

 Oracle Database 21c

 Oracle Database 19c
 Oracle Database 18c
 Oracle Database 23c&
8- What is the Oracle recommended way to upgrade database?

 Command Line Upgrade

 Data Pump Export/Import
 AutoUpgrade
 Database Upgrade Assistant (DBUA)

9- What are TWO important reasons to upgrade and patch?

 Security
 Support Compliance
 Restructure the database
 Validation of application

10- Which TWO statements about ORDS are true?

 ORDS stores, manages and indexes JSON documents

 ORDS creates servlets for the Data Dictionary.
 ORDS is a low code development platform to build responsive applications.
 ORDS makes REST APIs in the Oracle Database available.

11- The Oracle Cloud Infrastructure (OCI) Data Catalog is an integral part of the Lakehouse solution.

What level of data detail does Data Catalog provide when integrated with Autonomous Databases and
Object storage?

 Analytic environments
 Data Warehouse
 View of data for discovery
 Source of managed services

12- Where should you store unstructured, high volume data sets of unknown value for best
price/performance?

 OCI Data Catalog

 OCI Object Storage
 OCI Data Flow
 OCI GodenGate

13- Which Lakehouse service should you use for serverless Spark processing?

 OCI Data Catalog

 OCI Data Flow
 OCI Object Storage
 Oracle Analytics Cloud

14- Oracle Data Lakehouse streamline the integration, storage, and processing of data.

Which two services are used for persistence of the data in Lakehouse?

 OCI Object Storage

  OCI GodenGate
 OCI Data Catalog
 Autonomous Database

15- Which statement is true about moving virtual machine (VM) database (DB) systems from one
compartment to another?

 You do not need access permissions to the compartment that the resource Is being moved to
when moving VM DB systems to a different compartment.
 You have to move dependent resources like Database Homes and databases to the destination
compartment before moving the VM DB system.
 You can move VM DB systems from one compartment to another by only using Oracle Cloud
Infrastructure REST APIs.
 You can move DB systems to a different compartment if you have sufficient access permissions
to the compartment that the resource is being moved to, as well as the current compartment.

16- Which two target database environments provide both high availability (HA) and disaster recovery
(DR) options in the cloud?

 Streaming Service
 Compute VM
 Exadata Cloud Service
 Autonomous Database

17- Which TWO locations can be used to store your DB system database backups?

 You can store your DB system database backups locally in the Fast Recovery Area of the DB
System.
 You can store your DB system database backups in Oracle Cloud Infrastructure Object Storage.
 You can store your DB system database backups on locally attached block storage volumes.
 You can store your DB system database backups in on-premises local storage.

18- What is the primary goal of Oracle Maximum Availability Architecture for customer systems?

 Data Protection, access and reporting

 Scale out, application availability and protection
 Continuous Availability, network security and failover
 Active Replication, Data Protection and continuous availability

19- Oracle & Automated Machine Learning (AutoML) has options for using in-database and opensource
algorithms.

Which is an example of an in-database option?

 Cognitive text
 Oracle Machine Learning for Python (OML4Py) APIs
 Tuning of hyperparameter
 REST Interface

20- Which Oracle Cloud Infrastructure (OCI) service is NOT available as part of Oracle Cloud Free Tier?
  Exadata DB systems
 Monitoring
 Autonomous Data Warehouse
 Compute

21- What is NOT a workload that can be selected when provisioning an Autonomous Database?

 APEX
 Data Warehouse
 JSON
 MySQL

22- The DBA has determined that number of OCPU assigned to an Autonomous Database does not
provide sufficient performance.

Which option does the DBA have in this case?

 Open the database in OCI Console and increase the number of OCPU. No downtime required.
 No downtime is required as number of OCPU can be increased from OCI console, but users have
to be informed that they must not use any application for at lease one hour.
 Call Oracle Cloud Support and raise a request to increase number of OCPU. Expect a downtime
of approximately one hour.
 Plan for a one-hour downtime and increase the number of OCPU while database offline.

23- What is NOT a feature of the Oracle Autonomous Database to protect data from external and
internal threats?

 Admin passwords are disable after provisioning

 Protects data from admin snooping using Database Vault
 Security updates are applied online
 Data is encrypted

24- Which TWO are key characteristics of Oracle Autonomous Database?

 Customer manages everything

 Lower cost
 Oracle manages everything
 Higher cost
 Less automated

25- What are the two main features of APEX’s low code platform?

 Use graphical user interfaces and configuration

 Use traditional computer programming paradigms
 Simplified core-based licensing
 Focus on business requirements
 Build scalable web apps for MongoDB
 Limited productivity

27- What are two main benefits of Oracle APEX?

  Rapidly develop, customize, and deliver secure applications
 Lease productivity compared to hand coding
 Faster development time using hand coding
 Store data in PL/SQL objects
 Develop responsive web apps

28- What three typical data types/models are covered by Oracle’s Converged Database?

 Images
 Relational
 Terraform
 Events
 Notification
 Spatial
 Graph

29- Which tool is provided to support Continuous Integration/Continuous Deliver (CI/CD) workflows?

 Database Actions (including real time SQL Monitor)

 SQLcl (including Liquibase)
 ADB console (including performance Hub)
 SQL Developer (Including ADB wallet)

30- Which is NOT an option in Database Actions to load data into Autonomous Database?

 Load data using FTP

 Load data using Data Pump
 Load data from cloud storage (Oracle, S3, Azure, Google)
 Load data from a local file such as text or Excel
 Load data from a remote database.

31- Which three data file formats can be loaded using Oracle Database Actions?

 CSV
 JSON
 VSAM
 AVRO

1. The Demand Side is data that is active and does something. What two data services are
typically part of the demand side?
 Data Models
 Inert algorithms
 Payloads
 Authorization

4. What information is required to connect to the NoSQL Database Cloud Service?

  signing key fingerprint, API signing key, tenancy OCID
 tenancy ID, passphrase, handshake key
 API signing key, admin ID, user ID
 user ID, tenancy ID, component ID

5. Which is NOT a resource type for NoSQL Database Cloud Service?

 Nosql-rows
 Nosql-tables
 Nosql-indexes
 Nosql-keys

6. What connections to multiple public clouds are provided through 3rd party connectivity?

 Layer 3 and FastConnect

 Megaport Cloud Router (MCR) and Virtual Cross Connect (VXC)
 Virtual Cloud Networks (VCNs) and Amazon Virtual Private Cloud (VPC)
 FastConnect and Direct Connect

7. In order to support multicloud strategies, what is offered as an industry first by Oracle?

 Oracle FastConnect
 Dedicated cloud region
 Cloud databases
 Private and public cloud network

8. Which security measure is implemented out-of-the-box, and is included if you are not using
BYOL licensing with Exadata Cloud@Customer?

 Database Vault and Data Masking Pack

 Oracle Key Vault
 Audit Vault and Database Firewall
 Oracle Native Network Encryption and TDE (Transparent Data Encryption)

10. Oracle Cloud and Microsoft Azure have an interconnect for workloads across cloud. Which
two are also benefits this partnership and interconnect provide?
 Low Latency
 Unified identity and access management
 Connection to other multicloud environments
 Upgrade compliance
11. Multicloud strategy eliminates the reliance of a single cloud provider but also provides which
two advantages?
 Compliance for use of specific geographies for data sovereignty laws
 Ability to have private clouds and maintain customer data centers
 Workload utilization of specific services
 Duplication of data and applications

15. Which deployment option provides the highest degree of security and governance while
providing a completely self-service database experience?
 Oracle Database Cloud Service
 Exadata Cloud Service
 Oracle Autonomous Database
 Oracle MySQL Database Service

20. What is a prerequisite of running APEX on an Autonomous Database?

 A DBA must enable ORDS first.
 APEX can only be used when selecting APEX as a workload when provisioning an
Autonomous Database.
 An Autonomous Database with the workload type Data Warehouse, Transaction
Processing, JSON or APEX.
 APEX can simply be installed by downloading the executable from OTN.
 A DBA must create APEX admin and APEX users first before starting APEX from
Oracle Cloud Infrastructure Console.

29. Which Oracle Cloud Infrastructure (OCI) Identity and Access Management (IAM) capability
helps you to organize multiple users into teams?

 Roles
 Users
 Groups
 Policies

30. A customer wants to use Oracle Cloud Infrastructure (OCI) for storing application backups
which can be stored for months, but retrieved immediately based on business needs. 

Which OCI storage service can be used to meet this requirement?

 File Storage
 Block Volume
 Archive Storage
 Object Storage (standard)

33. Which statement can be detected by monitoring of access to sensitive data?

  UPDATE quarter_reference set Q1='012022'
 CREATE index emp_id_idx on EMPLOYEES(emp_id);
 SELECT SYSDATE from DUAL;
 SELECT * from EMPLOYEES;

34. What security control area determines if there is sensitive data in a system?

 Assess
 Detect
 Users
 Protect

35. What are three platforms where Oracle's Autonomous Database service can be deployed?
 Oracle Cloud Infrastructure
 Oracle Public Cloud at Customer
 Dedicated Region Cloud at Customer
 AWS Cloud at Customer
 Hybrid Cloud Configurations

36. Which workload CANNOT be run on Oracle Database 19c?

 Translytical
 Machine Learning
 Gaming
 Hadoop Clusters

44. When Customers are using the Exadata Cloud Service, what are they responsible for
managing?

 Databases and Customer VM

 Hypervisor and Internal Fabric
 Host VM and Storag
 Internal Fabric and Customer VMs

45. Oracle ExaC@C brings the Oracle Cloud to the customer data center. The Oracle Cloud
Infrastructure is the same, but responsibilities are adjusted so that customer can perform which
two tasks?
 Allow network connections in the Oracle public cloud.
 Operator Access Control can terminate Oracle operator connections.
 Secure access configured to the customer network.
 Allow only the Oracle Staff to perform control access.
46. New hardware innovations of the Exadata X8M allow customers to take advantage of
Remote Direct Memory Access (RDMA). What resource does RDMA access?

 Persistent Memory
 Compute Instances
 Database Servers
 Storage Disks

47. Which two are objectives of Oracle's Data Management strategy?

 Offer multiple integration points for 3rd party databases that work better for mixed and
analytic workloads.
 Provide for the fastest, most scalable converged SQL database.
 Automate everything for developers, data analysts, DBAs and data scientists.
 Provide the best platform for warehouse workloads only.

51. Which two statements are true regarding MySQL Database Service HeatWave?
 HeatWave data which is needed for analytic processing is stored in disk files.
 HeatWave uses machine learning to automate operations, increasing DBA productivity
and reducing costs.
 HeatWave is a in-memory, query-processing engine designed for fast execution of
analytic queries.
 HeatWave uses periodic long-running ETL batch jobs to refresh the data.

52. Which service is used by default by the MySQL Database Service to store user data to make
it more resistant to failures?

 OCI Object Storage

 OCI Data Safe
 OCI File Storage
 OCI Block Volumes

53. Which statement is true about MySQL Database Service?

 Its users are responsible for database and operating system patching tasks.
 It is a fully managed Oracle Cloud Infrastructure (OCI) native service.
 It supports MySQL Enterprise Edition version 5.7 with InnoDB Storage Engine.
 It is a public cloud service built on MySQL Community Edition.

54. Which three are prerequisites for using the MySQL Database Service?
 You or your group must be granted the policies described in Mandatory Policies.
 You must download the latest MySQL version from https://edelivery.oracle.com/
 You must install the downloaded MySQL version onto Oracle Cloud Infrastructure
 You must create a tenancy and be able to sign in to it
 You must create a compartment to store your resources