Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmasmnth

Which three statements are true about dropping and unused columns in an Oracle database?

Which three statements are true about dropping and unused columns in an Oracle database?

A.

A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

B.

A DROP COLUMN command can be rolled back.

C.

An UNUSED column's space is remained automatically when the block containing that column is next queried.

D.

An UNUSED column's space is remained automatically when the row containing that column is next queried.

E.

Partition key columns cannot be dropped.

F.

A column that is set to NNUSED still counts towards the limit of 1000 columns per table.

Oracle 1z0-071 Summary

  • Vendor: Oracle
  • Product: 1z0-071
  • Update on: Jul 25, 2025
  • Questions: 326
Price: $52.5  $149.99
Buy Now 1z0-071 PDF + Testing Engine Pack

Payments We Accept

Your purchase with ExamsVCE is safe and fast. Your products will be available for immediate download after your payment has been received.
The ExamsVCE website is protected by 256-bit SSL from McAfee, the leader in online security.

examsvce payment method