1Z0-1093-25V2

Which statement is FALSE about a compartment?. After creating a compartment, you need to write at least one policy for it. It allows you to isolate resources. It can be organized in a hierarchical fashion. Compartments are not tenancy-wide, across regions.

Which statement is true about scaling storage for a Virtual Machine DB System?. You can independently scale the storage used by the VM DB System but the Available Data storage size cannot be decreased, whereas the Recovery Area storage size can be decreased. You must concurrently scale up the storage used by the VM DB System for the Available Data storage size and the Recovery Area storage size. You must concurrently scale up or down the storage used by the VM DB System for the Available Data storage size and the Recovery Area storage size. You can independently scale the storage used by the VM DB System but the Available Data storage size and Recovery Area storage size cannot be decreased.

Which tool should you use to run the LIST FLASHCACHE DETALL command in the Exadata Database Service environment?. exacli. dbaascli. cellcli. OCICLI.

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

Which two actions does the Cloud Exadata Infrastructure Resource NOT allow you to do?. Enabling Database Compute and Storage server expansion. Providing customers access to the Exadata Storage servers. Allowing customers to schedule Automatic Infrastructure maintenance. Allowing customers to execute Infrastructure maintenance.

Which component is NOT included as part of an Oracle NoSQL table Oracle Cloud Identifier (OCID)?. Region. Compartment ID. Resource type. Unique ID.

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

Where are the Automatic backups located when your Exadata Database Service is deployed in the public cloud?. Block Storage. NFS Mount. Recovery Appliance. Exadata Storage (RECO). Object Storage.

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

Which two actions does the Cloud VM Cluster Resource allow you to do?. Scale up and down the OCPUs to align with the workload demand. Schedule Infrastructure Maintenance. Manage networking, memory, storage, grid infrastructure, VM OS, database homes, and databases. Enable the addition of database compute and storage servers to support the expansion of the Exadata Database Service. Upgrade the Exadata System model to the latest version.

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

Which two database types are supported in the Database Management service?. MongoDB. Cloud, Oracle 19c PDB. On-premise, Oracle 10g. Cloud, Oracle 19c CDB. PostgreSQL. On-premise, Oracle 11g version 11.1.0.7.

Which is NOT a prerequisite for patching the Grid Infrastructure or Database Homes when using the console?. Ensuring that the /u01 (Gl Home) directory on the database host file system has at least 15 GB of free space before executing the Grid Infrastructure updates. Ensuring that all the database compute servers are of the VM Cluster type and are up and running. Ensuring that the Clusterware is down on the VM Cluster. Ensuring that the /u02 (DB Home) directory on the database host file system has 15 GB free space before a DB Home update.

Which two statements are true about Routing Tables?. A VCN uses the Routing Table to send traffic out of the VCN. A Routing Table controls ingress and egress rules, that specify the types of traffic allowed. You can delete the default Routing Table if it is not required. The Routing Table rules specify a destination CIDR Block and target. The default Routing Table is shared by all the Subnets in the VCN. The default Routing Table is shared by all the Subnets in the VCN.

Which option should you use to import data from an Object Storage bucket into a standalone Heat Wave DB system?. Use the object conversion import feature on an existing Heat Wave MySQL DB. Utilize the primary data load feature on a new Heat Wave MySQL DB. You can’t do this unless you convert the export file to a CSV file. Use the data import feature on a new Heat Wave MySQL DB. Invoke the Object Storage Replication feature on an existing Heat Wave MySQL DB.

Which statement is true about rebooting a virtual machine (VM) DB system node using the Oracle Cloud Infrastructure Console?. On the VM DB system details page, find the node that you want to reboot, click the Actions (three dots) menu for that node, and then click Reboot. Under Database, click Bare Metal, VM, and Exadata: select the DB system you want to reboot and then click Stop and Start after a few minutes under the Actions (three dots) menu. The VM DB system can be rebooted only from Oracle Cloud Infrastructure REST APIs or dhe 11. The VM DB system nodes cannot be rebooted individually. For multinode DB systems, you have to act on all the VM nodes concurrently.

Heat Wave MySQL enhances productivity by automating several time-consuming DBA tasks. Which three tasks does it automate?. Diagnosing database errors and bad queries. Patching the underlying operating system and updating the MySQL Server. Instant resource provisioning. Defining data access and retention policies. Backup and recovery.

Which statement is true about scaling OCPUs for a Virtual Machine DB System?. Scaling the OCPUs of a Virtual Machine DB System requires you to migrate to a new DB System. Scaling the OCPUs of a Virtual Machine DB System requires that the shape of the system be changed, which can be done online. For a 2-node RAC Virtual Machine DB System, the shape of the VMs changes without needing to reboot the VM nodes. Scaling the OCPUs of a Virtual Machine DB System requires that the shape of the DB system be changed.

The/w02 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 with test databases 193A and 1938, respectively. You decide to consolidate both databases into a single Oracle Home (0H193_A) to free up space. Which two actions must you perform?. Create a new container database under OH193B and migrate the Pluggable Databases (PDBs) from 1938 to 193A. Use the Move Database option from the console to relocate the database to the target Oracle Home. Schedule a downtime window with the team using the 193B database. Copy the sqlnet.ora and spfile from OH193_B to OH193_A and restart PDBs.

Which three are primary services of Heat Wave MySQL?. Bastion. OLAP. AutoML. Blockchain. Lakehouse.

You want to protect all the network communications between your organization network and Oracle Cloud using secure encryption and integrity algorithms. Which two statements are correct?. You should purchase TDE for your cloud environment. You should use AES, DES, and EBT certified cryptosystems that Oracle database provides for protecting the confidentiality of Oracle Net Traffic. You should consider leveraging FastConnect. You should consider leveraging a VPN. You should configure the database parameters to only allow connections from encrypted clients.

You want to view the status of the storage servers disks to check that they are all mounted. How would you get this information?. Query the storage servers disks status by using an exacli command. Query the storage servers disks status by using a dbaascli command. View the storage servers disks status from the console under the Exadata Infrastructure section. Raise a service request to get this information from Oracle Cloud Support.

What is the minimum Infrastructure usage commitment for Exadata Database Service on Exadata Cloud@Customer (ExaDB-C@C)?. ExaDB-C@C requires a minimum of 48 Hours usage commitment for the Infrastructure and OCPU. ExaDB-C@C requires a minimum of 30 Days usage commitment for the Infrastructure and OCPU. ExaDB-C@C requires a minimum 4 Year usage commitment for the Infrastructure. ExaDB-C@C requires a minimum of 48 Hours usage commitment for the Infrastructure.

What is the maximum number of DDL. operations per minute allowed by the NoSQL Database Cloud Service?. 10. 4. 5. 2. 1.

What is the NoSQLHandle interface NOT used for?. to access multiple tables. to set the row retention time. to gets rows from a table. to get dynamic information on a table.

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?. Maintenance starts when the DB system is restarted. Any backups associated with the database system are deleted. The database system is permanently deleted. You can no longer connect to a stopped MySQL database. The database system stops billing for all OCPUs associated with it.

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

Which NoSQL Database Cloud Service table consistency policy requires the allocation of 1 read unit?. Eventually. Session. Strong. Absolute.

Which components are you responsible for when patching with Exadata Database Service?. Database Homes, Grid Infrastructure, and Virtual Machine Operating System. Exadata Cloud Infrastructure and Database Homes. Oracle is responsible for patching all components. Exadata Cloud Infrastructure, Grid Infrastructure, and Database Homes.

What statement is FALSE about terminating a Virtual Machine DB System?. Full On-Demand backups remain in Object Storage as stand-alone backups. When terminating a VM Database System, it is important to note that the database data will be lost when the system is terminated. Terminating a DB system removes all Full On-Demand backups of the DB system from Oracle Cloud Infrastructure Object Storage. Terminating a DB system removes all automatic incremental backups of the DB system from Oracle Cloud Infrastructure Object Storage.

