difference between OLTP and OLAP
State the difference between OLTP and OLAP?
Expert
OLTP is defined as Online Transaction Processing which consists of the normalised tables. However, OLAP or Online Analytical Programming consists of the history of OLTP data that is non-volatile acts as Decisions Support System.
Describe briefly perform recovery?
Explain about Server Job and Parallel Jobs?
Explain the way of transactions in Sybase. How it relates with partition assignment.
Define the explaining plan and how is this used?
Why Increase correct timeslice -201?
Explain the drill mode?
Write a short note on the difference between a dynamic and materialized view?
Explain the master/detail reports?
How do I take a known dollar (totalcost) such as $240.00, back out the sales taxes from the known values using the States (VA and WV) sales tax, showing the difference so that I can print an invoice, with the fields Customer name, address, city, state Subtotal, sales tax and totalcost $240.00. All
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
18,76,764
1940630 Asked
3,689
Active Tutors
1417747
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!