Serv

1.-Which three of the following does Base Database Service use to provide high availability and disaster recovery?. Compute Instances. Virtual Cloud Networks. Fault domains. Regions. Availability domains.

2.-Oracle offers a range of Database Services in Oracle Cloud. Which Database Service is built on standard compute and storage options, offers both Oracle Database Standard and Enterprise Edition, and is typically for workloads with smaller processing and storage requirements?. Base Database Service. Autonomous Database. Exadata Cloud@Customer. Exadata Database Service.

3.-Oracle Base Database Service provides a License-included Oracle Database consumption option. There are four licensing tiers of functionality to meet application-specific requirements. Which licensing tier has the Active Data Guard, RAC, and Database In-Memory features?. Standard Edition 2. Enterprise Edition High Performance. Enterprise Edition. Enterprise Edition Extreme Performance.

4.-Which OCI Management interface allows you to build and deploy apps that integrate with Oracle Cloud Infrastructure services?. Command Line Interface (CLI). Software Development Kit (SDK). Terraform and Ansible. Oracle Cloud REST APIs.

5.-Which two must first be in place in order to create an Exadata Database Service Instance?. You need to create an Exadata Infrastructure and VM Cluster resource. It is recommended to use a Public Subnet for Client and Service Subnet for Backup. You need to define the VCN, Private Client Subnet, and Private Backup Subnet. It is recommended to use 2 Public subnets for Client and Backup. It is recommended to use a Private Subnet for Client and Service Subnet for Backup.

6. Which two are true about the Cloud VM Cluster resource on Exadata Database Service?. It manages networking, grid infrastructure, OS, database homes, databases, and IORM. It enables scale up and down of OCPUs. It schedules infrastructure maintenance. It manages the infrastructure – database and storage servers.

7. Which three are reasons that make MySQL HeatWave better than the other MySQL cloud offerings?. Ease of use. Enterprise readiness. Security. Pricing.

8. MySQL HeatWave offers three flexible deployment options. Which deployment option is recommended for applications that require higher uptime or zero data loss?. The Standalone option. The High Availability option. The HeatWave option.

9. Which three are the MySQL HeatWave user responsible for?. Backup and recovery. OS installation. Defining data access and retention policies. Query design and optimization. Logical schema modeling.

10. Which is false about the Database Management Service?. It is a Managed service. It is integrated with other OCI services. It compares performance across different periods of time. It does not support on-premises and Oracle Cloud deployments on VM/BM, ExaCS, ExaCC, or ADB.

11. Which two are true about the Basic Management option?. The Basic Management option has ASH Analytics and SQL Monitoring features in Performance Hub for CDBs. The Basic Management option has Advanced Performance Hub features such as Automatic Database Diagnostic Monitor (ADDM) and Blocking Sessions. The Basic Management option is available for the Oracle Database Enterprise Editions and the Oracle Database Standard Edition at an additional service cost. The Basic Management option is available at no additional cost.

12. Which statement about AWR is false?. Using AWR Explorer, you cannot download various reports from the database. AWR is a built-in repository in the Oracle Database, which collects, processes, and maintains performance statistics of the database. AWR Hub is only available on Oracle Cloud Infrastructure Operations Insights Service. AWR Explorer in the Database Management service consists of performance and data visualization tools that display historical performance data from AWR snapshots in easy-to-interpret charts.

13. Which of the following is false about the automatic backup configuration settings?. For database deployments with Oracle Data Guard, automatic backups can be executed only on the primary site. Automatic backups are scheduled daily. There is a 7-day backup cycle with one full backup of the database taken every Sunday, followed by daily incremental backups. Archived redo log files are backed up every 3 hours.

14.- Which two statements regarding private endpoints are true?. You can create only one Database Management private endpoint in your tenancy (per region) to connect to single instance Oracle Cloud Databases in the Bare Metal and Virtual Machine DB systems. You can create only one Database Management private endpoint in your tenancy (per region) to connect to RAC Oracle Cloud Databases. You can create a maximum of five Database Management private endpoints in your tenancy (per region) to connect to single instance Oracle Cloud Databases in the Bare Metal and Virtual Machine DB systems. You can create a maximum of five Database Management private endpoints in your tenancy (per region) to connect to RAC Oracle Cloud Databases.