Which three actions can you perform on a DB system that has an Oracle Data Guard association with a standby database?. Use the reinstate command to return a failed database to the standby e standby role after correcting the cause of failure. Terminate a primary database in the DB system. Failover the standby database to the primary role if the primary database becomes unavailable. Switch over the primary database to the standby role, perform maintenance on the standby database,. Write on both primary and standby databases because DB system standby databases in Oracle Cloud Infrastructure Database are logical standbys.

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

Which two statements are true when enabling Data Guard on Exadata Database Service?. You can use Active Data Guard, which extends Oracle Data Guard capabilities by providing read/write functionality on the Standby or Disaster Recovery system. You should use similar configurations for your Primary and Standby databases to ensure you meet the same performance service level after a role transition. You can enable Data Guard to support your Standby or Disaster Recovery (DR) needs with a single API call or mouse click in the Ul using cloud automation. You must configure Data Guard manually to create the Standby or DR instance for your Primary Exadata Database. You cannot edit your configuration to change between synchronous or asynchronous transport of data to the DR site, after enabling Data Guard.

What feature does Optimizer Statistics in Database Management not perform?. View status of Automatic Statistics jobs by run statistics. Configuration of SPM Evolve Advisor tasks. View status of Manual Statistics jobs. View status of High-Frequency Statistics jobs.

Which two statements are true about using a Service Gateway?. The Service Gateway can connect to services in other regions outside of the VCN. The Service Gateway with a public subnet can be used to access Object Storage. The Service Gateway can connect to services in the same region of its VCN. The Service Gateway with a private subnet can be used to access Object Storage. The Service Gateway can be used to connect to the Internet.

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

Your existing Exadata Database Service X8M requires storage capacity that is outside the scope of the current system configuration. Which scaling option should you use?. Add more storage to existing storage servers of the Exadata system. Add more storage servers to an existing Exadata system configuration. Create a new Exadata system and move your databases to the new system. Move your databases to a different Exadata system configuration.

In addition to Automatic backups of your Oracle database, you want to take On-Demand backups of the database on Exadata a Datal Database Service on Dedicated Infrastructure in the public cloud. How can you do this?. Disable Automatic backup and then take an On-Demand backup. Connect to Exadata Database Service as oracle user first and then take an On-Demand backup. On-Demand backups are not allowed on Exadata Database Service because they use Automatic backups. Use the Create Backup button in the backup section of the Database Details page to take an On-Demand backup.

Which of the following is not a component of a Heat Wave MySQL DB System?. MySQL Community Edition. Oracle Linux Operating System. A compute instance. Virtual Network Interface. Network-attached block storage.

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 management of single-node VM deployments. 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. Configure storage to assign 40% to DATA and the rest to redo logs and archive logs.

Which two fall under the scope of “Customer Managed” for the Exadata Database Service?. Control and manage the Database Software. Control and manage the Hypervisor. Control and manage the Grid Infrastructure. Control and manage the Exadata Storage Server. Control and manage all Firmware & BIOS.

Which three Oracle Cloud Infrastructure monitoring methods should you use to measure useful quantitative data about a Heat Wave MySQL Database Service?. Notifications. Metrics. Alarms. Data points. Queries.

Which two statements are true about changing the shape of a virtual machine (VM) database (DB) system to adapt to changes in performance needs?. If the current shape of the VM DB system supports Oracle Real Application Clusters (RAC), then you can only change the current shape to another shape that also supports 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. After you provision a VM DB system with a shape that supports Oracle RAC, you can change the current shape to another shape that does not support Oracle RAC. 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. It is possible to change the shape of a VM DB system without impacting the amount of storage available to the DB system.

