OCI 2022

Which TWO statements are true when enabling autonomous Data Guard on Autonomous Exadata. (Choose all correct answers). Autonomous databases inherit their Data Guard configuration from their Autonomous Container Database. Data Guard can be set per individual Autonomous Database within a Container Database. Data Guard is not currently supported on Autonomous Exadata Cloud@Customer. Autonomous Data Guard only supports Maximum Performance and Maximum Protection protection modes. When in a Data Guard configuration patching will always take place on the standby database first.

Which system configuration is offered by the Oracle Database Exadata Cloud Service?. Each system configuration starts with a fixed amount of memory and storage resources. Each system configuration starts with a fixed amount of OCPU and storage resources. Each system configuration starts with a fixed amount of OCPU, memory, storage, and network resources. Each system configuration starts with a fixed amount of OCPU, memory, and network resources.

What permissions do you need to perform actions on a NoSQL table?. NOSQL_TABLE_INSPECT, NOSQL_TABLE_UPDATE. NOSQL_TABLE_WRITE, NOSQL_ROWS_INSERT. NOSQL_TABLE_DESTROY, NOSQL_TABLE_ALTER. NOSQL_ROWS_READ, NOSQL_ROWS_DELETE.

You notice that throttling is occurring on your NoSQL Database Cloud Service. What must you increase to solve this?. storage capacity. storage capacity. index size. OCPU for all servers in the cluster.

In addition to the automatic backup of your Oracle Database associated with a database deployment, you are planning to take an on-demand backup of a database on Exadata Cloud Service. How do you do this?. Disable the automatic backup configuration and then take an on-demand backup. First connect to the Exadata Cloud Instance as the oracle user and then take a backup. Use the Create Backup button in the backup section of the Database Details page. Perform a recovery operation to a specific long-term backup.

Which service is used by default by the MySQL Database Service to store user data to make it more resistant to failures?. File Storage. Data safe. OCI Block Volumes. Object storage.

Your MySQL Database Service system is automatically backed up between midnight and 1 AM. What must you do to change the starting time to 4 AM?. Use the mysqlbackup command to establish a 4 AM backup start time. Edit the OCI MySQL DB System Details to set the Enable Automatic Backups time to 4 AM. Update the Oracle Cloud Infrastructure (OCI) MySQL DB System Details page to specify the 4 AM backup window start time. From the Edit MySQL DB System Details page, select Backup Window and set the start time to 4 AM.

You used the "Stop" option from the Console of an Exadata Cloud Service virtual machine within a VM cluster. What impact does this have?. The Exadata Cloud Service is stopped. All the virtual machines in the VM cluster are stopped. All the databases and infrastructure associated with the Exadata Cloud Service are stopped. The Stopped virtual machine is not available to any other database deployment.

How many IP addresses do you need at a minimum for the client subnet when you plan to have four Exadata compute nodes on Exadata Cloud Service?. 32. 14. 4. 18. 8.

You have been brought in to help a company with slow nightly batch processing running on their Exadata Cloud Service. You have determined the workload is CPU-bound during the batch window. Which command line tool can be used to script increase or decrease OCPUs?. oci cli. ocpucli. exacli. asmali.

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?. Tcp traffic only for port 1521 and port 22. Enable egress Tcp traffic only for port 1521. Tcp traffic only for port 22. Open for all protocols.

You want to permanently delete the DB System and its attached HeatWave cluster. Which action should you perform?. Terminate the DB system and drop the associated HeatWave Cluster. Delete the Heatwave Cluster and it will also delete the DB system. Delete the DB system and it will also delete the attached HeatWave Cluster. Drop the DB system and terminate the associated HeatWave Cluster.

Patching requires role permissions. However, since roles are not granted by default, which role needs to be added to someone patching the DB system?. Let security admins manage vaults, keys, and secrets. Let database and fleet admins manage Autonomous Databases. Let database administrator's manage DB systems. Let users manage compute instance configurations, instance pools, and cluster networks.

After you have provisioned a virtual machine (VM) database (DB) system, what action can you take to meet changes in block storage requirements?. After you have provisioned a VM DB system, you cannot increase or decrease block storage. If a vm DB system requires more block storage, increase the storage at any time without impacting the system. If a vm DB system has different requirements for block storage, increase or decrease the storage at any time without impacting the system. Only bare metal DB systems can increase block storage at any time without impacting the system.

