Multiple choice technology programming languages

Maximum number of datafiles per DB are ?

  1. 128,000

  2. 64,000

  3. 32,000

  4. 16,000
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle, the maximum number of datafiles per database is 64,000 (for newer versions) or 32,767 (for older versions). This is a hard limit on the database's tablespace structure. The question lists 64,000 which is the correct maximum for modern Oracle versions.

Keep practicing — related questions