Your company's security policy requires you to patch the database within a month of a relevant database patch being released by Oracle.Which method requires the least amount of down time?
A. Download the latest patch from MOS, back up your database, run a precheck, then apply the patch on the database home.
B. Own two Oracle Homes (OH193_A and OH193_B), each with a test database (193A and193B respectively).
C. Back up your database, run a precheck, then apply the patch on the database home where the database resides.
D. Download the latest patch from MOS, back up your database, and use dbaasc1i to apply the patch on the database home.
E. Create a new database home, patch it to the version you want, and then move the database to the new home.
You are asked to measure useful quantitative data about a MySQL Database Service system. You must provide information such as current connection information, statement activity, latency, and host OCPU, memory, and disk I/O utilization. Which THREE Oracle Cloud Infrastructuremonitoring methods should you use? (Choose all correct answers)
A. data points
B. metrics
C. notifications
D. alarms
E. queries
Which is NOT a prerequisite forpatching Grid Infrastructure or database homes when using the console?
A. The /u01 directory on the database host file system has at least 15 GB of free space for the execution of Patching processes.
B. Oracle Clusterware is down on the VM cluster.
C. Therequired patch is available on the Control Plane server.
D. All database compute nodes of the VM cluster are up and running.
You define a maintenance window for your MySQL DB systems. When the automatic maintenance process takes place, which TWO activities does the system perform while its status is set to UPDATING? (Choose all correct answers)
A. It patches the MySQL server itself along withany underlying hardware.
B. It analyzes, rebuilds, and optimizes MySQL database tables and indexes.
C. It patches the underlying operating system of the MySQL database.
D. It upgrades the associated compute instance to the latest Linux operating system version.
While using virtual machines (VMs), the next step after selecting a shape for theDB system is to select storage options and configuration. Which TWO configurations can be selected and used? (Choose all correct answers)
A. mount block storage locally to the node.
B. Configure storage to assign 40% to DATA and the rest to redo logs andarchive logs.
C. Use Object Storage buckets for DATA, redo logs, and archive logs.
D. Use Automatic Storage Management (ASM) for the storage management software.
Which FOUR storage options are available in Oracle Cloud Infrastructure (OCI)? (Choose all correct answers)
A. Local storage
B. Object Storage
C. EFS Storage
D. Block Storage
E. File Storage
F. EBS Storage
When you created your development database on Exadata Cloud@Customer, you selected "None" for backup location during provisioning. You now need to enable automatic backups on the development database with a retention period of 45 days. Which action should you perform?
A. No action can be taken, because a new backup location cannot be set after creation.
B. Change the database backup location to local storage backups and set retention to 45 days.
C. Change the database backup locationto an NFS backup location with a 45-day retention period set.
D. Change the database backup location to Object Storage with the default retention period set.
In Exadata Cloud Service, you use Oracle Data Guard for disaster recovery. What is the minimum egress requirement needed to enable Data Guard between Exadata Cloud Services?
A. Tcp traffic only for port 1521 and port 22
B. Tcp traffic only for port 1521
C. Tcp traffic only for port 22
D. Open for all protocols
What THREE steps must you perform to connect to a MySQL database in the database system by usingSSH and MySQL Shell?
A. Add an ingress rule for port 20.
B. Instantiate MySQL Shell on the MySQL database system instance.
C. Connect to the MySQL Database Service instance.
D. SSH into the compute instance from your local machine.
E. Start MySQL Shell onthe compute instance.
You are asked to create a MySQL Database Service system. You can log in to the group's Oracle Cloud Infrastructure tenancy and access the assigned compartment, and all policies have been configured and tested. What is the next step to create a MySQL Database Service?
A. Create a Virtual Cloud Network by using the VCN Wizard.
B. Create a Linux compute instance.
C. Create the MySQL DB system.
D. Connect to the MySQL Database Service system endpoint.