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

Oracle 1Z0-1093-23 Online Questions & Answers

• Question 1:

  In which case can you fast provision a virtual machine (VM) database (DB) systems, using Logical Volume Manager (LVM) for storage management?

  A. Oracle Database versions 18c and greater
  B. Oracle Database versions 12.2 and greater
  C. Oracle Databases that could use Automatic Storage Management (ASM)
  D. any currently supported release of the Oracle Database
  D. any currently supported release of the Oracle Database

• Question 2:

  Resources are allocated to the DB system based on the shape selected.

  Which two are options for a DB system? (Choose two.)

  A. Two-Node Virtual Machine with Automatic Storage Management (ASM) as the storage management software
  B. Single-Node Virtual Machine with Logical Volume Manager (LVM) as the storage management software for the "fast provisioning" option
  C. Single-Node Virtual Machine with Local Storage
  D. Two-Node Virtual Machine with Logical Volume Manager (LVM) as the storage management software
  A. Two-Node Virtual Machine with Automatic Storage Management (ASM) as the storage management software
  B. Single-Node Virtual Machine with Logical Volume Manager (LVM) as the storage management software for the "fast provisioning" option

• Question 3:

  Which statement is FALSE related to loading a table into HeatWave?

  A. Data is distributed among analytics nodes by slicing tables by vertically.
  B. Data is read from InnoDB using batched, multi-threaded reads.
  C. Data is partitioned by primary key unless data placement keys are defined.
  D. Data is converted into columnar format and sent over the network.
  A. Data is distributed among analytics nodes by slicing tables by vertically.

• Question 4:

  When a customer brings a Database Enterprise Edition license to their Oracle Exadata Database Service, what are they entitled to use?

  A. Transparent Data Encryption (TDE), Diagnostics Pack, Tuning Pack, Data Masking and Subsetting Pack, and Real Application Testing
  B. Multitenant for four or more PDBs, Transparent Data Encryption (TDE), Diagnostics Pack, and Tuning Pack
  C. Active Data Guard, Transparent Data Encryption (TDE), Data Masking and Subsetting Pack, and Real Application Testing
  D. Database In-Memory, Diagnostics Pack, Tuning Pack, Data Masking and Subsetting Pack, and Real Application Testing
  A. Transparent Data Encryption (TDE), Diagnostics Pack, Tuning Pack, Data Masking and Subsetting Pack, and Real Application Testing

  ---

  Explanation/Reference:

• Question 5:

  You used the "Stop" option from the Console of an Exadata Cloud Service virtual machine within a VM cluster. What impact does this have?

  A. TheExadata Cloud Service is stopped.
  B. All the virtual machines in the VM cluster are stopped.
  C. All the databases and infrastructure associated with the Exadata Cloud Service are stopped.
  D. The Stopped virtual machine is not available to any other database deployment.
  D. The Stopped virtual machine is not available to any other database deployment.

• Question 6:

  Which two use cases can be used by the Oracle database with Object Storage in Oracle Cloud Infrastructure (OCI)? (Choose two.)

  A. Database datafiles
  B. Database backups
  C. Database log files
  D. Database binaries
  B. Database backups
  C. Database log files

• Question 7:

  You want to permanently delete the DB System and its attached Heatwave cluster.

  Which action should you perform?

  A. Terminate the DB system and drop the associated Heatwave Cluster.
  B. Drop the DB system and terminate the associated Heatwave Cluster.
  C. Delete the Heatwave Cluster and it will also delete the DB system.
  D. Delete the DB system and it will also delete the attached Heatwave Cluster.
  D. Delete the DB system and it will also delete the attached Heatwave Cluster.

• Question 8:

  You use the Oracle Cloud Infrastructure console to create a MySQL DB system. You give it the name "mysql" and set the administrator username to "mysql.sys." You give it a data storage size of 50 GB and set the host name to "mysql-host."

  You do not specify a Maintenance Window start day and time.

  Which action causes an error?

  A. Storage size is too small.
  B. Username "mysql.sys" is reserved.
  C. Host name should contain only letters.
  D. Maintenance Window start time is required.
  B. Username "mysql.sys" is reserved.

• Question 9:

  Which users created on Database Servers can be used for both Oracle database and host management of your Exadata Database Service?

  A. root, opc, oracle, and grid users
  B. root, opc, oracle, grid, and cloud users
  C. opc, oracle, and grid users
  D. root, oracle, and grid users
  A. root, opc, oracle, and grid users

• Question 10:

  Which two statements are true about monitoring a DB system in Oracle Cloud Infrastructure (OCI)? (Choose two.)

  A. Advanced Database Management features for Oracle Cloud Databases with the Full Management option is available at no additional cost by enabling the feature on the Database details page.
  B. Performance Hub is a time-based monitoring system that provides information only on CPU utilization and SQL query response times.
  C. You can view database performance analysis and tuning through Performance Hub, which provides a consolidated view of real-time and historical performance data.
  D. You can view Database Metrics directly in the console with Virtual Machine DB Systems by navigating to Observability and Management and then selecting Database Management.
  E. You can view database performance analysis and tuning through Performance Hub, which provides only a consolidated view of historical performance data for comparative analysis.
  C. You can view database performance analysis and tuning through Performance Hub, which provides a consolidated view of real-time and historical performance data.
  D. You can view Database Metrics directly in the console with Virtual Machine DB Systems by navigating to Observability and Management and then selecting Database Management.

  ---

  Explanation/Reference: