From Oracle documentation: You can view all tables with columns marked UNUSED in the data dictionary views USER_UNUSED_COL_TABS, DBA_UNUSED_COL_TABS, and ALL_UNUSED_COL_TABS.
Source: https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/ALTER-TABLE.html
B C E are all correct according to Oracle "SET UNUSED Clause"
https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/ALTER-TABLE.html#GUID-552E7373-BF93-477D-9DA3-B2C9386F2877
when you query the dba_unused_col_tabs view which displays a list of all tables with un-used columns, including counts of the number of columns within a table that are unused but it will not show the names of the unused columns so B is wrong
This section is not available anymore. Please use the main Exam Page.1z0-071 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
f4a3ee3
6 days, 9 hours agoShahedOdeh
10 months agoShahedOdeh
10 months agolucemqy
1 year, 8 months agoShahedOdeh
10 months agomusafir
2 years agoshotcom
1 year, 9 months agoNelita
2 years, 1 month agoSbablo
2 years, 1 month agoshotcom
1 year, 9 months agoSbablo
2 years, 1 month ago