ALLInterview.com :: Home Page            
 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                      
Google
   
 
Categories >> Software >> Databases >> Oracle >> Oracle General
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions (718)
 OCI interview questions  OCI Interview Questions (10)
 Architecture interview questions  Architecture Interview Questions (75)
 Oracle Security interview questions  Oracle Security Interview Questions (37)
 Database Management interview questions  Database Management Interview Questions (264)
 Forms Reports interview questions  Forms Reports Interview Questions (466)
 Oracle AllOther interview questions  Oracle AllOther Interview Questions (181)
Question
What is the difference between RBBMS & DBMS?
 Question Submitted By :: Oracle-General
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
rdbms means relational database management system.......it
tells about the relationship between the dataitems.......
the dbms means database managment system
 
Is This Answer Correct ?    5 Yes 1 No
B.jaganathan
 
Answer
# 2
DBMS has to be persistent, that is it should be accessible
when the program created the data ceases to exist or even
the application that created the data restarted. A DBMS
also has to provide some uniform methods independent of a
specific application for accessing the information that is
stored.

RDBMS is a Relational Data Base Management System
Relational DBMS. This adds the additional condition that
the system supports a tabular structure for the data, with
enforced relationships between the tables. This excludes
the databases that don't support a tabular structure or
don't enforce relationships between tables.

Many DBA's think that RDBMS is a Client Server Database
system but thats not the case with RDBMS.

Yes you can say DBMS does not impose any constraints or
security with regard to data manipulation it is user or the
programmer responsibility to ensure the ACID PROPERTY of
the database whereas the rdbms is more with this regard bcz
rdbms define the integrity constraint for the purpose of
holding ACID PROPERTY.

I have found many answers on many websites saying that
DBMS are for smaller organizations with small amount of
data, where security of the data is not of major concern
and RDBMS are designed to take care of large amounts of
data and also the security of this data.
 
Is This Answer Correct ?    2 Yes 0 No
Dinesh Kulkarni
 
 
 
Answer
# 3
RDBMS means telling the relation among the table.
DBMS means interrelated data&set of programmes to access
those data
 
Is This Answer Correct ?    1 Yes 0 No
Uma
 
Answer
# 4
one cannot differentiate between DBMS and RDBMS as RDBMS is one of the types of DBMS.DBMS has many types like RDBMS,ORDBMS,hierarchial dbms,network dbms..... 
Is This Answer Correct ?    1 Yes 0 No
Saiprasanna
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?   1
am completed mca2011 how get certification in oracle   1
Difference between join and a subquery? Base-Automation 6
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit Polaris 2
hai, when to use char and varchar2....?   2
how to find full database size Birlasoft 1
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?   1
can we pass two out parameters at a time in function?please answer to my question Wipro 3
What is an Index ?   2
What is a data segment ?   1
What is a Redo Log ?   2
what is index?   4
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com