Oracle MySQL 2021 Implementation Essentials Sample Questions:
1. Which MySQL Enterprise Edition plug-in replaces real values with substitutes?
A) MySQL Enterprise No-Login Authentication
B) MySQL Enterprise Audit
C) MySQL Enterprise Scalability
D) MySQL Enterprise Data Masking and De-identification
E) MySQL Enterprise Transparent Data Encryption (TDE)
2. When using an Oracle Cloud Infrastructure Compute Instance with MySQL Enterprise Edition installed, you have two choices for backup destinations. What are these two choices?
A) Both Cloud storage and local storage
B) Flash-archive recovery area
C) Cloud tape library
D) Cloud storage only
3. Which three options are valid reasons for using a primary key in a table?
A) automatic storage of data in a sorted order
B) preventing duplicate keys
C) maintaining a history of row insertions or updates
D) increasing performance when using select statements
E) exporting data faster with mysqldump
F) to make it easier to change the PRIMARY KEY value
4. Which Oracle product is certified to work with MySQL Enterprise Edition?
A) Oracle Data Pump
B) Oracle Enterprise Backup
C) Oracle Application Express
D) Oracle Enterprise Manager
5. Which three are recommended configurations for installing and running MySQL InnoDB Cluster?
A) smaller VM,s work best - with a maximum of eight vCPU,s and 16GB of RAM
B) The number of machines per group must be 3, 5, 7 or 9.
C) Groups must be in even numbers; 2, 4, 6, 8.
D) isolated machine resources
E) use SSD,s for data and replication logs
F) Networks must be in separate regions.
G) Use Network-attached storage (NAS) for the data files.
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: A,D | Question # 3 Answer: B,D,E | Question # 4 Answer: D | Question # 5 Answer: B,C,G |

We're so confident of our products that we provide no hassle product exchange.


By Kevin