15. Which two are true about the Cloud Exadata Infrastructure resource required to provision Exadata Database Service?. It manages networking, grid infrastructure, OS, database homes, databases, and IORM. It enables the expansion of Exadata Database Service database and storage servers. It enables scale up and down of OCPUs. It schedules infrastructure maintenance.

16. Oracle NoSQL Database Cloud Service supports many common data types. Which three are data types that are supported by Oracle NoSQL Database Cloud Service?. Double. Char. Long. Binary. Date.

17. When you create your VCN, subnets, and Exadata VM Cluster, which three identifiers must you carefully set that are related to DNS in the VCN?. Subnet domain label. VCN domain label. Hostname prefix for the Exadata VM cluster. Gateway domain label.

18. Which statement regarding Exadata Database Service on Dedicated Infrastructure (Public Cloud) is false?. The Virtual Cloud Network must be in the same region where you want to launch Exadata Database Service. Custom Route Tables are required for each subnet along with the Security List rules to control the traffic to and from the client network and backup network. Before you can configure the required Networks for the Exadata Database Service, you must first use the OCI console or APIs to configure the VCN you plan to use along with networking components such as subnets, route tables, security list rules, gateways. One subnet is required in the VCN for the Client Subnet and Backup Subnet.

19. Which two are best practices for updating Virtual Machine DB system databases?. Before you apply any update, run the precheck operation. For single-instance, provision a Data Guard standby and update it first to maintain system availability. Back up your databases after you apply any updates to your system. Back up your databases after you apply any updates to your system. Patch the DB System after updating a database for DB Systems with Grid Infrastructure/ASM storage management.

20. Which statement regarding Data Regions is false?. A Data Region can have only one Region Identifier with its respective Oracle NoSQL Database Cloud Service endpoint. A Default Data Region is configured for the user based on the Oracle Cloud Account. A Data Region for Oracle NoSQL Database Cloud Service is a localized geographic area. The Oracle NoSQL Database Cloud Service can be accessed based on Data Regions using the service endpoints.

21. Which two are required in order to create and manage Exadata Database Service?. Security Lists. The appropriate IAM policies must be granted. The tenancy needs to have appropriate service limits. Use the Dynamic Routing Gateway (DRG) to establish a connection with your on-premises network via IPSec VPN or FastConnect.

22. MySQL HeatWave offers three flexible deployment options. Which deployment option uses an innovative in-memory analytics engine to provide 400x query acceleration for MySQL at a very compelling price and can be used for high volume with analytic processing?. The Standalone option. The HeatWave option. The High Availability option.

23. Which statement regarding MySQL HeatWave is false?. You cannot delete a HeatWave Cluster. All existing applications work without any changes. It is the only MySQL service with a massively scalable, integrated analytics engine. Extreme performance: Accelerates MySQL by orders of magnitude, scales to thousands of cores.

24. Which three are true of the Bring Your Own Licensing model?. Includes Transparent Data Encryption, Data Safe, Oracle Machine Learning, and select management packs at no additional cost. Includes Oracle Database Enterprise Edition with all options and management packs at one low price. Consumption-based pricing for software and OCPUs, includes software support and paid for with Universal Credits. Very-low, compute-only consumption pricing, paid for with Universal Credits. Utilize existing on-premises licenses and pay software support for them.

25. When it comes to connecting to the NoSQL Database Cloud service, you are going to need a series of connection credentials. Which connection credential is optional when it comes to connecting to the cloud service?. Signing Key Pass Phrase. Tenancy ID. User ID. Signing Key Fingerprint. API Signing Key.

26. What is a collection of related resources (such as cloud networks, DB Systems, or block volumes) that can be accessed only by those groups that have been given permission by an administrator in your organization?. Principals. Compartment. Region. Policies.

27. Oracle Cloud Infrastructure Object Storage is used to back up Virtual Machine DB System databases. Which statement regarding backups is false?. Full (on-demand) backups remain in object storage as standalone backups after a DB System or database is terminated. You cannot delete manual (on-demand) backups. You can use the Console or API to enable automatic incremental backups and create full backups on demand. All backups are encrypted with the same master key used for Transparent Data Encryption (TDE) wallet encryption.

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

29.-Which are the three strategies to migrate Oracle Database to Oracle Cloud Infrastructure (OCI)? (Choose three). Zero Downtime Migration (ZDM). Autonomous migration. Real Application Clusters (RAC). Migration Workbench. GoldenGate.

30.-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 Enterprise Manager 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 the cloud console to monitor all your Exadata systems that are on-premises or in the cloud from a single interface.

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

32.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?. dbnodecli. OCI CLI. ocpucli. exacli.

33.A database is running on Exadata Database Service on Dedicated Infrastructure in the public cloud. Which statement is true for Performance Hub?. Performance Hub in Basic or Full mode is free but Full mode requires more storage. 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 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).

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

35.How many IPs are required for the Backup Subnet supporting an Exadata Database Service with six Database Compute Servers?. 9. 16. 12. 24.

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

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

38.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 DB system and it will also delete the attached HeatWave Cluster. Delete the HeatWave Cluster and it will also delete the DB system. Drop the DB system and terminate the associated Heatwave Cluster.

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

40.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 three.). alarms. metrics. data points. queries. notifications.

41.Which three Oracle Cloud Infrastructure (OCI) services can be used to connect to on-premises networks? (Choose three.). Internet Gateway. Service Gateway. Dynamic Routing Gateway (DRG). IPSec VPN. FastConnect.

42.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?. Select Backup Window from the Edit MySQL DB System Details page and set the start time to 4 AM. Use the mysqlbackup command to establish a 4 AM backup start time. Update the Oracle Cloud Infrastructure (OCI) MySQL DB System Details page to specify the 4 AM backup window start time. Edit the OCI MySQL DB System Details to set the Enable Automatic Backups time to 4 AM.

43.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 requires more block storage, you can increase 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. After you have provisioned a VM DB system. you cannot increase or decrease block storage. 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.

44.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 two.). After you provision a VM DB system, you cannot change the shape: you have to provision another VM DBsystem using a full backup. It is possible to change the shape of a VM DB system with a higher number of OCPUs. However, reducingthe number of OCPUs is not permitted. After you provision a VM DB system with a shape that supports Oracle RAC, you can change the currentshape to another shape that does not support Oracle RAC. It is possible to change the shape of a VM DB system without impacting the amount of storage available tothe DB system. If the current shape of the VM DB system supports Oracle Real Application Clusters (RAC), then you canonly change the current shape to another shape that also supports Oracle RAC. 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.

45.-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? (Choose two.). Use Logical Volume Manager (LVM) for the storage management of single-node VM deployments. 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 of single and two node VM deployments.

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

47.Which statement is true about moving virtual machine (VM) database (DB) systems from one compartment to another?. 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 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 such as Database Homes and database to the destination compartment before moving the VM DB system. You can only move VM DB systems from one compartment to another by using Oracle Cloud Infrastructure REST APIS.

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

49.Which two statements are true when deciding which Oracle Cloud Infrastructure (OCI) region to register an Exadata Cloud@Customer infrastructure in? (Choose two.). Consider which availability domain (within the region) to create the Exadata Cloud@Customer infrastructure in. Exadata Cloud@Customer is hosted in a customer data center so the Exadata infrastructure is not registered in an OCI 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 any business policies or regulations that preclude the use of a particular region.

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

51. 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 Cloud Network (VCN). Client Subnet. Virtual Network Interface Card (VNIC). FastConnect.

52. How many IPs do you need at a minimum for the Client Subnet, when you plan to have six Database Compute Servers for your Exadata Database Service?. 12. 9. 24. 18. 16.

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

54. For which two reasons do you need a minimum of three storage cells when using Exadata Database Service? (Choose two.). Triple mirroring of data. High availability. Real Application Clusters. Fast Start Failover of storage cells. Data Guard.

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

56. 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 policies have been configured and tested. What is the next step to create a MySQL Database Service?. Create a Linux compute instance. Connect to the MySQL Database Service system endpoint. Create a Virtual Cloud Network by using the VCN Wizard. Create the MySQL DB system.

57. 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 two.). Install the MySQL client on your local computer. Connect to your database system by using the MySQL client on the Linux compute instance. SSH into the compute instance from your local machine. Define a SQL Developer connection in your MySQL Database Service database system.

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

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

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

