Oracle Cloud Database Services 2021 Specialist (1Z0-1093-21) Sample Questions:
1. How many DB systems must you provision before you can enable Oracle Data Guard for a virtual machine DB system database?
Ans: One with the primary database, because a new DB system with the standby database is created and associated with the primary database when you enable Oracle Data Guard.
2. 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?
Ans: use the Move Database option from the console.
Schedule a downtime window with the Test teams who use the 193B database.
3. You enable automatic backups on your Exadata Cloud@Customer.?
Ans: Transparent Data Encryption (TDE) keystore (wallet)
4. After you have provisioned a virtual machine (VM) database (DB) system, what action can you take to meet changes in block storage requirements?
Ans: If a vm DB system requires more block storage, increase the storage at any time without impacting the system.
5. Which FOUR storage options are available in Oracle Cloud Infrastructure (OCI)?
Ans: Local storage
Block Storage
File Storage
Object Storage
6. Which is NOT a prerequisite for patching Grid Infrastructure or database homes when using the console?
a) Oracle Clusterware is down on the VM cluster.
7. You want to permanently delete the DB System and its attached HeatWave cluster. Which action should you perform?
Ans: Delete the DB system and it will also delete the attached HeatWave Cluster.
8. 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 Cloud Service.
How do you do this?
Ans: Use the Create Backup button in the backup section of the Database Details page.
9. What information is required to connect to the NoSQL Database Cloud Service?
Ans: signing key fingerprint, API signing key, tenancy OCID
10. What THREE steps must you perform to connect to a MySQL database in the database system by using SSH and MySQL Shell?
a) Connect to the MySQL Database Service instance.
c) Start MySQL Shell on the compute instance.
d) SSH into the compute instance from your local machine.
11.