1Z0-1093-23 Online Practice Questions and Answers

What statement is FALSE regarding the differences between the Exadata Cloud@Customer X8M and X8 Infrastructure?

A. X8 uses InfiniBand for its internal network fabric whereas X8M uses RoCE.

B. Both X8M and X8 Exadata System models use InfiniBand for their internal network fabric.

C. X8M has more total OCPUs available than an equivalent X8 configuration.

D. X8M uses Persistent Memory (PMEM).

Which two external databases can be monitored by the Oracle Cloud Infrastructure (OCI) Database Management Service? (Choose two.)

A. Oracle 18c Database deployed on Oracle Exadata Cloud@Customer

B. Oracle Autonomous Database 19c deployed on an OCI Tenant

C. Oracle 12cR1 Database deployed on an Oracle Exadata Database Machine

D. Oracle 11gR2 Database deployed on an Oracle Private Cloud

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?

A. It upgrades the associated compute instance to the latest Linux operating system version.

B. It analyzes, rebuilds, and optimizes MySQL database tables and indexes.

C. It patches the MySQL server itself along with any underlying hardware.

D. It patches the underlying operating system of the MySQL database.

Which statement is true about rebooting a virtual machine (VM) DB system node using the Oracle Cloud Infrastructure Console?

A. The VM DB system nodes cannot be rebooted individually. For multinode DB systems, you have to act on all the VM nodes concurrently.

B. The VM DB system can be rebooted only from Oracle Cloud Infrastructure REST APIs or dbcli.

C. Under Database, click Bare Metal, VM, and Exadata; select the DB system you want to reboot; and then click Stop and Start after a few minutes under the Actions (three dots) menu.

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.

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? (Choose two.)

A. You must first connect to Exadata Cloud Service as the oracle user.

B. Run the dbaascli patch tools list command.

C. You must first connect to Exadata Cloud Service as opc and sudo to the root user.

D. Run the rpm -qa|grep -i dbaastools_exadata command.

Which three are prerequisites for using the MySQL Database Service? (Choose three.)

A. You must create a compartment to store your resources.

B. You must create a tenancy and be able to sign in to it.

C. You or your group must be granted the policies described in Mandatory Policies.

D. You must download the latest MySQL version from https://edelivery.oracle.com/.

E. You must install the downloaded MySQL version onto Oracle Cloud Infrastructure.

NoSQL Database Cloud Service supports all three types of big data. Which is NOT considered big data?

A. structured data

B. semi-structured data

C. unstructured data

D. free-structured data

What capability in the OCI Database Management Service is available using Database Groups?

A. Execute a SQL query for the databases.

B. View database log events.

C. Predict long-term capacity trends for the databases.

D. Install patches for the databases.

Which TWO statements are true when enabling autonomous Data Guard on Autonomous Exadata.(Choose all correct answers)

A. Autonomous databases inherit their Data Guard configuration from their Autonomous Container Database.

B. Data Guard can be set per individual Autonomous Database within a Container Database.

C. Data Guard is not currently supported on Autonomous Exadata Cloud@Customer.

D. Autonomous Data Guard only supports Maximum Performance and Maximum Protection protection modes.

E. When in a Data Guard configuration patching will always take place on the standby database first.

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?

A. DB System Tenancy ID

B. DB System DB ID

C. DB System IP address

D. DB System OCID