Oracle Oracle Certifications 1Z0-1093-23 Questions & Answers

• Question 51:

  Your company has decided on a Hybrid Cloud strategy and wants to monitor their cloud and on-premises Oracle databases.

  Which action should they take?

  A. Use the cloud console to monitor all your Exadata systems that are on-premises or in the cloud from a single interface.

  B. Subscribe to cloud events to send custom notifications about cloud Exadata systems to the on-premises Enterprise Manager.

  C. Use Enterprise Manager to monitor all your Exadata systems that are on-premises or in the cloud from a single interface.

  D. Configure the cloud console to send notifications about cloud Exadata systems to the on-premises Enterprise Manager.

  Correct Answer: C

• Question 52:

  You have been brought in to help an organization with slow nightly batch processing running on their Exadata Database Service. You determine that the workload is CPU-bound during the batch window.

  Which command-line tool would you use to script an increase or decrease in OCPUs?

  A. OCI CLI

  B. exacli

  C. ocpucli

  D. dbnodecli

  Correct Answer: A

• Question 53:

  You want to protect all the network communications between your organization network and Oracle Cloud using secure encryption and integrity algorithms.

  Which two statements are correct? (Choose two.)

  A. You should consider leveraging FastConnect.

  B. You should use AES, DES, and EBT certified cryptosystems that Oracle database provides for protecting the confidentiality of Oracle Net Traffic.

  C. You should consider leveraging a VPN.

  D. You should purchase TDE for your cloud environment.

  E. You should configure the database parameters to only allow connections from encrypted clients.

  Correct Answer: AC

• Question 54:

  Which component is NOT included as part of an Oracle NoSQL table Oracle Cloud Identifier (OCID)?

  A. Unique ID

  B. Region

  C. Resource type

  D. Compartment ID

  Correct Answer: B

• Question 55:

  For which two reasons do you need a minimum of three storage cells when using Exadata Database Service? (Choose two.)

  A. High availability

  B. Fast Start Failover of storage cells

  C. Triple mirroring of data

  D. Data Guard

  E. Real Application Clusters

  Correct Answer: AC

• Question 56:

  As part of your daily maintenance process, you log in to Oracle Cloud Infrastructure, select your DB system name, and select the Stop action.

  Which two statements are true about your stopped MySQL Database Service system? (Choose two.)

  A. Any backups associated with the database system are deleted.

  B. You can no longer connect to a stopped MySQL database.

  C. The database system is permanently deleted.

  D. Maintenance starts when the DB system is restarted.

  E. The database system stops billing for all OCPUs associated with it.

  Correct Answer: BE

• Question 57:

  When you created your development database on Exadata Cloud@Customer, you selected "None" for backup location. You now need to enable Automatic backups on the development database with a retention period of 60 days.

  Which action should you perform?

  A. Change the database backup location to a local storage and set the retention period to 60 days.

  B. No action can be taken, because a new backup location cannot be set after creation.

  C. Change the database backup location to an NFS backup location and set the retention period to 60 days.

  D. Change the database backup location to Object storage with the default retention period set.

  Correct Answer: D

• Question 58:

  Your company's security policy requires you to patch the database within a month of a relevant database patch being released by Oracle.

  Which method requires the least amount of downtime?

  A. Create a new database home, patch it to the version you want, and then move the database to the new home.

  B. Download the latest patch from MOS, back up your database, run a precheck, then apply the patch on the database home.

  C. Download the latest patch from MOS, back up your database, and use dbaascli to apply the patch on the database home.

  D. Back up your database, run a precheck, then apply the patch on the database home where the database resides.

  Correct Answer: A

• Question 59:

  You want to create a backup of only the data that was added or changed since the last FULL backup.

  Which type of supported backup by MySQL Database Service must you use?

  A. Incremental

  B. Full

  C. Mirror

  D. mysqldump

  Correct Answer: A

• Question 60:

  Which service is used by default by the MySQL Database Service to store user data to make it more resistant to failures?

  A. OCI Data Safe

  B. OCI File Storage

  C. OCI Object Storage

  D. OCI Block Volumes

  Correct Answer: D