61. Which two statements are true about monitoring a DB system in Oracle Cloud Infrastructure (OCI)? (Choose two). 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 a consolidated view of real-time and historical performance data. You can view database performance analysis and tuning through Performance Hub, which provides only a consolidated view of historical performance data for comparative analysis. 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.

62. Which three actions can you perform on a DB system that has an Oracle Data Guard association with a standby database? (Choose three). 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.

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

64. Which two statements are true about cloning a Virtual Machine DB System? (Choose two.). When creating a clone of the Virtual Machine DB system, you need to specify a new SSH key and admin password. Cloning creates a 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 volumes. When creating a clone, you must use the same SSH key and admin password as the source Virtual Machine DB system. 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.

65. 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, NOSOL_ROWS_INSERT. NOSQL_TABLE_DESTROY, NOSQL_TABLE_ALTER.

66. Which two must you create or configure to manage an external database? (Choose two). A database group. A database handle. A database connection. A dynamic group.

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

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

69. In addition to Automatic backups of your Oracle database, you want to take On-Demand backups of the database on Exadata Database Service on Dedicated Infrastructure in the public cloud. How can you do this?. Disable Automatic backup 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. Connect to Exadata Database Service as oracle user first and then take an On-Demand backup.

70. When you created your development database on Exadata Cloud@Customer, you selected "None" for backup location. You now need to enable Automatic backups on the development database with a retention period of 60 days. Which action should you perform?. Change the database backup location to a local storage and set the retention period to 60 days. Change the database backup location to an NFS backup location and set the retention period to 60 days. Change the database backup location to Object storage with the default retention period set. No action can be taken, because a new backup location cannot be set after creation.

71. You used the "Stop" option from the Console of an Exadata Database Service virtual machine within a VM cluster. Which two statements are true? (Choose two). All the VMs in the cluster are stopped. All the databases in the VM 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.

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

73. Which is NOT a prerequisite for patching the Grid Infrastructure or Database Homes when using the console?. Ensuring that all the database compute servers are of the VM Cluster type and are up and running. Ensuring that the /u01 (GI Home) directory on the database host file system has at least 15 GB of free space before executing the Grid Infrastructure update. 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.

74. 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 Database Services?. Enable egress for TCP traffic only for port 1521. Enable egress for TCP traffic only for port 1521 and port 22. Enable egress for TCP traffic only for port 22. Enable egress for TCP traffic for all outbound ports. Enable ingress for TCP traffic only for port 1521.

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

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

77. Which characteristic is NOT a factor that impacts the capacity units for provisioning a NoSQL Database Cloud Service table?. Data model. Record size. Query pattern. Durability level.

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

79. Which statement is FALSE about using a compartment?. It can be used to secure resources. It allows you to isolate resources. It can be organized in a hierarchical fashion. It is a physical concept that separates users.

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

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

82. 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 associated databases will move to the new compartments. 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.

83. 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? (Choose the best answer). The VM cluster and associated databases will move to the new compartment. All other resources will remain in the existing compartment. 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. After it is deployed, a VM cluster cannot change compartments.

84.- Which NoSQL Database Cloud Service API statement can be used to adjust table capacity?. TableProvision. TableUnits. TableLimits. TableRequest.

85. You enable automatic backups on your Exadata Cloud@Customer? (Choose the best answer). Database archivelog files. Database control files. Transparent Data Encryption (TDE) keystore (wallet). Server parameter file (SP file).

86. 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 two). Configure auto indexing. Kill a running SQL session. View ASH Analytics. scale OCPUs for an autonomous database. Configure IO resource management (IORM).

87. Which FOUR storage options are available in Oracle Cloud Infrastructure (OCI)? (Choose four.). Local storage. Object Storage. EFS Storage. Block Storage. File Storage.

88. 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 two). 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.

89. Patching requires role permissions. However, since roles are not granted by default, which role needs to be added to someone patching the DB system? (Choose the best answer). 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.

90. Which TWO statements are true about Interface for Exadata I/O Resource Management (IORM)? (Choose two.). IORM allows workloads and databases to share I/O resources automatically according to admin-defined policies. IORM can be enabled across multiple Exadata Racks using the Cloud interface of Exadata Cloud Service. 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.

