Multiple choice technology databases

Dual table can be deleted, dropped or altered or updated or inserted ?

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The DUAL table in Oracle is technically a regular table that can be manipulated with DDL/DML operations like DROP, DELETE, ALTER, UPDATE, or INSERT. However, Oracle strongly recommends against modifying DUAL as it's used internally for SELECT statements and system functions. While these operations are possible, altering DUAL can break critical system functionality.

Keep practicing — related questions