-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Compare Data Warehouse database and OLTP database?
The data warehouse and the OLTP data base are both relational databases. However, the objectives of both these databases are different. The OLTP database records transactions in real time and aims to automate clerical data entry processes of a business entity. Addition, modification and deletion of data in the OLTP database is essential and the semantics of the application used in the front end impact...
-
-
What is a Synonym ?
A synonym is an alias for a table, view, sequence or program unit.
-
What is a Sequence ?
A sequence generates a serial list of unique numbers for numerical columns of a database's tables.
-
What is a View ?
A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)
-
What is Table ?
A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.
-
-