MySQL 8.0 Database Administrator — Question 50

What is the correct syntax for using transparent data encryption with an existing InnoDB table?

Answer options

• A. ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';
• B. ALTER TABLE t1 ENCRYPTION='Y';
• C. ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;
• D. ALTER TABLE t1 SET TDE = 'ON';

Correct answer: B

Explanation

The correct answer is B because it correctly specifies the syntax for enabling encryption on an existing InnoDB table. Options A, C, and D contain incorrect syntax or commands that do not apply to the context of InnoDB table encryption.