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

Get Premium 1Z0-908 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Aide

20 days ago

This question is as clear as mud. I'm just going to pick the one that sounds the most technical and hope for the best.

upvoted 0 times

...

Gary

26 days ago

I'm going with option B. It's the most straightforward approach, and I've seen it used in similar scenarios.

upvoted 0 times

Martina

3 days ago

I think option B is the correct syntax for using transparent data encryption with an existing InnoDB table.

upvoted 0 times

...

Levi

27 days ago

Haha, option D sounds like something out of a sitcom. 'SET TDE = ON' - that's not how it works, right?

upvoted 0 times

...

Noble

28 days ago

I'm not sure about this one. The options seem a bit confusing. I'll have to double-check the documentation.

upvoted 0 times

Macy

20 days ago

Option A) ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';

upvoted 0 times

...

Gary

1 months ago

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

upvoted 0 times

Kiera

17 days ago

I would go with option B. It seems like a straightforward way to enable encryption for the table.

upvoted 0 times

...

Johna

20 days ago

I believe option A is the correct syntax. It adds encrypted tablespace to the existing InnoDB table.

upvoted 0 times

...

Brunilda

21 days ago

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

upvoted 0 times

...

Felix

2 months ago

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

upvoted 0 times

...

Stephane

2 months ago

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

upvoted 0 times

...

Felix

2 months ago

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

upvoted 0 times

...