Resources are allocated to the DB system based on the shape selected. Which two are options for a DB system?. Single-Node Virtual Machine with Local Storage. Single-Node Virtual Machine with Logical Volume Manager (LVM) as the storage management software for the “fast provisioning”option. Two-Node Virtual Machine with Automatic Storage Management (ASM) as the storage management software. Two-Node Virtual Machine with Logical Volume Manager (LVM) as the storage management software.

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

What does HeatWave AutoML offer to users?. A graphical user interface that only supports data visualization without any model training capabilities. Limited access to machine learning model training, needs extensive manual coding for model deployment. A comprehensive set of tools for automatically optimizing database performance and resource allocation based on real-time workload analysis. A programming interface that can be used only with machine learning algorithms and Python. A simple SQL interface for training and using predictive machine learning models, accessible to both novice and experienced ML. practitioners.

You are asked to create a MySQL Database Service system. You log in to the group’s Oracle Cloud Infrastructure tenancy and access the assigned compartment, and find that all IAM policies have been configured and tested. What is the next step to create a MySQL Database Service?. Create the DB system using a compute instance via your VPN connection or Bastion session. Create the MySQL DB system. Create a Linux compute instance. Connect to the MySQL Database Service system endpoint. Create a Virtual Cloud Network by using the VCN Wizard.

Which two statements are true about Network Security Group Rules?. They must be applied to all VNICs on the Subnet. They can only be applied to a single Network. They can only be applied to Client Network. They can be applied to the Client and Backup Network. They can be applied to a Subset of VNICs.

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

When using the MySQL Shell ‘util.dumpinstance’ utility to migrate an on-premises MySQL instance to OCI, which of the following steps is required?. Create replication users on both the source and target databases. Create an Object Storage bucket. Configure Heat Wave MySQL nodes. Set up Heat Wave Replication. Add SSH key to MySQL DB Vault.

Which statement is true about a gateway?. A service gateway with a public subnet is required to reach Oracle Cloud Infrastructure services such as Object Storage. An Internet gateway with a private subnet is required to reach Oracle Cloud Infrastructure services such as Object Storage. You can use a dynamic routing gateway (DRG) to establish a connection with your on-premises network via IPSec VPN or FastConnect. You can use a DRG to establish a connection with your on-premises network via the database Service Gateway.

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 downtime?. Download the latest patch from MOS, back up your database, run a precheck, then apply the patch on the database home. 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 dbaaseli 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.

Which two statements are true when creating the Cloud Exadata Infrastructure Resource?. After provisioning an Exadata X8 Infrastructure Resource, you can scale the Exadata Database Service deployment online as needed by adding additional database and storage servers. After provisioning an Exadata X8M Infrastructure Resource, you can scale the Exadata Database Service deployment online as needed by adding additional database compute and storage server. You pick the desired hardware model arid a default VCN is created for you with a default subnet for Client and Backup traffic. When creating the Cloud Exadata Infrastructure Resource, you must pick an Exadata system model, a system configuration shape, and Availability Domain. You must pick an Exadata system model, a system configuration shape, and a license model.

Which users created on Database Servers can be used for both Oracle database and host management of your Exadata Database Service?. opc, oracle, and grid users. root, oracle, and grid users. root, opc, oracle, and grid users. root, opc, oracle, grid, and cloud users.

You used the “Stop” option from the Console of an Exadata Database Service virtual machine within a VM cluster. Which two statements are true?. All the databases in the VM cluster are stopped. All the VMs in the cluster are stopped. The stopped VM is not available to any other database deployment. Billing for the OCPU stops but billing for the Exadata Infrastructure continues. Billing for the OCPU and Infrastructure are stopped until the VM restarts.

What is true about scheduling Infrastructure maintenance?. Oracle provides you a choice of three maintenance windows to choose from. Customers do not have control over Infrastructure maintenance schedule because this effort. You can only choose the time of day that Infrastructure maintenance can be scheduled for. Customers can schedule the Automatic Infrastructure maintenance window.

