1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ72

Database Security

Which syntax correctly enables transparent data encryption for an existing InnoDB table?

  • 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';
Explanation

For an existing InnoDB file-per-table tablespace, transparent data encryption is enabled with the ALTER TABLE ... ENCRYPTION = 'Y' clause. A configured keyring component or plugin is required for InnoDB data-at-rest encryption.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!