Which tool should you use to run the LIST FLASHCACHE DETAIL command in the Exadata Cloud Service environment?. cellcli. OCI CLI. dbaascli. exacli.

Which characteristic is NOT a factor that impacts the capacity units for provisioning a NoSQL Database Cloud Service table?. record size. data model. query pattern. durability level.

Which 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?. No action can be taken, because a new backup location cannot be set after creation. Change the database backup location to local storage backups and set retention to 45 days. Change the database backup location to an NFS backup location with a 45-day retention period set. Change the database backup location to Object Storage with the default retention period set.

You enable automatic backups on your Exadata Cloud@Customer.?. database archivelog files. database control files. Transparent Data Encryption (TDE) keystore (wallet). server parameter file (SP file).

Which network is used to facilitate the secure monitoring and administration of Oracle-managed infrastructure components in Exadata Cloud@Customer?. InfiniBand network. Backup network. Client network. Control plane network. Cloud operations network.

Which tool can be used to monitor a storage server in Exadata Cloud Service?. OCI CLI. ocpucli. exacli. dbaascli.

Assume that there are no resource limits on your underlying Exadata Cloud@Customer hardware. What is the maximum number of Autonomous container databases that can be created on one Autonomous VM cluster?. 12. 4. 5. 32.

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 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. 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.

What can you use to enable an on-premises Enterprise Manager instance to monitor Exadata Cloud Service in a private OCI subnet?. virtual Cloud Network (VCN). Client subnet. Virtual Network Interface Card (VNIC). FastConnect.

How many DB systems must you provision before you can enable Oracle Data Guard for a virtual machine DB system database?. It depends on how many standby databases you want for your primary database in the Oracle Data Guard configuration in Oracle Cloud Infrastructure. Three, first for the primary database, second for the standby database, and a third for the staging database in the Oracle Data Guard configuration. Two for both the primary and standby database, because a DB system with the database that you want to use as the standby must already exist before you enable Oracle Data Guard. One with the primary database, because a new DB system with the standby database is created and associated with the primary database when you enable Oracle Data Guard.

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?. Download the latest patch from MOS, back up your database, run a precheck, then apply the patch on the database home. Own two Oracle Homes (OH193_A and OH193_B), each with a test database (193A and 193B respectively). Back up your database, run a precheck, then apply the patch on the database home where the database resides. Download the latest patch from MOS, back up your database, and use dbaasc1i to apply the patch on the database home. Create a new database home, patch it to the version you want, and then move the database to the new home.

What NoSQL Database Cloud Service API statement can be used to adjust table capacity?. tableRequest. tableunits. tableLimits. tableProvision.

You want to move an Exadata Cloud@Customer VM cluster to a different OCI compartment for increased isolation from other teams that use Exadata. What happens when you use the console to do this?. The VM cluster and associated databases will move to the new compartment. All other resources will remain in the existing compartment. After it is deployed, a VM cluster cannot change compartments. The vm cluster, compute nodes, and associated databases will move compartments. All other resources will remain in the existing compartment. The vM cluster, compute nodes, and underlying Exadata infrastructure will move to the new compartment. All other resources remain the same.

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?. Create a Virtual Cloud Network by using the VCN Wizard. Create a Linux compute instance. Create the MySQL DB system. Connect to the MySQL Database Service system endpoint.

Which set of data types is supported by the NoSQL Database Cloud Service tables?. XML, JSON, array. Iong, double, triple. enum, map, record. Boolean, date stamp, float.

Which statement is FALSE about using compartments?. They allow you to isolate resources. They can be used to secure resources. They can be organized in a hierarchical fashion. They are a physical concept that separates users.

Which is NOT a prerequisite for patching Grid Infrastructure or database homes when using the console?. The /u01 directory on the database host file system has at least 15 GB of free space for the execution of Patching processes. Oracle Clusterware is down on the VM cluster. The required patch is available on the Control Plane server. All database compute nodes of the VM cluster are up and running.

What information is required to connect to the NoSQL Database Cloud Service?. API signing key, admin ID, user ID. signing key fingerprint, API signing key, tenancy OCID. user ID, tenancy ID, component ID. tenancy 1D, passphrase, handshake key.

