In OLTP - online transaction processing systems relational database design use the discipline of data
modeling and generally follow the Codd rules of data normalization in order to ensure absolute data
integrity. Using these rules complex information is broken down into its most simple structures (a table)
where all of the individual atomic level elements relate to each other and satisfy the normalization
rules.
Friday, April 18, 2008
What is OLTP(OnLine Transaction Processing)?
Labels:
SQL Interview Questions
Subscribe to:
Post Comments (Atom)
Archives
-
▼
2008
(41)
-
►
May
(20)
- Which command using Query Analyzer will give you t...
- What is SQL server agent?
- Can a stored procedure call itself or recursive st...
- What is @@ERROR?
- What is Raiseerror?
- What is log shipping?
- What is the difference between a local and a globa...
- What command do we use to rename a db?
- What is sp_configure commands and set commands?
- What are the different types of replication? Expla...
- What are the OS services that the SQL Server insta...
- What are three SQL keywords used to change or set ...
- What does it mean to have quoted_identifier on? Wh...
- What is the STUFF function and how does it differ ...
- Using query analyzer, name 3 ways to get an accura...
- How to rebuild Master Database?
- What is the basic functions for master, msdb, mode...
- What are primary keys and foreign keys?
- What is data integrity? Explain constraints?
- What are the properties of the Relational tables?
-
▼
April
(21)
- What is De-normalization?
- How to get @@error and @@rowcount at the same time...
- What is Identity?
- What is a Scheduled Jobs or What is a Scheduled Ta...
- What is a table called, if it does not have neithe...
- What is BCP? When does it used?
- How do you load large data to the SQL server datab...
- Can we rewrite subqueries into simple select state...
- Can SQL Servers linked to other servers like Oracl...
- How to know which index a table is using?
- How to copy the tables, schema and views from one ...
- What is Self Join?
- What is Cross Join?
- Which virtual table does a trigger use?
- List few advantages of Stored Procedure.
- What is DataWarehousing?
- What is OLTP(OnLine Transaction Processing)?
- How do SQL server 2000 and XML linked? Can XML be ...
- OPENXML
- What is an execution plan? When would you use it? ...
- Global Temporary Tables
-
►
May
(20)






0 comments:
Post a Comment