1z0-1093-23 Exam Dumps - Oracle Base Database Services 2023 Professional

The correct way to take an On-Demand backup of the database on Exadata Database Service on Dedicated Infrastructure in the public cloud is to use the Create Backup button in the backup section of the Database Details page1. This will create a full backup of the database and store it in the backup destination that you have configured for the database1. You can use this option to take an On-Demand backup at any time, regardless of the automatic backup schedule that you have set up1.

The other options are incorrect because:

• Connecting to Exadata Database Service as oracle user first and then taking an On-Demand backup is not supported. You cannot use the dbaascli utility or the RMAN commands to initiate an On-Demand backup on Exadata Database Service on Dedicated Infrastructure2. You can only use the Console or the API to create an On-Demand backup1.
• Disabling Automatic backup and then taking an On-Demand backup is not necessary. You can take an On-Demand backup without disabling the Automatic backup feature1. Disabling Automatic backup will stop the regular backups of the database, which is not recommended for data protection and recovery1.
• On-Demand backups are allowed on Exadata Database Service, as explained above. They are not restricted by the Automatic backup feature, which is also available and recommended for Exadata Database Service1.

References:

• Managing Database Backup and Recovery on Oracle Exadata Database Service on Dedicated Infrastructure
• Exadata Database Service on Dedicated Infrastructure

The three strategies to migrate Oracle Database to Oracle Cloud Infrastructure (OCI) are:

• Zero Downtime Migration: This is a tool that provides a simplified and automated migration experience, providing zero to negligible downtime for the production system. It supports migrating Oracle Database versions 11.2.0.4 and later, running on any platform, to any OCI Database service, including Exadata, Cloud@Customer, and Autonomous1.
• Migration Workbench: This is a feature of Oracle Enterprise Manager that provides a user interface to perform database migrations using various methods, such as Data Pump, Transportable Tablespaces, or Cross-Platform Transportable PDBs. It supports migrating Oracle Database versions 11.2.0.4 and later, running on any platform, to any OCI Database service, including Exadata, Cloud@Customer, and Autonomous2.
• GoldenGate: This is a software product that enables data replication and integration across heterogeneous databases and platforms. It supports migrating Oracle Database versions 10.2 and later, running on any platform, to any OCI Database service, including Exadata, Cloud@Customer, and Autonomous. It also supports bi-directional replication and zero downtime upgrades3.

B is incorrect, because autonomous migration is not a strategy to migrate Oracle Database to OCI, but a feature of Oracle Autonomous Database that allows you to migrate data from other sources, such as Oracle Database, MySQL, MongoDB, or Amazon S3, to an Autonomous Database instance using Oracle Data Pump or SQL Developer Web4.

C is incorrect, because Real Application Clusters (RAC) is not a strategy to migrate Oracle Database to OCI, but a feature of Oracle Database that provides high availability and scalability by enabling multiple instances to access the same database across a cluster of servers5.

References: 1: Get started with Zero Downtime Migration 2: Migrate Oracle Databases to OCI 3: Oracle GoldenGate 4: Migrate Data to Autonomous Database 5: Oracle Real Application Clusters (RAC)

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. This is because the VM DB System uses block volumes to store the database data files and the recovery area files, and the block volumes cannot be downsized1. However, you can increase the storage size of the block volumes at any time, either individually or together, to accommodate the growth of your database1. You can also scale the compute resources of the VM DB System independently of the storage resources, by adding or removing CPU cores or changing the shape of the VM DB System1. Scaling the storage or compute resources of the VM DB System does not affect the availability of the database, as the scaling operations are performed online1. References:

• 1: Scaling a Virtual Machine DB System - Oracle Help Center
• Independent Scaling: Oracle VM DB Systems allow you to scale the Available Data storage (the main storage for your database) and the Recovery Area storage (used for backups, Flashback logs, etc.) separately.expand_more This provides flexibility.
• No Decreasing Storage: Once provisioned or scaled up, neither the Available Data storage nor the Recovery Area storage can be scaled 

pen_spark

down.exclamation This is likely to protect data integrity.

Updating a DB system on a virtual machine updates the Oracle Database software and the Grid Infrastructure software, but not the operating system. The operating system can be updated separately using the Upgrade option in the Console or the API. Therefore, statement D is false and the rest are true. References:

