Oracle 1Z0-1093-23 Online Practice Questions and Exam Preparation

Oracle 1Z0-1093-23 Online Questions & Answers

• Question 81:

  In addition to the automatic backup of your Oracle Database associated with a database deployment, you are planning to take an on-demand backup of a database on Exadata CloudService. How do you do this?

  A. Disable the automatic backup configuration and then take an on-demand backup.
  B. First connect to the Exadata Cloud Instance as the oracle user and then take a backup.
  C. Use the Create Backup button in the backup section ofthe Database Details page.
  D. Perform a recovery operation to a specific long-term backup.
  C. Use the Create Backup button in the backup section ofthe Database Details page.

• Question 82:

  Which method must you use to patch databases on Exadata Database Service with the least amount of downtime?

  A. Conduct in place patching of the database Home.
  B. Leverage Patchmgr to execute patching the database Home.
  C. Create a Data Guard standby and execute standby first patching.
  D. Leverage Opatch to execute patching the database Home.
  E. Move the database to a new Home with the desired patch level.
  C. Create a Data Guard standby and execute standby first patching.

• Question 83:

  Which of the following resources can be scaled up and down on your VM cluster on Exadata Cloud@Customer?

  A. CPU, Persistent Memory (PMEM), Local Storage, and Exadata Storage
  B. CPU, Memory, Local Storage, and Network
  C. CPU, Memory, Local Storage, and Flash Storage
  D. CPU, Grid Infrastructure Bandwidth, Memory, Local Storage, and Exadata Storage
  E. CPU, Memory, Local Storage, and Exadata Storage
  E. CPU, Memory, Local Storage, and Exadata Storage

• Question 84:

  Patching requires role permissions. However, since roles are not granted by default, which role needs to be added to someone patching the DB system?

  A. Let security admins manage vaults, keys, and secrets.
  B. Let database and fleet admins manage Autonomous Databases.
  C. Let database administrator's manage DB systems.
  D. Let users manage compute instance configurations, instance pools, and cluster networks.
  C. Let database administrator's manage DB systems.

• Question 85:

  Which set of data types is supported by the NoSQLDatabase Cloud Service tables?

  A. XML, JSON, array
  B. Iong, double, triple
  C. enum, map, record
  D. Boolean, date stamp, float
  C. enum, map, record

• Question 86:

  Which two statements are true when creating the Cloud Exadata Infrastructure Resource? (Choose two.)

  A. After provisioning an Exadata X8M Infrastructure Resource, you can scale the Exadata Database Service deployment online as needed by adding additional database compute and storage servers.
  B. After provisioning an Exadata X8 Infrastructure Resource, you can scale the Exadata Database Service deployment online as needed by adding additional database and storage servers.
  C. You pick the desired hardware model and a default VCN is created for you with a default subnet for Client and Backup traffic.
  D. When creating the Cloud Exadata Infrastructure Resource, you must pick an Exadata system model, a system configuration shape, and Availability Domain.
  E. You must pick an Exadata system model, a system configuration shape, and a license model.
  A. After provisioning an Exadata X8M Infrastructure Resource, you can scale the Exadata Database Service deployment online as needed by adding additional database compute and storage servers.
  D. When creating the Cloud Exadata Infrastructure Resource, you must pick an Exadata system model, a system configuration shape, and Availability Domain.

• Question 87:

  What statement is FALSE about terminating a Virtual Machine DB System?

  A. Terminating a DB system removes all automatic incremental backups of the DB system from Oracle Cloud Infrastructure Object Storage.
  B. Terminating a DB system removes all Full On-Demand backups of the DB system from Oracle Cloud Infrastructure Object Storage.
  C. When terminating a VM Database System, it is important to note that the database data will be lost when the system is terminated.
  D. Full On-Demand backups remain in Object Storage as stand-alone backups.
  B. Terminating a DB system removes all Full On-Demand backups of the DB system from Oracle Cloud Infrastructure Object Storage.

  ---

  Explanation/Reference:

• Question 88:

  Which statement is FALSE about using compartments?

  A. They allow you to isolate resources.
  B. They can be used to secure resources.
  C. They can be organized in a hierarchical fashion.
  D. They are a physical concept that separates users.
  D. They are a physical concept that separates users.

• Question 89:

  Which is NOT a prerequisite forpatching Grid Infrastructure or database homes when using the console?

  A. The /u01 directory on the database host file system has at least 15 GB of free space for the execution of Patching processes.
  B. Oracle Clusterware is down on the VM cluster.
  C. Therequired patch is available on the Control Plane server.
  D. All database compute nodes of the VM cluster are up and running.
  B. Oracle Clusterware is down on the VM cluster.

• Question 90:

  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.
  C. It patches the MySQL server itself along with any underlying hardware.