ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Database Management
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question 
What are ACID properties?
 Question Submitted By :: Zeadbinyahya
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are ACID properties?
Answer
# 1		 
Atomocity
Certainty
Integrity
Durability
 
Is This Answer Correct ?    2 Yes 7 No
Abc
 
  Re: What are ACID properties?
Answer
# 2		 
Atomocity
Consistenct
Isolated
Durability
 
Is This Answer Correct ?    6 Yes 0 No
Bunty
 
 
 
  Re: What are ACID properties?
Answer
# 3		 
ACID refers to the basic properties of a database 
transaction: Atomicity, Consistency, Isolation, and 
Durability. 

All Oracle database, Oracle RDB and InnoDB transactions 
comply with these properties. However, Oracle's Berkeley DB 
database is not ACID-compliant. 

Atomicity 

The entire sequence of actions must be either completed or 
aborted. The transaction cannot be partially successful. 

Consistency 

The transaction takes the resources from one consistent 
state to another. 

Isolation 

A transaction's effect is not visible to other transactions 
until the transaction is committed. 

Durability 

Changes made by the committed transaction are permanent and 
must survive system failure
 
Is This Answer Correct ?    6 Yes 0 No
Piyush Sharma
 
  Re: What are ACID properties?
Answer
# 4		 
The means by which ACID is enforced in Oracle are :

Undo Segments - for Atomicity
Undo Segments - for Consistency
Undo Segments & Locks - for Isolation
Redo Logs     - for Durability
 
Is This Answer Correct ?    0 Yes 0 No
Naveen
 

 
 
 
Other Database Management Interview Questions
 
  Question Asked @ Answers
 
what is the difference between unique and primary key  2
What are the different methods of backing up oracle database ?  1
What does DLL stands for ?  2
Can we create an List of Values without an RECORD GROUP ?  1
What is the use of NOARCHIEVELOG parameter in Database?  1
What is the use of INDEXES option in EXP command ?  1
What does a COMMIT statement do to a CURSOR?  1
What is the Result of the following 'VIK'||NULL||'RAM' ?  1
Why is it better to use an Integrity Constraint to validate data ?  1
What built_in procedure is used to get IMAGES in Forms 4.5 ?  1
Can A CONTROL BLOCK can sometimes refer to a Basetable ?  1
What is Archived Redo Log ?  1
When the SYSTEM TABLESPACE can be made off-line ?  1
What is the use of CONSISTENT (Ver 7) option in EXP command ?  1
If CPU is very slow What can u do to speed up?  1
What are the different kind of export backups ?  1
What is a logical backup ?  2
Is it possible to Enable or Disable a Database trigger ?  1
When a form is invoked with CALL_FORM does Oracle forms issues?  1
How the status of the Rollback segment can be viewed ?  1
 
For more Database Management Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com