Free Oracle Cloud Database Services 2021 Specialist Exam 1Z0-1093-21 Exam Practice Test

The /u02 directory containing Oracle Homes (OH) is 80% utilized and you need to free up space in it. you own two Oracle Homes (OH193_A and OH193_B), each with a test database (193A and 193B respectively).You decide to consolidate both databases into a single Oracle Home (OH193. |_A) to free up space. Which TWO actions must you perform? (Choose all correct answers)

• use the Move Database option from the console.
  
• Schedule a downtime window with the Test teams who use the 193B database.
  
• Copy the sqinet.ora file from OH193_B to OH193_A.
  
• Create a new container under 0H193B and migrate the pluggable databases (PDBs) from 193B to 193A.
  

What TWO reasons do you need a minimum of three storage cells when using Exadata Cloud Service? (Choose all correct answers)

• for high availability
  
• for Fast Start Failover of storage cells
  
• for Data Guard
  
• for Real Application Clusters
  
• for triple mirroring of data
  

When configuring connectivity 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)

• allows SQL*NET traffic from within the VCN
  
• allows ONS and FAN traffic from within the VCN
  
• allows SSH traffic from anywhere
  
• allows Path MTU Discovery fragmentation messages
  

You want to connect to your MySQL DB system's endpoint. You create an Oracle Linux compute instance on the same Virtual Cloud Network as your MySQL DB system. Which TWO actions must you perform to connect to your MySQL Database Service system? (Choose all correct answers)

• Install the MySQL client on your local computer.
  
• Define a SQL Developer connection in your MySQL Database Service database system.
  
• Connect to your database system by using the MySQL client on the Linux compute instance.
  
• ssh into the compute instance from your local machine.
  

What information is required to connect to the NoSQL Database Cloud Service?

• API signing key, admin ID, user ID
  
• signing key fingerprint, API signing key, tenancy OCID
  
• user ID, tenancy ID, component ID
  
• tenancy 1D, passphrase, handshake key
  

Which tool should you use to run the LIST FLASHCACHE DETAIL command in the Exadata Cloud Service environment?

• cellcli
  
• OCI CLI
  
• dbaascli
  
• exacli
  

Which THREE are prerequisites for using the MySQL Database Service? (Choose all correct answers)

• You must create a tenancy and be able to sign in to it.
  
• You must download the latest MySQL version from https://edelivery.oracle.com/.
  
• You or your group must be granted the policies described in Mandatory Policies.
  
• You must install the downloaded MySQL version onto Oracle Cloud Infrastructure.
  
• You must create a compartment to store your resources.
  

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? (Choose all correct answers)

• It patches the MySQL server itself along with any underlying hardware.
  
• It analyzes, rebuilds, and optimizes MySQL database tables and indexes.
  
• It patches the underlying operating system of the MySQL database.
  
• It upgrades the associated compute instance to the latest Linux operating system version.
  

Which statement is FALSE about using compartments?

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

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?

• Use the mysqlbackup command to establish a 4 AM backup start time.
  
• Edit the OCI MySQL DB System Details to set the Enable Automatic Backups time to 4 AM.
  
• Update the Oracle Cloud Infrastructure (OCI) MySQL DB System Details page to specify the 4 AM backup window start time.
  
• From the Edit MySQL DB System Details page, select Backup Window and set the start time to 4 AM.