Oracle Configuration!!

Question 1

OLTP (Online Transaction Processing)

Answer 1

Most used Database.

They have online users that access the system.

These systems are typically used for order entry, such as retail, sales, credit card validation, ATM transactions, and so on.

Supports large #s of online users simultaneously accessing RDBMS.

They are Read & Write intensive.

Question 2

DSS (Decision Support System)

Answer 2

Used to assist the decision-making process. eg- How sales is doing in a given region.

Also helps in decision making by providing good data.

Read intensive.

large set Data.

long-running queries.

Question 3

DATA WAREHOUSE

Answer 3

Large scale systems.

Usually 100’s of gigabytes.

Contains both OLTP/DSS

Have some attributes of DSS System such as,

Long-running queries and possible online components.

Question 4

DATA MART

Answer 4

100 gigabyte or less.

Supports many online users for decision support function.

Question 5

VIDEO SERVER

Answer 5

Supports both Static and Dynamic web pages.

Used web Commerce applications.

Question 6

OLAP

Answer 6

Usually used in relationship with Multi dimensional Data.

Supports few or many users depending on……

Question 7

DB software Installation/Configuration of Hardware and Software with SYS/ADMIN

Answer 7

Security Admin, secure DB.

Adding users/ administers quotas, auditing and checking for security problems.

Performance Tuning and Monitory ( running well/returning/constantly and continuously.

Backup and Recovery: System breaks need be recovered.
Protection from loosing Data.

Backup strategies….developing an effective backup and recovery strategies and implemented test system checks.

Routine Scheduled Maintenance…early hours and weekends.

Troubleshooting - When data is down.

Failure Recovery - Need to have a contingency plans for system outages.

OTHER DUTIES.

Data Analysis - Called to analyze Data stored in the database and to make recommendations relating to performance and efficiency of the Data Storage.

Database Design - Helps developing team. Assisting developers with SQL and stored procedure development.

Should be prepared for developers and users.

Enterprise standards and naming conventions.

Development of production Migration procedure.(OFA)

Environmental documentation/ Changes to app/software updates.

Consult with Development team and users in Evaluation of new Software/ hardware purchases.

Capacity Planning - Anticipating the future needs of users based on usage recorded.