Need the following questions answered..as soon as possible. Within the next 3 hours!
1. A lead developer called the other day to lock an account. Outline the steps that you would take to comply with the request.
2. Develop an Oracle report that displays users that are using 80% of their quota limits
3. Use Oracle to create a PUBLIC database link and a PRIVATE database link and discuss two of the security implications. Provide an example for each implication.
4. 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 username 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 DEFAULT profile.
e. The TOOLS tablespace has a 10 MB quota.
Note: You must set the initialization parameter DB_CREATE_FILE_DEST to the location where the Oracle datafiles reside. I have already set this for you as ‘c:\oraclexe\app\oracle\oradata’