Oracle MySQL 2019 Implementation Essentials - 1Z1-920 Exam Practice Test

A. unique PRIMARY key values for both child and parent tables B. an index on the foreign key C. a REFERENCES in the child table to the parent table D. a TRIGGER on the child table for cascading delete statements E. the SET_FOREGIN variable in the my .cnf file

A. START SLAVE B. START RUN SLAVE C. SLAVE RUN D. RUN SLAVE E. SLAVE START

A. MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI. B. MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication. C. MySQL Servers with Group Replication to replicate data to all members of the cluster. D. MySQL Router to ensure client requests are load balanced and routed to the correct servers. E. MySQL Online Hot Backup to keep data consistent and always ready to be used.

A. Option D B. Option B C. Option A D. Option C

A. DELETE population FROM city; B. ALTER TABLE city DELETE population; C. DROP population FROM city; D. ALTER TABLE city LESS population; E. ALTER TABLE city DROP population;

A. Delete all binlog files manually on the file system to release storage spaces. B. To safely purge binary log files, perform these steps:
1. On each slave server, use show slave status to check which log file it is reading.
2. Obtain a listing of the binary log files on the master server with show binary logs.
3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up-to-date, this is the last log file on the list.
4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)
5. Purge all log files up to but not including the target file by using the purge binary logs statement C. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days. D. Execute the purge binary logs statement without argument. E. On the Master server, disable binlog by removing the --log-bin option.

A. GR only works with MySQL versions 8.0.12 or higher. B. The minimum number of required nodes for achieving a consensus is two. C. Data to be replicated must be stored in the InnoDB transactional storage engine. D. Primary keys are required on every replicated table. E. The use of global transaction identifiers is required. F. The binary log format must be set to mixed.