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

The database fleet summary page provides a unified view of your fleet of Oracle Databases in a compartment or in a Database Group on the Oracle Database fleet summary page1. You can use this page to perform the following tasks:

• View database log entries: You can view the log entries for each database in your fleet by clicking on the Logs tab. You can filter the log entries by severity, time range, and keywords. You can also download the log files for further analysis1.
• View the current database resource usage: You can view the current resource usage for each database in your fleet by clicking on the Metrics tab. You can see the metrics for CPU utilization, memory utilization, storage utilization, and I/O throughput. You can also customize the metrics dashboard by adding or removing metrics, changing the time range, and applying filters1.
• View the status of the databases: You can view the status of each database in your fleet by looking at the Status column in the table. You can see if the database is available, unavailable, or in maintenance mode. You can also see the database type, version, edition, and shape1.

The database fleet summary page does not provide the following capabilities:

• Migrate databases to OCI: You cannot migrate databases to OCI using the database fleet summary page. You need to use other tools and methods to migrate databases to OCI, such as Data Pump, RMAN, GoldenGate, or Zero Downtime Migration.
• Compare database performance metrics overtime: You cannot compare database performance metrics overtime using the database fleet summary page. You need to use the Performance Hub to compare the performance of different databases or the same database at different points in time. You can access the Performance Hub by clicking on the database name and then clicking on the Performance Hub tab.
• Execute a DDL command on the databases: You cannot execute a DDL command on the databases using the database fleet summary page. You need to use the SQL Developer Web or the SQL Worksheet to execute SQL statements on the databases. You can access the SQL Developer Web or the SQL Worksheet by clicking on the database name and then clicking on the SQL Developer Web or the SQL Worksheet tab. References: 1: Monitor the Health of Your Oracle Database Fleet - Oracle Help Center : [Migrate Databases to Oracle Cloud Infrastructure - Oracle Help Center] : [Use the Performance Hub - Oracle Help Center] : [Use SQL Developer Web - Oracle Help Center]

Learn more:

The NoSQLHandle interface is used to access Oracle NoSQL tables and perform various operations on them, such as getting, putting, deleting, querying, and indexing rows. However, it is not used to set the row retention time, which is a property of the table itself. The row retention time is specified when creating or altering a table using the TableRequest class, which is a subclass of Request. The NoSQLHandle interface does not have a method to create or alter tables, only to execute requests that are already created by the application12. References:

• NoSQLHandle (Oracle NoSQL Database Java API)
• Obtaining a NoSQL handle - Oracle Help Center

The type of file that is NOT backed up by default and is the customer’s responsibility to back up is the Transparent Data Encryption (TDE) keystore (wallet). This is because the TDE keystore contains the encryption keys that are used to protect the data in the database, and it is not included in the automatic backups feature of Exadata Cloud@Customer1. The customer must manually back up the TDE keystore to a secure location and restore it when needed1. The TDE keystore backup is essential for recovering the encrypted data in the database, as the data cannot be decrypted without the corresponding keys1.

The other types of files, such as database archivelog files, server parameter file, and database control files, are backed up by default by the automatic backups feature of Exadata Cloud@Customer1. The automatic backups feature supports Recovery Service and Object Storage as the backup destination to provide a fully automated cloud backup solution1. The automatic backups feature performs daily incremental backups and weekly full backups of the database, and also backs up the configuration files and metadata of the database1. The customer can also perform on-demand full backups of the database using the Console, the API, or the CLI1. The customer can restore the database from the backups stored in Recovery Service or Object Storage using the Console, the API, the CLI, or the dbaascli utility1. References:

• 3: Back Up and Recovery in Base Database Service - Oracle Help Center

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]

Oracle recommends that you do not stop any servers or database instances before applying a patch to your DB system. Stopping the servers or instances can cause the patching process to fail or take longer than expected. Instead, you should run the precheck operation before you apply any update to verify that your DB system meets the patching prerequisites. You should also back up your databases before you apply any updates to your system, and patch the DB system before updating a database for DB systems with Grid Infrastructure/ASM storage management. Therefore, statement D is not an Oracle best practice and the rest are. References:

• 3: In-Place Upgrade for Database Cloud Service (DBCS) VM DB Systems
• 4: Update a DB System - Oracle Help Center

The correct IAM policy to use to allow a group called DatabaseAdmins to create Exadata Database Services is to allow the group to manage the database-family resource type in the tenancy. The database-family resource type includes all the resources related to Oracle Database services, such as DB systems, databases, backups, patches, and Exadata infrastructure1. The syntax for the policy statement is as follows2:

Allow group DatabaseAdmins to manage database-family in tenancy

This policy statement grants the DatabaseAdmins group the permission to perform any action on any resource in the database-family resource type within the tenancy. This includes creating, updating, deleting, and viewing Exadata Database Services and other database resources12.

