• Answer A is RIGHT: Oders is Parent table with PRIMARY KEY ord_no, Order_items is child table which ord_no is REFERENCE KEY that reference ord_no of Parent table, now drop PRIMARY KEY on Orders by command: ALTER TABLE orders DROP COLUMN ORD_NO CASCADE CONSTRAINTS;
• Answer D is RIGHT: ORA-12984: cannot drop partitioning column
• Answer F is RIGHT: Unused Columns Count against 1000-column Table Limit Causing ORA-01792 on Compressed Table (Doc ID 2259600.1) and "ORA-01792: Maximum Number Of Columns In A Table Or View Is 1000" AND HIDDEN_COLUMN name is recreated with date and timestamp (Doc ID 2624150.1)
i think so too
F is true - i tested it
BC are false
A is true, but you have to add it to
ALTER TABLE <table_mame> SET unused (<column_name>) CASCADE CONSTRAINTS;
before you drop unused constraints
E should be wrong, could not find a way to undo this with roll back, this seems already the case if it is set to unused
A - TRUE; e.g. ALTER TABLE departments DROP COLUMN deptno CASCADE CONSTRAINTS;
B - FALSE; In Oracle Database 19c, the space occupied by an unused column is automatically reclaimed when the row containing that column is next updated. The space is released and becomes available for reuse within the block.
C - FALSE; see B
D - TRUE; partition key column cannot be dropped. When an attempt to drop the column is made, an error "ORA-12984: cannot drop partitioning column" occurs.
E - TRUE; ALTER TABLE documentation says "Until you actually drop these columns, they continue to count toward the absolute limit of 1000 columns in a single table."
I am sorry, last two options are
E - FALSE; DDL commands cannot be rolled back
F - TRUE; ALTER TABLE documentation says "Until you actually drop these columns, they continue to count toward the absolute limit of 1000 columns in a single table."
A is correct
B is correct
F is correct : Unused columns count against the 1000-column limit for tables in an Oracle database. The total count of columns that count against this limit can be obtained by getting a count from DBA_TAB_COLS
Is B really correct?
According to:
https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-tables.html#GUID-29CA8FDC-55FB-4BEF-AE4A-5D1B4D2BE1E1
"The ALTER TABLE...DROP UNUSED COLUMNS statement is the only action allowed on unused columns. It physically removes unused columns from the table and reclaims disk space. "
upvoted 2 times
...
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.
dotruonghan
Highly Voted 3 years, 11 months agoEkos
3 years, 6 months agoRivaldo11
Highly Voted 3 years, 11 months agoNowOrNever
3 years, 11 months agoHassanShami
Most Recent 1 month, 2 weeks agonautil2
9 months, 3 weeks agonautil2
9 months, 3 weeks ago0z0n3
1 year, 1 month agocristycool
1 year, 2 months agoalexbraga93
1 year, 7 months agotrgbighero
1 year, 8 months agoPhineas
1 year, 11 months agomitosenoriko
2 years agoemburria
2 years, 5 months agoryuah
2 years, 6 months agogabriel3600
3 years agodotruonghan
3 years, 11 months agoNiciMilo
4 years ago