91. 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? (Choose the best answer). 32. 14. 4. 18. 8.

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

93. MySQL HeatWave offers three flexible deployment options. Which deployment option uses an innovative in-memory analytics engine to provide 400x query acceleration for MySQL at a very compelling price and can be used for high volume with analytic processing?. The HeatWave option. The High Availability option. The Standalone option.

94. Which two tools are used to monitor Exadata Database Service?. Oracle Internet Monitoring Suite (IMS). Oracle Cloud Monitor. Service Console. Oracle Management Cloud. Oracle Enterprise Manager.

95. Which is NOT a resource type for NoSQL Database Cloud Service?. Nosql-indexes. Nosql-tables. Nosql-rows. Nosql-keys.

96. Which two use cases can be used by the Oracle database with Object Storage in Oracle Cloud Infrastructure (OCI)? (Choose two). Database log files. Database datafiles. Database backups. Database binaries.

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

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

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

100. Which two statements are true about Oracle Cloud Infrastructure (OCI) Management Interfaces?. OCI CLI and dbcli (database CLI) are command-line interfaces that can be used with virtual machine DB systems. Virtual Machine DB Systems cannot be managed from the Web Console and must use the provided Cloud REST APIs. Terraform is an OCI Management Interface that allows for programmatic access via https for secure application integration. dbcli is available only on virtual machine DB systems and must be run on the host. OCI CLI and VMCLI are command-line interfaces that can be used with virtual machine DB systems. 5. VMCLI is a command-line interface that is available only on virtual machine DB systems and must be run on the host.

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

102. Which Oracle Cloud service does NOT support Real Application Cluster database?. Autonomous Database. VM. Exadata Cloud Service (both ExaCS and ExaCC). Bare Metal.

103. You write policy statements to allow a trusted developer to manage all aspects of the MySQL Database Services in your tenancy. Which three MySQL resources, within Oracle Cloud Infrastructure, can this developer control?. mysql-monitor. mysql-work-requests. mysql-shell. mysql-backups. mysql-instances.

104. Which three statements are true about Exadata Snapshots on the Exadata Database Service?. Exadata Snapshots utilize the Exadata SPARSE disk group to store the sparse files that contain only changed blocks. Before creating Exadata Snapshots from the test master, you can modify the data in the test master, if required. Multiple users can create independent Exadata Snapshots from the same test master, which is a full Read-Only clone of the source database. Exadata Snapshots are unable to utilize all the Exadata features. Exadata Snapshots utilize the Exadata SPARSE disk group to store the sparse files that contain all the data that is read and written by the Snapshots.

105. You have successfully created a MySQL database server and all its required components. What should you use to keep track of the health, capacity, and performance of your MySQL system on C Cloud Infrastructure?. MySQL Database Service monitor. MySQL Database Service metrics. MySQL Database Service manager. MySQL Database service check.

106. Which statement is true about scaling storage for a Virtual Machine DB System?. 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 cannot be decreased, whereas the Recovery Area storage size can be decrease. 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.

107. On the Add HeatWave Cluster dialog, you are asked to provide the shape for the HeatWave nodes. Which detail does the shape selection provide to HeatWave?. The private IP address for the Analytic Cluster. The Disk partition count for the HeatWave cluster. The number of CPUs for the Analytic cluster. The associated database system network Gbps.

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

109. 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?. Run the dbaascli patch tools list command. Run the rpm -qa |grep -i dbaastools_exadata command. You must first connect to Exadata Cloud Service as the oracle user. You must first connect to Exadata Cloud Service as opc and sudo to the root user.

110. Which two statements are true when configuring an Oracle Data Guard standby for a database system Oracle Cloud Infrastructure?. Both DB systems must be in the same region. The database editions must be Enterprise Edition - Extreme Performance. Both DB systems must be in the same compartment. Both DB systems must be in the same subnet. Both DB systems must be the same type; for example, if the primary database is a virtual machine, then the standby database must also be that of a virtual machine.

