Multiple choice technology databases

Which statement represents a default characteristic of the database if a database is created using the database creation assistant?

  1. To access the HR user account, the account should be unlocked first

  2. All accounts created by the Database Creation Assistant are locked

  3. The SYS and SYSTEM accounts use the same default password as in previous Oracle versions

  4. All accounts created by the Database Creation Assistant initially have expired passwords
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When creating an Oracle database using the Database Creation Assistant, most default accounts are initially locked for security. The HR account (Human Resources schema) exists but must be explicitly unlocked before use. Option A correctly states this requirement. Option B is incorrect because not all accounts are locked (some like SYS/SYSTEM are accessible). Option C is incorrect because modern Oracle versions require password changes, not reusing old defaults. Option D is incorrect because accounts don't have expired passwords initially - they're locked.

Keep practicing — related questions