How do you remove a MySaL Database Service backup from the Oracle Cloud Infrastructure system?. Select the database service and set the Backup Retention Period value to 0. Open the database, select the backup screen and click the Delete button. Select the database service and click the remove backup button. Open the backup details page by clicking on the backup's name, and click the Delete button.

What capability in the OCI Database Management Service is available using Database Groups?. Execute a SaL query for the databases. Install patches for the databases. View database log events. Predict long-term capacity trends for the databases.

Your company has decided on a Hybrid Cloud strategy and wants to monitor their cloud and on-premises Oracle databases. Which action should they take?. Use the cloud console to monitor all your Exadata systems that are on-premises or in the cloud from a single interface. Configure the cloud console to send notifications about cloud Exadata systems to the on-premises Enterprise Manager. Use Enterprise Manager to monitor all your Exadata systems that (Cor are on-premises or in the cloud from a single interface. Subscribe to cloud events to send custom notifications about cloud Exadata systems to the on-premises Enterprise Manager.

A database is running on Exadata Database Service on Dedicated Infrastructure in the public cloud. Which statement is true for Performance Hub?. Performance Hub with the Basic Database Management option delivers advanced features for monitoring Exadata, RAC Database Monitoring. SQL Tuning Advisor, Database Fleet Monitoring, and Database Administration features. Performance Hub provides Database Management features for Oracle Cloud Databases and is available as part of two management options (Basic and Full). Performance Hub is only available once you enable and pay for the Full Database Management option. Performance Hub in Basicor Full mode is free but Full mode requires more storage.

Exadata Database Service is started with BYOL as the license type. How can you change your license type?. Update the license type by submitting a service request (SR) to support. Use the Update License Type option on the VM Cluster details page to switch license type online. Use the Update License Type option on the VM Cluster details page to restart the VM Cluster with the desired license type. Use the Move database option to relocate to a new Database Home on the VM Cluster with the desired license type.

You are asked to create a MySalL Database Service system. You log in to the group's Oracle Cloud Infrastructure tenancy and access the assigned compartment, and find that all policies have been configured and tested. What is the next step to create a MySQL Database Service?. Create the MysQL DB system. Create a Virtual Cloud Network by using the VCN Wizard. Create a Linux compute instance. Connect to the MysaL Database Service system endpoint.

You want to move your VM Cluster to a different Oracle Cloud Infrastructure (OCI) compartment for increased isolation from other teams that use the Exadata Database Service in your tenancy. What happens if you do this?. The VM Cluster and the underlying Exadata Infrastructure will move to the new compartments. All other resources will remain in the existing compartment. The VM Cluster and its dependent resources will move to the new compartment. The dependent resources for a VM Cluster are the database homes, the databases, and their automatic backups. All other resources will remain in the existing compartment. The VM Cluster cannot change compartments, after it is deployed. The VM Cluster and associated databases will move to the new compartments. All other resources will remain in the existing compartment.

Which method must you use to patch databases on Exadata Database Service with the least amount of downtime?. Create a Data Guard standby and execute standby first patching. Conduct in place patching of the database Home. Leverage Opatch to execute patching the database Home. Leverage Patchmgr to execute patching the database Home. Move the database to a new Home with the desired patch level.

What is the minimum OCPUS per compute server allowed on Exadata Database Service on Dedicated Infrastructure (ExaDB-D) in the public cloud?. Minimum enabled OCPUs for ExaDB-D must match your BYOL entitlement. Zero enabled OCPUS per compute server is allowed for ExaDB-D. Four minimum enabled OCPUS per compute server are allowed for ExaDB-D. Two minimum enabled OCPUS per compute server are allowed for ExaDB-D. Four minimum enabled OCPUS per compute server are allowed for ExaDB-D.

Which versions are currently supported in Exadata Cloud Service?. X6, X7, X8, and X8M. X7 and X8. X6 and X7. X5, X6, X7, and X8.

What is the maximum number of Enabled CPU Cores in Oracle Exadata X8M-2 Full Rack System?. 100. 200. 400. 500.

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

When configuring connectivity for hosts in the VCN, security lists contain defaults for implementing security rules. Which TWO additional rules are needed for database systems? (Choose all correct answers). allows SQL*NET traffic from within the VCN. allows ONS and FAN traffic from within the VCN. allows SSH traffic from anywhere. allows Path MTU Discovery fragmentation messages.

Which three actions can you perform on a DB system that has an Oracle Data Guard association with a standby database? (Choose all correct answers). If the primary database becomes unavailable, then you can use Oracle Data Guard to fail over the standby database to the primary role. You can write on both primary and standby databases because DB system standby databases in Oracle Cloud Infrastructure Database are logical standbys. You can terminate a primary database DB system. You can use the reinstate command to return a failed database into standby role after correcting the cause of failure. You can switch over the primary database to the standby role, perform maintenance on the standby database, and then switch it back to the primary role.

While using virtual machines (VMs), the next step after selecting a shape for the DB system is to select storage options and configuration. Which TWO configurations can be selected and used?. mount block storage locally to the node. Configure storage to assign 40% to DATA and the rest to redo logs and archive logs. Use Object Storage buckets for DATA, redo logs, and archive logs. Use Automatic Storage Management (ASM) for the storage management software.

Which two statements are true about changing the shape of a virtual machine (VM) database (DB) system to adapt to changes in performance needs? (Choose all correct answers). After you provision a VM DB system with a shape that supports Oracle RAC, you can change that shape to another shape that does not support Oracle RAC. After you provision a VM DB system, you cannot change the shape. You have to provision another VM DB system using a full backup. The shape of a VM DB system can be changed at any time, with no impact on the amount of storage available to the DB system. It is possible to change the shape of a VM DB system with a higher number of OCPUs. However, reducing the number of OCPUs is not permitted. If the current shape of the VM DB system supports Oracle Real Application Clusters (RAC), then you can only change that shape to another shape that also supports Oracle RAC.

Which three statements are true regarding MySQL Database Service HeatWave? (Choose all correct answers). Heatwave is a in-memory, query-processing engine designed for fast execution of analytic queries. Heatwave is Exclusively available in Oracle Cloud Infrastructure. Heatwave uses machine learning to automate operations, increasing DBA productivity and reducing costs. HeatWave data which is needed for analytic processing is stored in disk files.

Which are THREE strategies to migrate Oracle Database to Oracle Cloud Infrastructure (OCI)? (Choose all correct answers). GoldenGate. Zero Downtime Migration (ZDM). Autonomous migration. Real Application Clusters (RAC). migration workbench.

Which THREE Oracle Cloud Infrastructure (OCI) services can be used to connect to on-premises networks? (Choose all correct answers). Internet Gateway. Fastconnect. Dynamic Routing Gateway (DRG). Service Gateway. IPSec VPN.

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 Infrastructure monitoring methods should you use? (Choose all correct answers). data points. metrics. notifications. alarms. queries.

What THREE steps must you perform to connect to a MySQL database in the database system by using SSH and MySQL Shell?. Add an ingress rule for port 20. Instantiate MySQL Shell on the MySQL database system instance. (Start MySQL Shell on the compute instance). Connect to the MySQL Database Service instance. SSH into the compute instance from your local machine. Start MySQL Shell on the compute instance.

What TWO reasons do you need a minimum of three storage cells when using Exadata Cloud Service? (Choose all correct answers). for high availability. for Fast Start Failover of storage cells. for Data Guard. for Real Application Clusters. for triple mirroring of data.

Which two circumstances are FALSE when you use the Console to recover a DB system database from a backup stored in Oracle Cloud Infrastructure Object Storage? (Choose all correct answers). The DB system has no access to the Oracle Cloud Infrastructure Object Storage service location where the backup is stored. You want to restore to an existing System Change Number (SCN). Data Guard must be disabled, or you must first remove the Data Guard association by terminating the standby database before you can restore the database. Restore the database from an unmanaged backup in Object Storage created directly by using RMAN. Restore the database from a backup in Object Storage that was created by using the Console or the API.

You want to connect to your MySQL DB system's endpoint. You create an Oracle Linux compute instance on the same Virtual Cloud Network as your MySQL DB system. Which TWO actions must you perform to connect to your MySQL Database Service system? (Choose all correct answers). Install the MySQL client on your local computer. Define a SQL Developer connection in your MySQL Database Service database system. Connect to your database system by using the MySQL client on the Linux compute instance. ssh into the compute instance from your local machine.

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). It patches the MySQL server itself along with any underlying hardware. It analyzes, rebuilds, and optimizes MySQL database tables and indexes. It patches the underlying operating system of the MySQL database. It upgrades the associated compute instance to the latest Linux operating system version.

