Free 1z0-1093-23 Oracle Updates

When you permanently delete a MySQL database system, the backups that are associated with the deleted database system are not automatically deleted. They are retained for their retention periods, which are specified when you create the backup policy for the database system. You can view, restore, or delete the backups from the Oracle Cloud Infrastructure Console or the API1. References: 1: MySQL Database Service Backups

A Service Gateway is a virtual router that enables private access to multiple Oracle services in the Oracle Services Network, a conceptual network that is reserved for Oracle services and composed of a list of regional CIDR blocks1. A Service Gateway can be used to access Object Storage, which is one of the Oracle services supported by the Service Gateway2. A Service Gateway can only connect to services in the same region of its VCN, not in other regions3. A Service Gateway cannot be used to connect to the Internet, as it does not have a public IP address4. A Service Gateway can be used with either a private or a public subnet, as long as the subnet has a route table that directs traffic to the Service Gateway5. References: 1: Service Gateway | Oracle 2: [Oracle Cloud Infrastructure Documentation] 3: [Oracle Cloud Infrastructure Documentation] 4: [Oracle Cloud Infrastructure Documentation] 5: [Oracle Cloud Infrastructure Documentation]

To use the MySQL Database Service, you need to have the following three prerequisites1:

• You must create a tenancy and be able to sign in to it. A tenancy is a secure and isolated partition within Oracle Cloud Infrastructure where you can create, organize, and administer your cloud resources2. You need to have a valid Oracle Cloud account and credentials to access your tenancy and use the MySQL Database Service.
• You must create a compartment to store your resources. A compartment is a logical container that you can use to organize and isolate your cloud resources within a tenancy3. You can create one or more compartments to store your MySQL Database Service resources, such as MySQL DB systems, backups, and connections. You can also control the access and permissions for each compartment using policies4.
• You or your group must be granted the policies described in Mandatory Policies. Policies are documents that specify who can access which resources, and how5. To use the MySQL Database Service, you need to have the necessary permissions to create and manage the MySQL Database Service resources, as well as the related Oracle Cloud Infrastructure resources, such as Virtual Cloud Networks, subnets, and security lists. The documentation provides a list of mandatory policies that you or your group must be granted to use the MySQL Database Service.

D is incorrect, because you do not have to download the latest MySQL version from https://edelivery.oracle.com/. The MySQL Database Service is a fully managed service that provides you with the MySQL version that you select when creating a MySQL DB system. You do not have to download or install any MySQL software on Oracle Cloud Infrastructure.

E is incorrect, because you do not have to install the downloaded MySQL version onto Oracle Cloud Infrastructure. As mentioned above, the MySQL Database Service is a fully managed service that handles the installation and configuration of the MySQL software for you.

References: 1: Getting Started With MySQL Database Service 2: About Your Tenancy 3: About Compartments 4: Managing Compartments 5: About Policies : Mandatory Policies : Creating a MySQL DB System

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