111. You no longer want to manually back up your MySQL Database Service What must you do to turn on automatic backup?. Use Oracle Enterprise Manager to enable Automatic Backups. Install MySQL Enterprise Backup on the MySQL Database Service system. Backups. Recreate the MySQL Database Service system and enable Automatic Backups. Update the MySQL Database Service system and enable Automatic Backup.

113. 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?. 4. 32. 5. 12.

114. 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?. The Console, API, and Oracle Cloud Infrastructure CLI are options for managing bare metal DB systems. Both bare metal and vm DB systems support two-node Real Application Clusters (RAC) 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.

116. Which three actions can you perform on a DB system that has an Oracle Data Guard association with a standby database? (Choose three). Write on both primary and standby databases because DB system standby databases in Oracle Cloud Infrastructure Database are logical standbys. 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, and then switch it back to the primary role. Use the reinstate command to return a failed database to the standby role after correcting the cause of failure.

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? (Choose the best answer.). 0. 1. 2. 3. 4.

118. Which statement is true about MySQL Database Service?. It is a public cloud service built on MySQL Community Edition. 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.

119. You are in the DatabaseAdmins 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 DatabaseAdmins group to allow you to patch the DB system?. Allow group DatabaseAdmins to manage db-systems in the DatabaseAdmins tenancy. Allow group DatabaseAdmins to manage db-systems in tenancy. Allow group DatabaseAdmins to patch db-systems in tenancy. Allow group DatabaseAdmins to patch db-systems in compartment.

120. 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 configure the database parameters to only allow connections from encrypted clients. You should consider leveraging a VPN. 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.

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

123. Which statement is true about rebooting a virtual machine (VM) DB system node using the the Oracle Cloud Infrastructure Console?. Under Database, click Bare Metal, VM, and Exadata; select the DB system you want to reboot; and then dick Stop and Start after a few minutes under the Actions (three dots) menu. The VM Oh system can be rebooted only born Oracle cloud Infrastructure REST APIs or dbcli. 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. The VM DB system nodes cannot be rebooted individually. For rnultinode 013 systems, you have to act on all the VM nodes concurrently.

124. To which two files used in local installations of MySQL Server are MySQL configurations analogous?. mysqld-auto.cnf. mysqld-auto.cnf. my.cnf. my.ini. mylogin.cnf.

125. Which statement is FALSE related to loading a table into HeatWave?. Data is distributed among analytics nodes by slicing tables by vertically. Data is read from InnoDB using batched, multi-threaded reads. Data is partitioned by primary key unless data placement keys are defined. Data is converted into columnar format and sent over the network.

126. You have decided to use the Estimate Node Count option to generate the ileatWave Node Count for your HeatWave cluster. What is a mandatory step before performing the node count estimate?. When preparing the data on the MySQL DB System exclude columns with INT data types. Connect to the MySQL DB System with SSH and the MySQL Client to give the Node Count Estimator access to your data. Make sure the data you intend to load into the HeatWave clustens present on the MySQL DB System. To ensure that estimates are as accurate as‘possible 10-9 into the associated MySQL DB Systemand run UPDATE on the tables.

127. What should you do to verify that tables are loaded in HeatWave?. Open the OCI navigation menu. Under MySQL HeatWave Clusters select view Load status. Query the LOAD_STATUS data from the HeatWave Performance Schema tables. Run the execute SQL command to find the LOAD_STATUS of the appropriate tables in the MySQL Performance Schema. From the OCI MySQL DB System Details page select HeatWave Cluster Information to list the TABLE STATUS of all loaded tables. Use the MySQL Workbench ANALYTICLOAD_sTATus-View dialog to list the loaded tables.

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

129. 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, but before that you must either disable Data Guard or remove the Data Guard association by terminating the standby database. 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 to a point in time. The DB system has no access to the Oracle Cloud Infrastructure Object Storage service location where the backup is stored.

130. You use the Oracle Cloud Infrastructure console to create a MySQL DB 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?. Host name should contain only letters. Usemame "mysql.sys" is reserved. Maintenance Window start time is required. Storage size is too small.

131. You try to access MySQL Database Service by using MySQL Workbench. The direct remote private IP connection to the MySQL DB system endpoint does not work. What three resources are required for MySQL Workbench to successfully conned to the MySQL Database Service system? (REVISAR). Oracle Cloud Infrastructure tenancy name where the MySQL database system exists. username and password defined when creating the database system. Oracle Cloud Infrastructure compartment name where the MySQL database system exists. Linux compute instance on the same VCN as the DB system to connect to and from the compute instance to the MySQL database system. username and public IP address of the compute instance.

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

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

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

