Oracle Exam 1Z0-071 Topic 2 Question 98 Discussion

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

Question #: 98
Topic #: 2

[All 1Z0-071 Questions]

Which three actions can you perform by using the ALTER TABLE command?

ADrop pseudo columns from a table.

BRestrict all DML statements on a table.

CDrop all columns simultaneously from a table.

DLock a set of rows in a table CE Rename a table.

ERename a table

FEnable or disable constraints on a table.

Show Suggested Answer

Suggested Answer: D, E

by Ahmad at Jul 13, 2024, 02:55 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Levi

9 days ago

I think D, E, and F are the correct answers. Renaming a table, enabling/disabling constraints, and locking rows all seem like valid ALTER TABLE actions.

upvoted 0 times

...

Noe

12 days ago

I believe it can also be used to drop pseudo columns from a table.

upvoted 0 times

...

Tamar

14 days ago

Yes, that's correct. It can also be used to enable or disable constraints on a table.

upvoted 0 times

...

Rolf

23 days ago

I think the ALTER TABLE command can be used to rename a table.

upvoted 0 times

...