What capability does HeatWave MySQL Lakehouse offer regarding data storage and querying?. It requires additional tools for handling machine learning. It processes a variety of file formats, such as CSV, Parquet, and Aurora/Redshift export files. It enables users to store and query only unstructured data formats,. It enables users to process and query data in OCI block storage. It allows users to query data only within MySQL databases.

You want to check if cloud tools are up-to-date in Exadata Database Service. Which two steps should you perform to obtain the current version of cloud tooling on a database server?. You must first connect to Exadata Cloud Service as opc and sudo to the root user. You must first connect to Exadata Cloud Service as the oracle user. Run the rpm -qalgrep -i dbaastools_exadata command. Run the dbaascli patch tools list command.

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

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

What preferred credential is not able to configure in the Database Management Service?. Administration. Advanced diagnostics. Super User. Basic monitoring.

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 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 and the underlying Exadata Infrastructure will move to the new compartments. 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.

You want to create a backup of only the data that was added or changed since the last FULL backup. Which type of supported backup by Heatwave MySQL Service must you use?. Differential plus binary logs. mysqldump. Mirror. Point-in-time backup. Incremental.

You have been brought in to help an organization with slow nightly batch processing running on their Exadata Database Service. You determine that the workload is CPU-bound during the batch window Which command-line tool would you use to script an increase or decrease in OCPUs?. ocpucii. dbnodecli. excacli. OCI CLI.

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?. There is an option to restore the database to a point in time. There is an option to restore the database to an existing System Change Number (SCN). There is an option to restore the database from an Automatic backup or On-Demand backup stored in Object Storage. There is an option to restore the database, but before that you must either disable Data Guard or remove the Data Guard association by terminating the standby database. The DB system has no access to the Oracle Cloud Infrastructure Object Storage service location where the backup is stored.

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

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?. Subscribe to cloud events to send custom notifications about cloud Exadata systems to the on-premises Enterprise Manager. 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 are on-premises or in the cloud from a single interface.

You use the Oracle Cloud Infrastructure console to create a Heatwave MySQL system. You give it the name “mysql” and set the administrator username to “mysql.sys”. You give it a data storage size of 50 GB and set the host name to "mysql-host." You do not specify a Maintenance Window start day and time. Which action causes an error?. Maintenance Window start time is required. Hostname should contain only letters. Username “mysql.sys” is reserved. Storage size is too small.

With Exadata Database Service, what is true about the available licensing models?. You can switch between licensing models as many times as you like, but it will require an outage. You can only switch from BYOL to License Included, once online. You can switch between licensing models as many times as you like online. You cannot switch from the License Included to BYOL.

Which statement is true about a Virtual Cloud Network (VCN)?. A VCN is subdivided into subnets, and subnets can only be Availability Domain specific with custom route tables and security rules. A VCN resides within a single Region, but can cross multiple Availability Domains. A VCN spans multiple Regions to facilitate failover requirements. A VCN resides within a single Availability Domain, but can cross multiple Regions.

Which statement accurately describes a Heat Wave cluster?. Modifications to MySQL data do not reflect within the Heat Wave cluster. A Heat Wave cluster is composed of several nodes that use File Storage for data retention. Each Heat Wave node has the capacity to store and process up to 100 GB of data. Each Heat Wave node hosts an instance of the Heat Wave query processing engine. Each node in a Heat Wave MySQL cluster operates independently, allowing for seamless scaling.

The Heat Wave MySQL DB system endpoints cannot be accessed directly from the internet. Which service can be used to establish a successful connection?. Windows PowerShell. MySQL Workbench on-premises. Linux or Mac terminal. MySQL Apache Spark. OCI Compute instance.

Which two statements are NOT true when creating the Cloud VM Cluster Resource?. You define the details for the client and backup subnets, number of enabled OCPUs, GI Version, and the License type to apply to your VM. You configure storage options to enable Exadata Snapshots. You only need to define the storage configuration, number of enabled OCPUs, GI Version, and the License type to apply to your VM. The VM Cluster contains the VM, database, SSH Keys, Management tools and the OS users (OPC, root, oracle, and Grid) required to manage the VM and Database. You define the number of database servers and storage servers to deploy.

