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

1 months 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

1 months 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

Reid

9 days ago

I've used option A before, and it worked well for enabling transparent data encryption on an existing InnoDB table.

upvoted 0 times

...

Delpha

15 days ago

I'm not sure, but I believe option C might also work for enabling transparent data encryption on an existing InnoDB table.

upvoted 0 times

...

Martina

20 days ago

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

upvoted 0 times

...

Levi

1 months 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

2 months 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

Dustin

13 days ago

I'm not sure either. Let's check the documentation to be sure.

upvoted 0 times

...

Lezlie

16 days ago

I think that might be the correct syntax.

upvoted 0 times

...

Macy

1 months ago

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

upvoted 0 times

...

Gary

2 months ago

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

upvoted 0 times

Kiera

1 months ago

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

upvoted 0 times

...

Johna

1 months ago

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

upvoted 0 times

...

Brunilda

1 months 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

3 months ago

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

upvoted 0 times

...