Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Is the Star schema suited to OLTP ? If Star Schema is suitable for PLTP, then it is generally used in operational systems, operational data stores, or an EDW.
on 6/23/2015 | Category:
Sql Server Interview questions
| Views: 315 |
Select from following answers:
Online Transaction Processing is a standard, normalized database structure and which designed for transactions, means that inserts, updates, and deletes must be fast. OLAP (Online Analytical Processing and Star Schema are interchangeable words. An OLAP system consists of a relational database designed for the speed of retrieval, not transactions, and holds read-only, historical, and possibly aggregated data.
Show Correct Answer
Many Interviews |
< Previous :
What is the purpose of ETL process in DW?
Next > :
what is th eoutput of below SQL ? SELECT CASE NE ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
what is th eoutput of below SQL ? SELECT CASE NEXT VALUE FOR [dbo].[ ...
In Relational database Data is stored as record types and the relation ...
Which of the following manages the allocation of the space on the disk ...
Foreign Key can be null
A traditional database stores just data – with no procedures
If a piece of data is stored in two places in the database, then,
Database management systems are intended to?
Which is the make given to the database management system which is abl ...
Latest Interview Questions
Which property is used to change the left margin of an element?
How do you add a background color for all <h1> elements?
Which is the correct CSS syntax?
What is the full form of CSS ?
How can you insert a search icon?
Which class is used to create a button group?
Which button class is used to create a large button?
The Bootstrap grid system is based on how many columns?