Technology Questions

ALTER DATABASE DATAFILE <datafile_name> RESIZE <new_size>; 

A Control file records the physical structure of the database. It contains the following information. Database Name ,Names and locations of a database’s files and redolog files. Time stamp of database creation.

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.

There are lot of ways are there to use the conditional formatting, most of the Process flow maintains more attention in the loops, alias and contextCheers.

Some of the standard Business Intelligence tools in the market According to there performance 

1)MICROSTRATEGY 

2)BUSINESS OBJECTS,CRYSTAL REPORTS 

3)COGNOS REPORT NET 

4)MS-OLAP SERVICES

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

SQL * DBA - This allows DBA to monitor and control an ORACLE database. SQL * Loader - It loads data from standard operating system files (Flat files) into ORACLE database tables. Export (EXP) and Import (imp) utilities allow you to move existing data in ORACLE format to and from ORACLE database.

ALTER TABLESPACE ADD DATAFILE <datafile_name> SIZE <size>