Technology Questions

- SQL Server Integration Services:- Used for data transformation and creation. Used in data acquisition form a source system.

- SQL Server Analysis Services: Allows data discovery using data mining. Using business logic it supports data enhancement.

- SQL Server Reporting Services:- Used for Data presentation and distribution access. 

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.

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.

. 

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

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.

Networking is a socioeconomic business activity by which businesspeople and entrepreneurs meet to form business relationships and to recognize, create, or act upon business opportunities, share information and seek potential partners for ventures.

Examples of Business networks are ::

1. Casual contact networks

2. Strong contact networks

3. Community service clubs

4. Professional associations

5. Online/social media networks.

Business intelligence is a concept that covers development of warehousing and business intelligence applications and databases that assist in diagnosing and repairing user issues as well as performance ones. This is an extremely important set of procedures as it engenders quality end-user products and helps company representatives in understanding core issues and resolving them.