You can manage and monitor performance of an autonomous database running on autonomous Exadata Cloud @ Customer using the Performance Hub. Which two actions can be undertaken by Performance Hub? (Choose all correct answers). Configure auto indexing. Kill a running SQL session. View ASH Analytics. scale OCPUs for an autonomous database. Configure IO resource management (IORM).

Which FOUR storage options are available in Oracle Cloud Infrastructure (OCI)? (Choose all correct answers). Local storage. Object Storage. EFS Storage. Block Storage. File Storage. EBS Storage.

You want to scale within Exadata System. Which of the following two statements are true? (Choose all correct answers). The setting of database parameter CPU_COUNT is affected by modifying the number of enabled OCPU cores. Modifying the number of enabled OCPU cores does not require database downtime. Modifying the number of enabled OCPU cores requires database downtime. The setting of database parameter CPU_COUNT is not affected by modifying the number of enabled OCPU cores.

In a two-node Real Applications Cluster environment, the Internet and VCN Resolver are supported for DNS in the DB system. Which TWO tasks are required for the network setup? (Choose all correct answers). After the VCN is created, modify the DNS settings to use DNS Hostnames. when creating the database, specify a value in the Hostname Prefix. Select "Use DNS Hostnames in this VCN" as the VCN is being created. Select the hostname field for a DNS label when the subnet is being created.

