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 (719)
 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 (265)
 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
 
9. Display the client name and order date for all orders using the JOIN . . . USING method. Wipro 2
How would you extract DDL of a table without using a GUI tool?   1
There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep Microsoft 4
what is difference between foreign key and reference key AZTEC 3
What is the diff between Oracle and SQL Server   1
what is the uses of cusor Perot-Systems 3
Difference between sub query and nested query ? Keane-India-Ltd 17
What are virtual columns? TCS 2
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz   2
What is Row Chaining ? Cognizent 3
various types of joins   9
i want department wise maxmum salary and empolyee name   6
 
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