Basic Oracle Questions (DBA)

Fertiggestellt Veröffentlicht Feb 14, 2013 Bezahlt bei Lieferung
Fertiggestellt Bezahlt bei Lieferung

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’

Disregard the last note of "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’"

Not needed here.

Datenbankverwaltung Oracle Softwarearchitektur

Projekt-ID: #4245319

Über das Projekt

1 Vorschlag Remote Projekt Aktiv Feb 14, 2013

Vergeben an:

bobtech247

Bob already has the answers.

$85 USD in 1 Tag
(0 Bewertungen)
1.9