Multiple choice

The current password file allows for five entries. New DBAs have been hired and five more entries need to be added to the file, for a total of ten. How can the allowed number of entries be increased in the password file?

  1. Manually edit the password file and add the new entries

  2. Alter the current password file and resize if to be larger

  3. Add the new entries; the password file will automatically grow

  4. Drop the current password file, recreate it with the appropriate number of entries and add everyone again
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Oracle password files have a fixed size determined at creation time. You cannot alter, resize, or edit the file after creation (options A and B are invalid operations). The file does not auto-grow (option C is wrong). To change the entry limit, you must recreate the password file with ORAPWD using a different ENTRIES parameter, then re-add all users (option D is correct, though cumbersome).

Keep practicing — related questions