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 (720)
 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 (182)
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
 
How do we know whether an index is created on a table ??? TCS 1
sql command 2 know current database   4
What is a Private Synonyms ?   1
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?   1
What are joins..how many types of joins are there? TCS 27
What is the difference between column level constraints and table level constraints? IBM 13
What are the composite date types in oracle? HCL 6
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]   2
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?   1
when i run my query on yesterday it is fast but today it is slow why?   1
What are the trigger associated with image items ? Oracle 1
find the second highest salary of the emp table   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