Which TWO statements are true when deciding which Oracle Cloud Infrastructure (OCI) region to register an Exadata Cloud@Customer infrastructure in? (Choose all correct answers). Exadata Cloud@Customer is hosted in a customer data center so the Exadata infrastructure is not registered in an OCI region. Consider any business policies or regulations that preclude the use of a particular region. Consider the physical proximity of the region you register the infrastructure in to your data center. The Exadata Cloud@Customer region can be changed after the infrastructure is created. Consider which availability domain (within the region) to create the Exadata Cloud@Customer infrastructure in.

You are considering whether or not to implement bare metal or virtual machine shapes. Which TWO statements are true about bare metal and virtual machine (VM) database (DB) systems? (Choose all correct answers). Both bare metal and vm DB systems support two-node Real Application Clusters (RAC) systems. The Console, API, and Oracle Cloud Infrastructure CLI are options for managing bare metal DB systems. Bare metal shapes determine the total raw storage allocated to bare metal DB systems. Bare metal and VM DB can only have a single Database Home, and the single database will be the version of the Database Home.

The /u02 directory containing Oracle Homes (OH) is 80% utilized and you need to free up space in it. you own two Oracle Homes (OH193_A and OH193_B), each with a test database (193A and 193B respectively).You decide to consolidate both databases into a single Oracle Home (OH193. |_A) to free up space. Which TWO actions must you perform? (Choose all correct answers). use the Move Database option from the console. Schedule a downtime window with the Test teams who use the 193B database. Copy the sqinet.ora file from OH193_B to OH193_A. Create a new container under 0H193B and migrate the pluggable databases (PDBs) from 193B to 193A.

Which TWO statements are true about Interface for Exadata I/O Resource Management (IORM)? (Choose all correct answers). IORM allows workloads and databases to share I/O resources automatically according to admin defined policies. IORM can be enabled across multiple databases using the Cloud interface of Exadata Cloud Service. IORM allows workloads and databases to share I/O resources automatically according to user requests. IORM can be enabled across multiple Exadata Racks using the Cloud interface of Exadata Cloud Service.

Resources are allocated to the DB system based on the shape selected. Which TWO are options for a DB system? (Choose all correct answers). Two-node bare metal servers with 512 GB memory and locally attached drives. Two-node virtual machine X7 with Block Storage which can be scaled up. One-node bare metal server with up to 52 OCPU cores and locally attached drives to the system. One-node virtual machine XS with 24 OCPU cores.

Which two statements are true about recommended Subnet configurations for Exadata Database Service?. Use a Private Subnet for Client and Private Subnet for Backup. Use Regional Subnets for both Client and Backup. Use a Private Subnet for Client and a Service Subnet for Backup. Use two Public Subnets for Client and Backup. Use a Public Subnet for Client and a Service Subnet for Backup.