The other options are not correct IAM policies to use for this purpose. Option A is not a valid syntax, as the tenancy cannot be used as a target for a policy statement. Option B is not a valid syntax, as the databases cannot be used as a principal for a policy statement. Option D is not sufficient, as it only grants the permission to create database-family resources, but not to manage them. Option E is not comprehensive, as it only grants the permission to manage databases, but not other database-family resources, such as Exadata infrastructure12. References:

• Resource Types - Oracle Help Center
• Policy Syntax - Oracle Help Center

The Oracle Cloud Infrastructure (OCI) Database Management Service is a fully integrated feature of Oracle Database that provides a single console for managing and monitoring your Oracle Databases on OCI. It supports Oracle Database versions 11.2.0.4 and later, running on any edition, including Enterprise Edition, Standard Edition 2, and Express Edition1. It can monitor both OCI databases and external databases that are accessible from the OCI tenancy2. External databases are databases that are not deployed on OCI, but can be registered with the Database Management Service using a Database Management private endpoint and a Database Management agent3.

According to the documentation, the following types of external databases are supported by the Database Management Service3:

• Oracle Database on-premises
• Oracle Database on Oracle Cloud Infrastructure Classic
• Oracle Database on other cloud platforms
• Oracle Exadata Cloud@Customer
• Oracle Exadata Database Machine

Therefore, the correct answer is A and C, as they are both external databases that can be monitored by the Database Management Service. B is incorrect, because Oracle Autonomous Database is not an external database, but an OCI database that is managed by Oracle and does not require a Database Management agent4. D is incorrect, because Oracle 11gR2 Database is not a supported version for the Database Management Service, as it requires at least 11.2.0.41.

References: 1: Supported Database Versions and Features 2: About Database Management 3: Managing External Databases 4: Autonomous Database on Shared Exadata Infrastructure

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

Oracle database with Object Storage in Oracle Cloud Infrastructure (OCI) can be used for the following use cases:

• Database backups: Oracle Recovery Manager (RMAN) is an Oracle Database client that performs Oracle database backup and recovery. It automates the administration of Oracle backup strategies and greatly simplifies backing up, restoring, and recovering database files. RMAN can use OCI Object Storage as a backup destination, which offers reliable and cost-efficient data durability1.
• Database log files: Oracle Database can use OCI Object Storage as a destination for archiving redo log files, which are generated during normal database operation and contain a record of the changes made to the database. Archiving redo log files to OCI Object Storage can help reduce the storage costs and improve the availability and disaster recovery of the database2.

The other two options are not valid use cases for Oracle database with Object Storage in OCI:

• Database data files: Oracle Database cannot use OCI Object Storage as a storage option for data files, which store the actual data of the database. Data files require block storage, which provides low latency and high performance. OCI Object Storage is an object storage service, which provides high scalability and durability, but not low latency and high performance3.
• Database binaries: Oracle Database cannot use OCI Object Storage as a storage option for database binaries, which are the executable files and libraries that make up the Oracle Database software. Database binaries require a file system, which provides a hierarchical structure and metadata for files and directories. OCI Object Storage is an object storage service, which provides a flat namespace and metadata for objects3.

References: 1: Backing Up to Object Storage 2: Archiving Redo Log Files to Object Storage 3: Object Storage Overview

Active Data Guard is a technology that can be used to minimize downtime for maintenance, including database upgrades, on Exadata Database Service. Active Data Guard enables a physical standby database to be open for read-only access while it is synchronized with the primary database. This allows the standby database to serve as a reporting or backup database, as well as a disaster recovery solution. Active Data Guard also supports rolling upgrades, which allow the primary and standby databases to run different Oracle Database versions or patch levels during the upgrade process. This reduces the downtime required for the upgrade, as the standby database can be upgraded first and then switched over to become the primary database, while the original primary database is upgraded in the background12.

The other options are not technologies that can be used to minimize downtime for maintenance on Exadata Database Service. Application Continuity is a technology that enables the replay of in-flight database requests in case of outages or planned maintenance, but it does not eliminate the downtime itself3. ASM (Automatic Storage Management) is a technology that provides storage management and performance optimization for Oracle Database, but it does not reduce the downtime for maintenance4. RMAN (Recovery Manager) is a tool that provides backup and recovery capabilities for Oracle Database, but it does not reduce the downtime for maintenance5. Multitenant is a technology that enables the consolidation of multiple databases into a single container database, but it does not reduce the downtime for maintenance. References:

• Oracle Active Data Guard - Oracle Help Center
• Oracle Database 19c Upgrade Guide - Oracle Help Center
• Application Continuity - Oracle Help Center
• Oracle Automatic Storage Management (Oracle ASM) - Oracle Help Center
• Oracle Database Backup and Recovery User’s Guide - Oracle Help Center
• [Oracle Multitenant - Oracle Help Center]