Which three statements are true about Key Management on Exadata Database Service?. You can change key management type from Oracle-managed to Customer-managed keys after the database is created. You can choose Customer-managed keys or Oracle-managed keys when the database is created. You cannot use Oracle Cloud Infrastructure Vault to centrally manage encryption keys for the Exadata Database Service. You should rotate the Vault encryption key from the database details page on the Oracle Cloud Infrastructure Console. You must use the Vault service directly to rotate encryption keys every 24 hours.

What statement is FALSE regarding the differences between the Exadata Cloud@Customer X8M and X8 Infrastructure?. X8 uses InfiniBand for its internal network fabric whereas X8M uses ROCE. X8M has more total OCPUs available than an equivalent X8 configuration. X8M uses Persistent Memory (PMEM). Both X8M and X8 Exadata System models use InfiniBand for their internal network fabric.

Why is a dynamic group required as part of installing and configuring management agents for OCI Database Management Service?. To let the management agents carry on the communication with the OCI Monitoring service via Instance Principals. To let the management agents carry on the communication with the OCI Monitoring service via Resource Principals. To let the management agents carry on the communication with the OCI Management Agent service via Instance Principals. To let the management agents carry on the communication with the OCI Management Agent service via Resource Principals.

You are in the Database Admins group. To execute patching functions for DB Systems only in your tenancy, permission must be granted to your group. Because permissions are not granted by default, which permission needs to be added to the Database Admins group to allow you to patch the DB system?. Allow group Database Admins to patch db-systems in tenancy. Allow group Database Admins to manage db-systems in tenancy. Allow group Database Admins to manage db-systems in the DatabaseAdmins tenancy. Allow group Database Admins to patch db-systems in compartment.

What is true about scaling your Exadata Infrastructure in the cloud?. You can only expand a Base system by adding Compute and Storage servers offline. You must move between shapes to expand Exadata X8M. You can expand a Quarter Rack and a Half Rack X8M by adding Compute servers or Storage servers. You can expand a Quarter Rack and a Half Rack X8 by adding Compute servers or Storage servers online.

14. 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 in Basic or Full mode is free but Full mode requires more storage. Performance Hub is only available once you enable and pay for the Full Database Management option. Performance Hub provides Database Management features for Oracle Cloud Databases and is available as part of two management options (Basic and Full).

Which statement is FALSE about your options for the Data Guard protection modes?. Your choice of protection mode is set when Data Guard is enabled, but it can be changed at any time. Maximum Performance supports only the ASYNC transport type. Maximum Availability supports only the SYNC transport type. Data Guard in the Cloud is only available in Maximum Performance and Maximum Availability modes with the ASYNC transport type.

Which type of patch can you apply from the Exadata Database Service Console or by using the dbaascli patch db apply command?. Weekly Database Bundle patchset. InfiniBand Switch patches. Quarterly Database patches. Exadata Storage Cell patches. Daylight Savings Time (DST) patches.

How is data processed and distributed when loading a table into the Heat Wave MySQL cluster?. Data is directly read in columnar format and distributed based on the secondary key. The data is automatically distributed across all nodes based on the node’s processing capabilities. Data is read and sent sequentially, distributed randomly among the nodes. Data is read and converted at the destination node, distributed based on transaction ID. Data is read in batches, converted to columnar format, and distributed among nodes by slicing tables vertically.

Which is NOT an Oracle best practice for updating Virtual Machine DB System databases?. Run the precheck operation before you apply any update. Back up your databases before you apply any updates to your system. Patch the DB System before updating a database for DB Systems with Grid Infrastructure/ASM storage management. Ensure all servers and database instances are stopped before applying a patch to your DB system to avoid data corruption.