While configuring a Virtual Machines (VM) database (DB) system, the next step after selecting a shape for the DB system is to select storage options and configuration. Which two configurations should you select and use?. Use Logical Volume Manager (LVM) for the storage managementof single- node VM deployments. Configure storage to assign 40% to DATA and the rest to redo logs and archive logs. Use Automatic Storage Management (ASM) for the storage management software of single and two node VM deployments. Use Object Storage buckets for DATA, redo logs, and archive logs.

Which two key architecture choices lead to a compelling performance and cost advantage with HeatWave?. Data stored in binary JavaScript Object documents. Combination of Innodb and MyISAM tables to improve HeatWave performance. Innovative in-memory columnar analytics engine. Optimized for Oracle Cloud Infrastructure.

As part of your daily maintenance process, you log in to Oracle Cloud Infrastructure, select your DB system name, and select the Stop action. Which two statements are true about your stopped MySQL Database Service system?. You can no longer connect to a stopped MySQL database. Maintenance starts when the DB system is restarted. Any backups associated with the database system are deleted. The database system stops billing for all OCPUs associated with it. The database system is permanently deleted.

Which two must you create or configure to manage an external database?. dynamic group. database group. database handle. database connection.

Which two steps must be taken before installing a management agent for the Oracle Cloud Infrastructure (OCI) Database Management Service?. Install TLS 1.3 on the databases system. Patch the database to be managed. Confirm the OS and networking requirements. Create or copy an Agent Install Key. Create or copy an Agent OClID.

Which two external databases can be monitored by the Oracle Cloud Infrastructure (OCI) Database Management Service?. Oracle 18c Database deployed on Oracle Exadata Cloud@Customer. Oracle 11gR2 Database deployed on an Oracle Private Cloud. Oracle 12cR1 Database deployed on an Oracle Exadata Database Machine. Oracle Autonomous Database 19c deployed on an OCI Tenant.

Which two statements are true about cloning a Virtual Machine DB System?. When creating a clone, you must use the same SSH key and admin password as the source Virtual Machine DB system. Cloning createsa copy of a source Virtual Machine DB system as it exists at the time of the cloning operation, including the storage configuration software and database volumees. Cloning only creates a copy of a source Virtual Machine DB system as it exists at the time of the cloning operation, but does not include the storage configuration software and database volumes. When creating a clone of the Virtual Machine DB system, you need to specify a new SSH key and admin password.

Which two statements are true about monitoring a DB system in Oracle Cloud Infrastructure (OCI)?. Advanced Database Management features for Oracle Cloud Databases with the Full Management option is available at no additional cost by enabling the feature on the Database details page. Performance Hub is a time-based monitoring system that provides information only on CPU utilization and SQL query response times. You can view Database Metrics directly in the console with Virtual Machine DB Systems by navigating to Observability & Management and then selecting Database Management. You can view database performance analysis and tuning through Performance Hub, which provides only a consolidated view of historical performance data for comparative analysis. You can view database performance analysis and tuning through Performance Hub, which provides a consolidated view of real-time and historical performance data.

What three capabilities does the database fleet summary provide?. Compare database performance metrics over time. Execute a DDL command on the databases. View the current database resource usage. Migrate databases to OCl. View the status of the databases. View database log entries.

Which two are the minimum prerequisites to launcha DB system? (Choose all correct answers). Public key in OpenSH format. Virtual Cloud Network with default security list. Private key in OpenSSH format. Virtual Cloud Network with default service gateway. Dynamic Routing Gateway. Oracle Database Software Edition must be Enterprise Edition - Extreme Performance.

Which two statements are true about MysQL Database Service? (Choose all correct answers). It is a fully managed Oracle Cloud Infrastructure service. It is built on MySQL Community Edition. Its users need to perform database and operating system patching tasks. It is built on Gen 2 Cloud Infrastructure for superior performance.

Which are the two key components of a table in a NoSQL table? (Choose all correct answers). Index Component. Data Data Format. Table Capacity. Data Data Component.

Which three are stored in the OCI Database Connection Resource to connect to an External Database? (Choose all correct answers). DNS Hostname. Database name. User Credentials and role. Service name. DBID. Database OCID.