• 3: Update a DB System - Oracle Help Center
• 4: Upgrade a DB System - Oracle Help Center

 According to the Oracle NoSQL Database Cloud Service documentation, the maximum supported rate of DDL operations is 4 DDL operations per minute1. This limit applies to the creation, alteration, and deletion of tables and indexes. If you exceed this limit, you may encounter an OperationThrottlingException2. Therefore, option E is the correct answer and the rest are incorrect. References: 1: Plan your service - Oracle Help Center 2: Oracle NoSQL cloud service - Stack Overflow

The users created on Database Servers that can be used for both Oracle database and host management of your Exadata Database Service are the root, opc, oracle, and grid users1. These users have different roles and privileges as follows:

• root: The root user is the superuser on the Database Servers. The root user can perform any administrative task on the host, such as installing software, configuring the network, and managing the file system. The root user can also access the Oracle Database as the SYSDBA user1.
• opc: The opc user is the default user that you use to connect to the Database Servers using SSH. The opc user has sudo privileges to run commands as root or other users. The opc user can also access the Oracle Database as the SYSDBA user1.
• oracle: The oracle user is the owner of the Oracle Database software and the Oracle Database home directory. The oracle user can perform database administration tasks, such as creating and managing databases, tablespaces, and users. The oracle user can also access the Oracle Database as the SYSDBA user1.
• grid: The grid user is the owner of the Oracle Grid Infrastructure software and the Oracle Automatic Storage Management (ASM) home directory. The grid user can perform ASM administration tasks, such as creating and managing disk groups, volumes, and files. The grid user can also access the Oracle Database as the SYSASM user1.

The other options are incorrect because:

• B. root, opc, oracle, grid, and cloud users: The cloud user is not a valid user on the Database Servers. The cloud user is a user that you create in the Oracle Cloud Infrastructure Identity and Access Management (IAM) service to access the Oracle Cloud resources. The cloud user cannot access the Oracle Database or the host management of the Exadata Database Service2.
• C. opc, oracle, and grid users: This option is missing the root user, which is a valid user on the Database Servers that can access the Oracle Database and the host management of the Exadata Database Service1.
• D. root, oracle, and grid users: This option is missing the opc user, which is the default user on the Database Servers that can access the Oracle Database and the host management of the Exadata Database Service1.

References: 1: Users on Database Servers 2: Users and Roles in Oracle Cloud Infrastructure

Exadata Snapshots are a feature of the Exadata Database Service that allows you to create space-efficient read-only or read-write clones of an existing database1. Exadata Snapshots use the Exadata SPARSE disk group to store the sparse files that contain the data that is read and written by the snapshots2. The sparse files only store the changed blocks, not the entire data, which saves space and improves performance2. Multiple users can create independent Exadata Snapshots from the same test master, which is a full read-only clone of the source database3. The test master can be created from a backup of the source database or from a Data Guard standby database3. Before creating Exadata Snapshots from the test master, you can modify the data in the test master, if required.

Therefore, the correct answer is A, C, and D. B is incorrect, because Exadata Snapshots can utilize all the Exadata features, such as Smart Scan, Smart Flash Cache, Hybrid Columnar Compression, and so on. E is incorrect, because you cannot modify the data in the test master after creating Exadata Snapshots from it, as it becomes read-only.

References: 1: About Exadata Snapshots 2: Sparse Disk Sizing and Allocation Methodology 3: Creating Exadata Snapshot Masters : Refresh Considerations, or Lifecycle of Exadata Snapshots : Exadata Snapshots

The action that causes an error when creating a MySQL DB system is using the username “mysql.sys”. This is because “mysql.sys” is a reserved username for the MySQL system schema, which contains views and stored procedures that implement server functionality1. You cannot create a user with the same name as the system schema, as it would cause conflicts and errors1. You should choose a different username for the administrator of the MySQL DB system, such as “mysql.admin” or “mysql.user”.

The other actions do not cause errors, but they may have some implications:

• Storage size of 50 GB is not too small, but it may not be enough for your database workload and growth. You can choose a storage size from 50 GB to 16 TB when creating a MySQL DB system2. You can also scale up the storage size later if needed2.
• Host name of “mysql-host” is valid, but it should be unique within the subnet where the DB system is deployed2. You can use letters, numbers, and hyphens in the host name, but it must start and end with a letter or a number2.
• Maintenance Window start day and time is not required, but it is recommended to specify a preferred time for applying maintenance updates to the DB system2. If you do not specify a Maintenance Window, Oracle will assign a random day and time for the maintenance updates2.

References:

• MySQL :: MySQL 8.0 Reference Manual :: 5.6 The mysql System Schema
• MySQL :: MySQL Database Service User Guide :: 3.1 Creating a MySQL DB System