Oracle Database Developer Question:

Download Job Interview Questions and Answers PDF

How you Unlock the Sample User Account in Oracle?

Oracle Database Developer Interview Question
Oracle Database Developer Interview Question

Answer:

Your 10g XE server comes with a sample database user account called HR. But this account is locked. You must unlock it before you can use it:

* Log into the server home page as SYSTEM.
* Click the Administration icon, and then click Database Users.
* Click the HR schema icon to display the user information for HR.
* Enter a new password (hr) for HR, and change the status to Unlocked.
* Click Alter User to save the changes.

Now user account HR is ready to use.

Download Oracle Database Developer Interview Questions And Answers PDF

Previous QuestionNext Question
How you Shutdown your 10g XE Server from Command Line?How you can Change System Global Area (SGA) in Oracle?