I am using Oracle Database XE 11.2 and I just want to know  the steps I need do in order to do the assignment. I'm having trouble finding  how to do it anywhere.

 

Here is the assignment:

 

1.  You were just  hired as a new junior Oracle database administrator to assist a team of five  senior database administrators. In your first week, you were handed the task of  writing a script as a template for creating database users. The script is to  prompt the administrator for a user name and password, and the script creates  the user according to the following guidelines: 

      a.  The default tablespace is TOOLS. 

      b.  The temporary tablespace is TEMP_TOOL_GROUP. 

      c.  The account is initially locked. 

      d.  The user account will be assigned to the  DEFAULT profile. 

      e. The TOOLS  tablespace has a 10 MB quota.

 

2.  Outline the steps  to create a database user account.

 

3. What procedures would you follow if you were told that an  employee was terminated?