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

Oracle 1Z0-1093-23 Online Questions & Answers

• Question 91:

  You have permanently deleted your MySQL database system.

  What happens to the two backups that are associated with the deleted database system?

  A. They are archived and moved to Oracle Cloud Infrastructure file storage.
  B. They are retained for their retention periods.
  C. They are automatically deleted along with the database system.
  D. They are moved to Oracle Cloud Infrastructure Object Storage.
  B. They are retained for their retention periods.

• Question 92:

  Your MySQL Database Service system is automatically backed up between midnight and 1 AM. What must you do to change the starting time to 4 AM?

  A. Select Backup Window from the Edit MySQL DB System Details page and set the start time to 4 AM.
  B. Use the mysqlbackup command to establish a 4 AM backup start time.
  C. Update the Oracle Cloud Infrastructure (OCI) MySQL DB System Details page to specify the 4 AM backup window start time.
  D. Edit the OCI MySQL DB System Details to set the Enable Automatic Backups time to 4 AM.
  C. Update the Oracle Cloud Infrastructure (OCI) MySQL DB System Details page to specify the 4 AM backup window start time.

• Question 93:

  Which network is used to facilitate the secure monitoring andadministration of Oracle- managed infrastructure components in Exadata Cloud@Customer?

  A. InfiniBand network
  B. Backup network
  C. Client network
  D. Control plane network
  E. Cloud operations network
  D. Control plane network

• Question 94:

  What THREE steps must you perform to connect to a MySQL database in the database system by usingSSH and MySQL Shell?

  A. Add an ingress rule for port 20.
  B. Instantiate MySQL Shell on the MySQL database system instance.
  C. Connect to the MySQL Database Service instance.
  D. SSH into the compute instance from your local machine.
  E. Start MySQL Shell onthe compute instance.
  B. Instantiate MySQL Shell on the MySQL database system instance.
  C. Connect to the MySQL Database Service instance.
  D. SSH into the compute instance from your local machine.

• Question 95:

  Which statement is FALSE about updating your Virtual Machine DB System database?

  A. Updating the DB system updates the Grid Infrastructure for two-node RAC DB Systems with Automatic Storage Management (ASM) storage management software.
  B. Ensuring /u01 has 15 GB of free space.
  C. Updating the DB System also updates the operating system.
  D. Updating the DB System does NOT update the operating system.
  D. Updating the DB System does NOT update the operating system.

• Question 96:

  When configuringconnectivity for hosts in the VCN, security lists contain defaults for implementing security rules. Which TWO additional rules are needed for database systems? (Choose all correct answers)

  A. allows SQL*NET traffic from within the VCN
  B. allows ONS and FANtraffic from within the VCN
  C. allows SSH traffic from anywhere
  D. allows Path MTU Discovery fragmentation messages
  C. allows SSH traffic from anywhere
  D. allows Path MTU Discovery fragmentation messages

• Question 97:

  In Exadata Cloud Service, you use Oracle Data Guard for disaster recovery. What is the minimum egress requirement needed to enable Data Guard between Exadata Cloud Services?

  A. Tcp traffic only for port 1521 and port 22
  B. Tcp traffic only for port 1521
  C. Tcp traffic only for port 22
  D. Open for all protocols
  B. Tcp traffic only for port 1521

• Question 98:

  What is the minimum Infrastructure usage commitment for Exadata Database Service on Exadata Cloud@Customer (ExaDB-C@C)?

  A. ExaDB-C@C requires a minimum of 48 Hours usage commitment for the Infrastructure.
  B. ExaDB-C@C requires a minimum of 30 Days usage commitment for the Infrastructure and OCPU.
  C. ExaDB-C@C requires a minimum 4 Year usage commitment for the Infrastructure.
  D. ExaDB-C@C requires a minimum of 48 Hours usage commitment for the Infrastructure and OCPU.
  B. ExaDB-C@C requires a minimum of 30 Days usage commitment for the Infrastructure and OCPU.

  ---

  Explanation/Reference:

• Question 99:

  Which two must you create or configure to manage an external database? (Choose two.)

  A. A dynamic group
  B. A database handle
  C. A database group
  D. A database connection
  A. A dynamic group
  D. A database connection

• Question 100:

  Which two circumstances are FALSE when you use the Console to recover a DB systemdatabase from a backup stored in Oracle Cloud Infrastructure Object Storage? (Choose all correct answers)

  A. The pp system has no access to the Oracle Cloud Infrastructure Object Storage service location where the backup is stored.
  B. You want to restore to an existing System Change Number (SCN).
  C. Data Guard must be disabled, or you must first remove the Data Guard association by terminating the standby database before you can restore the database.
  D. Restore the database from an unmanaged backup in Object Storage created directly by using RMAN.
  E. Restore the database from a backup in Object Storage that was created by using the Console or the API.
  A. The pp system has no access to the Oracle Cloud Infrastructure Object Storage service location where the backup is stored.
  D. Restore the database from an unmanaged backup in Object Storage created directly by using RMAN.