135. You are asked to create a policy to allow a DBA cluster group to read and edit VM duster networks in tenancy However, you do not want to allow them to create or delete cluster networks. Which IAM policy should you add to permit this level of access?. Allow group DBACluster to manage exadata-infrastructure in tenancy. Allow group DBACluster to manage vmcluster-networks in tenancy. Allow group DBACluster to use exadata-infrastructure in tenancy. Allow group DBACluster to read exadata-infrastructure in tenancy. Allow group DBACluster to modify vmcluster-networks in tenancy.

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

137. Which two statements are true when enabling Data Guard on Exadata Database Service?. You cannot edit your configuration to change between synchronous or asynchronous transport of data to the DR site, after enabling Data Guard. 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 use Active Data Guard, which extends Oracle Data Guard capabilities by providing read/write functionality on the Standby or Disaster Recovery system. You must configure Data Guard manually to create the Standby or DR instance for your Primary Exadata Database. You can enable Data Guard to support your Standby or Disaster Recovery (DR) needs with a single API call or mouse click in the UI using cloud automation.

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

139 You are designing an Exadata Database Service-based architecture for a customer who has a requirement that all maintenance, including database upgrades, be completed with as little downtime as possible. Which technology should be used?. Active Data Guard. Application Continuity. RMAN. ASM instead of LVM. Multitenant.

140. 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?. Create a new database home, patch it to the version you want, and then move the database to the new home. 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 dbaascli to apply the patch on the database home.

141. 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 MySQL Database Service must you use?. Mirror. mysqldump. Full. Incremental.

142. Which two requirements must be first met to create an Exadata Database Service Instance?. You need to define the VCN, Private Client Subnet, and Service Backup Subnet. You need to create an Exadata Infrastructure and VM Cluster resource. You need to define the VCN, Private Client Subnet, and Private Backup Subnet. You only need a VCN and Universal Cloud Credits. There are no prerequisites for creating an Exadata Database Service_ instance.

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

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

145. Which two actions does the Cloud VM Cluster Resource allow you to do?. Upgrade the Exadata System model to the latest version. 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. Scale up and down the OCPUs to align with the workload demand. Schedule Infrastructure Maintenance.

146. Which statement is true about a Virtual Cloud Network (VCN)?. A VCN spans multiple Regions to facilitate failover requirements. 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 Availability Domain, but can cross multiple Regions. A VCN resides within a single Region, but can cross multiple Availability Domains.

147. Which two are key features of MySQL Database Service?. Interactive Documents: Uses a built-in web-based notebook tool for designing and sharing SQL-based datadriven scripts. Integration with Oracle Technologies: Uses a dient's existing Orade investments and easily integrates MySQL Database Service with Oracle technologies. In-Memory Lookups: Avoids unnecessary I/O operations by replacing storage indexes with a few in-memory lookups. Regulatory Compliance: Uses advanced security to help clients meet industry and regulatory compliance requirements, including GDPR, PCI, and HIPPA.

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

149. In which case can you fast provision a virtual machine (VM) database (DB) systems, using Logical Volume Manager (LVM) for storage management?. Orade Databases that could use Automatic Storage Management (ASM). Oracle Database versions 12.2 and greater. Any currently supported release of the Oracle Database. Oracle Database versions 18c and greater.

150. Which Exadata Database Service databases restore option is NOT available from the console?. Restore using backup tag. Restore using SCN. Restore to latest. Restore to a timestamp.

151. 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 must use the Vault service directly to rotate encryption keys every 24 hours. 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 can choose Customer-managed keys or Oracle-managed keys when the database is created.

152. A new international hacktivist group, based in London, launched wide scale cyber attacks including SQL Injection and Cross-Site Scripting (XSS) across multiple websites which are hosted in Oracle Cloud Infrastructure (OCI). As an IT consultant, you must configure a Web Application Firewall (WAF) to protect these websites against the attacks. How should you configure your WAF to protect the website against those attacks? (Choose the best answer). Enable a Protection Rule to block the attacks based on HTTP Headers that contain XSS and SQL strings. Enable an Access Rule to block the IP Address range from London. Enable a Protection Rule to block requests XSS Filters Categories and SQL Filters Categories. Enable a Protection Rule to block requests that came from London. Enable an Access Rule that contains XSS Filters Categories and SQL Filters Categories.

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

154. Database Cloud Service supports all three types of big data. Which is NOT considered big data?. unstructured data. structured data. free-structured data. semi-structured data.

155. 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 Management Agent 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 Resource Principals.

156. 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. Scaling the OCPUs of a Virtual Machine DB System requires that the shape of the DB system be changed. For a 2-node RAC Virtual Machine DB System, the shape of the VMs changes without needing to reboot the VM nodes.

157. What is the minimum Infrastructure usage commitment for Exadata Database Service on Exadara Cloud@Customer (ExaDB-C@C)?. 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 48 Year usage commitment for the Infrastructure. ExaDB-C@C' requires a minimum 48 Year usage commitment for the Infrastructure and OCPU.

158. Which two are the same for a Base System and a Quarter Rack?. Maximium Number of enabled OCPUs. Total Raw Storage Capacity. Number of Exadata Storage Servers. Number of Compute Servers. Total Raw Flash Storage Capacity.

159. Which two statements are true about using a Service Gateway?. The Service Gateway can connect to services in the order regions outside of the VCN. The Service Gateway can be used to connect to the Internet. 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 with a public subnet can be used to access Object Storage.

160. Which two statements are true regarding MySQL Database Service HeatWave? (Choose two.). HeatWave uses periodic long-running ETL batch jobs to refresh data. HeatWave is an in-memory, query-processing engine designed for fast execution of analytic queries. The HeatWave data that is needed for analytic processing is stored in disk files. HeatWave uses machine learning to automate operations, increasing DBA Productivity, and.

161. What is true about scheduling maintenance operations in the cloud?. Customers can reschedule Infrastructure Maintenance up to 180 days from the previous. Customers do not have control over the Automatic Infrastructure maintenance schedule because Oracle undertake this effort. You can only choose the day of the week and the time that Automatic Infraestructure maintenance occurs. Infrastructure maintenance is done on Mondays, by default.

162. Which two statements are true about Routing tables?. You can delete the default Routing Table it is not required. Gateway added to your VCN do not requiere an entry in the Routing table. A Routing Table controls ingress and egress rules, that specify the types od traffic allowed. A VCN uses the Routing Table to send traffic out of the VCN. The default Routing Table is shared by all the Subnets in the VCN. The Routing Table rules specify a destination CIDR Block and target.

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

165. 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. When in a Data Guard configuration patching will always take place on the standby database first. 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.

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

167. You have a group called DatabaseAdmins and you need to allow them to create Exadata Database Services. Which is the correct IAM policy to use?. Allow group DatabaseAdmins to manage databases in tenancy. Allow group DatabaseAdmins to create database-family in tenancy. Allow databases in tenancy to be managed by DatabaseAdmins. Allow tenancy DatabaseAdmins to manage database-family in group. Allow group DatabaseAdmins to manage database-family in tenancy.

168.You are using the CLI command oci mysql db-system get, to retrieve the MySQL Database System details. What value must you provide to perform this task?. DB System IP address. DB System DB ID. DB System Tenancy ID. DB System OCID.

169. Which statement is FALSE about updating your Virtual Machine DB System database?. Updating the DB system updates the Grid Infrastructure for two-node RAC DB Systems with Automatic Storage Management (ASM) storage management software. Ensuring /u01 has 15 GB of free space. Updating the DB System does NOT update the operating system. Updating the DB System also updates the operating system.

170. Which two are responsibilities of the developer or user to manage with NoSQL Database Cloud Services?. Setting roles and privileges. Replication across multiple availability domains. Installation of software and updates. Application development.

171. You want to stops unauthorized attempts from the operating system to access database data stored in files. Which actions must you perform to encrypt data in the database data files and in backups? You enable automatic backups on your Exadata Cloud@Customer. database control files. server parameter file (SP file). Transparent Data Encryption (TDE) keystore (wallet). database archivelog files.