• Core Exadata Setup: When provisioning an Exadata Cloud Infrastructure resource, you must specify:
• VCN Creation: The system automatically sets up a default Virtual Cloud Network (VCN) and subnet to handle Exadata network traffic.

pen_spark

Regarding MySQL Database Service HeatWave, the following two statements are true:

• HeatWave uses machine learning to automate operations, increase DBA productivity, and reduce costs. HeatWave has several features that leverage machine learning to optimize the performance and efficiency of the service, such as12:
• HeatWave is an in-memory, query-processing engine designed for fast execution of analytic queries. HeatWave is a massively parallel, distributed system that runs analytic queries in memory, using columnar data formats, vectorized execution, and adaptive algorithms. HeatWave can accelerate MySQL performance by orders of magnitude for analytics workloads, mixed workloads, and machine learning.

B is incorrect, because HeatWave does not use periodic long-running ETL batch jobs to refresh data, but a novel technique called dual-format storage. HeatWave stores data in both row and column formats, and synchronizes the data between the two formats in real time. This eliminates the need for ETL processes and enables fast execution of both transactional and analytic queries on the same data.

D is incorrect, because the HeatWave data that is needed for analytic processing is not stored in disk files, but in memory. HeatWave uses sparse files to store the columnar data in memory, which are compressed and encrypted. HeatWave also supports querying data in object storage, such as Oracle Cloud Infrastructure Object Storage or Amazon S3, using the HeatWave Lakehouse feature.

References: 1: MySQL HeatWave Database Service | Oracle 2: HeatWave | Oracle 3: MySQL HeatWave User Guide :: 10 Machine Learning in MySQL HeatWave 4: MySQL HeatWave User Guide :: 9 HeatWave Autopilot 5: MySQL HeatWave User Guide :: 8 HeatWave Advisor : MySQL HeatWave User Guide :: 1 Overview : MySQL HeatWave User Guide :: 2 HeatWave Architecture : MySQL HeatWave User Guide :: 3 HeatWave Data

Big data is a term that refers to large and complex data sets that are beyond the capacity of traditional data processing systems. Big data can be classified into three types based on the structure and format of the data1:

• Structured data: This is data that has a predefined schema and can be easily stored, queried, and analyzed in relational databases. Examples of structured data include customer records, sales transactions, product catalogs, etc.
• Semi-structured data: This is data that does not have a fixed schema, but has some elements of structure that can be extracted and processed. Examples of semi-structured data include XML, JSON, HTML, log files, etc.
• Unstructured data: This is data that has no structure or format and cannot be easily stored or analyzed in relational databases. Examples of unstructured data include text, images, audio, video, social media posts, etc.

Therefore, statement D is incorrect, and statements A, B, and C are correct. Free-structured data is not a valid term for describing big data types. NoSQL Database Cloud Service supports all three types of big data by providing a flexible and scalable data model that can store and query data in various formats, such as JSON, key-value, or fixed-schema2. References: 1: [Oracle Cloud Infrastructure Documentation], Big Data 2: [Oracle Cloud Infrastructure Documentation], NoSQL Database Cloud Service Overview

The statement that is true about rebooting a virtual machine (VM) DB system node using the Oracle Cloud Infrastructure Console is D. 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. This is the procedure that is described in the official documentation12. It allows you to reboot a single node of a multi-node DB system individually, which may be necessary in some cases, such as scheduled maintenance1. The node is shut down and then restarted, and the floating IP address may take some time to be updated1.

A is incorrect, because the VM DB system nodes can be rebooted individually, as explained above. B is incorrect, because the VM DB system can be rebooted from the Oracle Cloud Infrastructure Console, as well as from the REST APIs or dbcli1. C is incorrect, because this is not the correct way to reboot a VM DB system node. Stopping and starting the DB system affects all the nodes, not just one, and it also stops and starts the database instances. This is different from rebooting a node, which does not affect the database instances1.

References: 1: Reboot a DB System 2: Reboot a DB System : Stop and Start a DB System

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 compartment is a logical container that can hold resources such as databases, compute instances, networks, etc. A compartment can be organized in a hierarchical fashion, with parent and child compartments1. After creating a compartment, you do not need to write any policies for it, unless you want to grant access to other users or groups2. Compartments are tenancy-wide, meaning that they are available across all the regions that the tenancy subscribes to3. A compartment allows you to isolate resources for different purposes, such as development, testing, production, etc. Therefore, statement C is false, and statements A, B, and D are true. References: 1: Become an Oracle Base Database Services Professional (2023), Section 2.1.1: Compartments 2: Base Database Service, Section 1.2.1: Compartments 3: Oracle Base Database Services 2023 Professional, Section 2.1.1: Compartments : [Oracle Cloud Infrastructure Documentation], Compartments and Subcompartments