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 (183)
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 will I find the first 5 highest salaried employees in each dept in oracle. IBM 20
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?   1
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..   1
what is Table ?   2
Tell me New Feature of Oracle 10g? Thermotech 5
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar Oracle 1
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)   2
What is a Schema ?   5
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO? IBM 6
what is null value?   9
what is trigger? Oracle 6
What are the differences between a sys and system user and what are the extra privileges available to the sys user? Wipro 1
 
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