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
 
What is Rollback Segment ?   3
What is a Sequence ?   3
how do u know the total no of rows in a table?   5
When a form is invoked with call_form, Does oracle forms issues a save point ? Oracle 1
sql query to get zero records from a table CTS 6
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance. JPMorgan-Chase 4
what is cartesian product?   2
What is a Tablespace?   4
where we have to use ON clause and where we have to use USING clause in JOINS   2
Please explain the difference between outer join and inner join? With examples would be appreciable..! IBM 5
what are stored procedures? TCS 6
find out the second highest salary? TCS 52
 
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