MYSQL Interview Questions

What is the difference between RDBMS and DBMS?
Ans : 1)DBMS does not support a tabular structure and does not enforce relationship
betweeb tables.
         2) DBMS does not enforce security on data manipulation Operations.
             it does not ensure the ACID property.
Where as RDMS ensures all the above property.


Question : What is ACID Property in RDBMS?
Answer : from wikipedia :
Atomicity requires that database modifications must follow an "all or nothing" rule. 


consistency property ensures that any transaction the database performs will
take it from one consistent state to another.


Isolation refers to the requirement that other operations cannot access data that 
has been modified during a transaction that has not yet completed.


Durability is the ability of the DBMS to recover the committed transaction updates 
against any kind of system failure (hardware or software). 


This is Very Good Website for MYSQL Interview Questions :
http://dba.fyicenter.com/Interview-Questions/MySQL/


What is TableSpace ?
Ans :  1) It is a logical unit storage in Oracle Database.
           2) consists of one or more data files.
           3) can be taken into offline or online.
           4) can make read Only.