Technology Questions

Customer Satisfaction, Problem Resolution, Loyalty & Customer Value, Up-sell & Cross-sell, Customer Churn, Customer Segmentation, Cost Control, Revenue & Profitability, Performance Management, Outage / Downtime, Defect, Marketing Effectiveness, Collections are some of the examples of BI initiatives.

A DBA is a Database Administrator, and this is the most common job that you find a database specialist doing. There are Development DBAs and Production DBAs.

- A Development DBA usually works closely with a team of developers and gets more involved in design decisions, giving advice on performance and writing good SQL.

  That can be satisfying at a human level because you are part of a team and you share the satisfaction of the teams accomplishments.

- A Production DBA (on the other hand) is responsible for maintaining Databases within an organization, so it is a very difficult and demanding job. He or she, often gets involved when all the design decisions have been made, and has simply to keep things up and running.

  Therefore, of course, it is also a rewarding job, both financially and in terms of job satisfaction. But it is a more "lonely" job than being a Development DBA.

. 

An app can get into InActive state when the user locks the screen or the system prompts the user to respond to some event e.g. SMS message, incoming call etc.

SAP scripts is a word processing tool of SAP which has the following components: Standard text. It is like a standard normal documents. Layout sets. - Layout set consists of the following components: Windows and pages, Paragraph formats, Character formats. Creating forms in the R/3 system. Every layout set consists of Header, paragraph, and character string. ABAP/4 program.

- Installing and upgrading the Oracle Server and application tools.

- Allocating system storage and planning future storage requirements for the database system.

- Managing primary database structures (tablespaces)

- Managing primary objects (table, views, indexes)

- Enrolling users and maintaining system security.

- Ensuring compliance with Oracle license agreement

- Controlling and monitoring user access to the database.

- Monitoring and optimizing the performance of the database.

- Planning for backup and recovery of database information.

- Maintain archived data on tape

- Backing up and restoring the database.

- Contacting Oracle Corporation for technical support.

In SQL, UNION  merges the contents of two structurally-compatible tables into a single combined table.

Use the DBMS_SESSION.SET_SQL_TRACE or

Use ALTER SESSION SET SQL_TRACE = TRUE;

UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.