Basic Oracle Questions (DBA)

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’

Taidot: Tietokannan hallinto, Oracle, tietojärjestelmäarkkitehtuuri

Näytä lisää: writing outline template, would questions, steps report writing, steps writing report, senior oracle developer, script writing app, oracle database developer, need oracle developer, basic report writing, dba software, senior software developer, security questions, junior developer, dba, senior develop, senior account, security architecture, using oracle, writing script template, create app lock, script oracle database, create database oracle, software lock, architecture report template, lock security app

About the Employer:
( 4 reviews ) Carmel, United States

Projektin tunnus: #4245319

Myönnetty käyttäjälle:


Bob already has the answers.

85 $ USD 1 päivässä
(0 arvostelua)