Oracle Exam 1Z0-908 Topic 11 Question 77 Discussion

Actual exam question for Oracle's 1Z0-908 exam

Question #: 77
Topic #: 11

[All 1Z0-908 Questions]

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

AALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';

BALTER TABLE t1 ENCRYPTION='Y';

CALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;

DALTER TABLE t1 SET TDE = 'ON';

Show Suggested Answer

Suggested Answer: A, D, E

by Gerardo at Apr 29, 2024, 10:18 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

4 days ago

I think option C is the correct syntax. It explicitly mentions using the master key for encryption.

upvoted 0 times

...

12 days ago

But option C makes more sense because it specifies using a master key for encryption.

upvoted 0 times

...

18 days ago

I disagree, I believe it is A) ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y'.

upvoted 0 times

...

25 days ago

I think the correct syntax is C) ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY.

upvoted 0 times

...