CoolInterview.com - World's Largest Collection of Interview Questions
Start Your Own website Now
Sponsored Links

Interview Questions
Our Services

Get 9,000 Interview Questions & Answers in an eBook.


  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!



    Send your Resume to 6000 Companies


  • INTERVIEW QUESTIONS ORACLE GENERAL ORACLE DETAILS
    Question :
    Difference between DBMS & RDBMS?

    Posted by: shilpa on 9/1/2007 6:15:49 PM

    Contact shilpa Contact shilpa
    Category General Oracle Interview Questions
    Rating (0.4) By 2066 users
    Added on 9/1/2007 6:15:49 PM
    Views 4576
    Rate it!
    Answers:

    ***Source: wiki.answers.com***

    DBMS stands for Database Management System which is a general term for a set of software dedicated to controlling the storage of data.

    RDMBS stand for Relational DataBase Management System. This is the most common form of DBMS. Invented by E.F. Codd, the only way to view the data is as a set of tables. Because there can be relationships between the tables, people often assume that is what the word "relational" means. Not so. Codd was a mathematician and the word "relational" is a mathematical term from the science of set theory. It means, roughly, "based on tables".



    Posted by: Sailesh Tulluri    

    Contact Sailesh Tulluri Contact Sailesh Tulluri

    DBMS:1)In dbms no relationship concept
    2)It supports Single User only
    3)It treats Data as Files internally
    4)It supports 3 rules of E.F.CODD out off 12 rules
    5)It requires low Software and Hardware Requirements.
    6)FoxPro, IMS are Examples

    RDBMS:
    1)It is used to establish the relationship concept between two database objects, i.e, tables
    2)It supports multiple users
    3)It treats data as Tables internally
    4)It supports minimum 6 rules of E.F.CODD
    5)It requires High software and hardware requirements.
    6)SQL-Server, Oracle are examples



    Posted by: kota siva venkata prasad rao    

    Contact kota siva venkata prasad rao Contact kota siva venkata prasad rao

    DBMS : Data Base Management System
    ..... for storage of data and efficient retrieval of data.
    Eg: Foxpro

    1)A DBMS has to be persistent (it should be accessible when
    the program created the data donot exist or even the
    application that created the data restarted).
    2) DBMS has to provide some uniform methods independent of a
    specific application for accessing the information that is
    stored.
    3)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
    4)In DBMS Normalization process will not be present

    RDBMS: Relational Data Base Management System
    .....the database which is used by relations(tables) to
    acquire information retrieval
    Eg: oracle, SQL..,

    1)RDBMS is based on relational model, in which data is
    represented in the form of relations, with enforced
    relationships between the tables.
    2)RDBMS defines the integrity constraint for the purpose of
    holding ACID PROPERTY.
    3)In RDBMS, normalization process will be present to check
    the database table cosistency
    4)RDBMS helps in recovery of the database in case of loss of
    database due to system failure or any other reason



    Posted by: Krupali Parmar    

    Contact Krupali Parmar Contact Krupali Parmar

    DBMS:
    DBMS DataBaseManagementSystem which is used store large amout of data
    Data Redundancy
    Data Inconsistency
    Data Isolation
    Data Security
    RDBMS:
    Relational DataBaseManagementSystem tells relationship between tables



    Posted by: Sriram    

    Contact Sriram Contact Sriram

    orical Quctions And Answer



    Posted by: suresh    

    Contact suresh Contact suresh

    dbms dbms stands database managemnet system. constraints not use
    relationschip not used to table
    rdbms relational database management system
    constraints are used
    relationships used to table



    Posted by: c.v.kumar    

    Contact c.v.kumar Contact c.v.kumar

    HOW many No.Of Primary Key's Imposed on One Table?

    Ans: Only One Primary Key Should be Imposed on one table..



    Posted by: Nallamothu Srikanth    

    Contact Nallamothu Srikanth Contact Nallamothu Srikanth

    we insert a data in the form of row and column in a table ,and we make a relationship between table,this is a concept of rdbms,
    dbms basically stands for database management system,as here name itself indicate managing a data.



    Posted by: arpit nandwana    

    Contact arpit nandwana Contact arpit nandwana

    DBMS:-it is a subject or concept which deals with mgmt of data.i.e reading,adding,modofying and deleting of data.
    eg:access,foxpro,mysql."oracle",sql-server,sap etc.

    RDBMS:-the database which stores the data in the table format is called as "RDBMS".
    EG;SQL



    Posted by: vishnu    

    Contact vishnu Contact vishnu

    what is normalisation?
    what is the purpose of normalisation?



    Posted by: rajesh kumar chauhan    

    Contact rajesh kumar chauhan Contact rajesh kumar chauhan

    DBMS - Database Management system is a software which is used to store and retrieve the information from the database.

    RDBMS - Relational DBMS.
    All the information cannot be stored in a single table, which leads to some redundancies and inconsistencies. There comes the concept of RDBMS, where the data are stored in the form of relations. That means instead of storing all the informations in a single table, the informations are stored in a multiple tables and are linked through some relations.



    Posted by: Adam    

    Contact Adam Contact Adam

    DBMS:1)In dbms no relationship concept
    2)It supports Single User only
    3)It treats Data as Files internally
    4)It supports 3 rules of E.F.CODD out off 12 rules
    5)It requires low Software and Hardware Requirements.
    6)FoxPro, IMS are Examples

    RDBMS:
    1)It is used to establish the relationship concept between two database objects, i.e, tables
    2)It supports multiple users
    3)It treats data as Tables internally
    4)It supports minimum 6 rules of E.F.CODD
    5)It requires High software and hardware



    Posted by: RAJITHA KUMARI    

    Contact RAJITHA KUMARI Contact RAJITHA KUMARI

    A 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.



    Posted by: manasa.g    

    Contact manasa.g Contact manasa.g

    apart from this I would like to add one more dbms-doesn't support many to many relation shipwhere as rdbms support



    Posted by: ashok    

    Contact ashok Contact ashok

    dbms
    1)it does not support e.f coods rules
    2)it does not allow to make relation between tables
    3) it is single user date base
    rdbms
    1)it support e.f coods rules
    2)it does allow to make relation between tables
    3) it is multiuser date base



    Posted by: sunilkumar    

    Contact sunilkumar Contact sunilkumar

    A dbms is simply Rdbms if it follows more than six rule of E.F.Codd.



    Posted by: swapnil tiwari     

    Contact swapnil tiwari Contact swapnil tiwari

    dbms=====
    it stores the the large data.
    normalization process cannot be done.

    rdbms====
    it tels the relationship amoung the table.
    normalization can be done by rdbms.



    Posted by: harinathan    

    Contact harinathan Contact harinathan

    DBMS-it is a collection of interrelated files.it allows the user to access and modify the data but it is depended on a data models like ADBMS,RDBMS,OODBMS

    RDBMS-it is a DBMS which depends on the relational data model for manipulating the data



    Posted by: srujani goda    

    Contact srujani goda Contact srujani goda

    A DBMS is an the trest of the only database managements systems
    that can be use the RDBMS in an the Relational database Management systems



    Posted by: Dantreliya sanjay h    

    Contact Dantreliya sanjay h Contact Dantreliya sanjay h

    A database management system (DBMS) is a software used to store and manage data.
    A relational dabase management system(RDBMS) is a advance version of DBMS . It also defiend as the relation between two data models.



    Posted by: LAXMIPRIYA BEHERA    

    Contact LAXMIPRIYA BEHERA Contact LAXMIPRIYA BEHERA

    dbms
    1)it does not support e.f coods rules
    2)it does not allow to make relation between tables
    3) it is single user date base
    rdbms
    1)it support e.f coods rules
    2)it does allow to make relation between tables
    3) it is multiuser date base





    Posted by: RACHITA    

    Contact RACHITA Contact RACHITA

    DBMS:data base mangement also known as database manager.
    RDBMS:relatonal database



    Posted by: kavina    

    Contact kavina Contact kavina

    how many E.F Code rule followed by the database, specially Oracle and Sybase



    Posted by: DEVENDRA SILSWAL    

    Contact DEVENDRA SILSWAL Contact DEVENDRA SILSWAL

    A 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.
    and this is completely wrong by definition of RDBMS and DBMS



    Posted by: sulav    

    Contact sulav Contact sulav

    dbms is a collection of interrelated data & set of program to access those data.



    Posted by: rishu kumar sain    

    Contact rishu kumar sain Contact rishu kumar sain

    If you have the better answer, then send it to us. We will display your answer after the approval.
    Rules to Post Answers in CoolInterview.com:-

  • There should not be any Spelling Mistakes.
  • There should not be any Gramatical Errors.
  • Answers must not contain any bad words.
  • Answers should not be the repeat of same answer, already approved.
  • Answer should be complete in itself.
  • Name :*
    Email Id :*
    Answer :*
    Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
    Process Verification  Enter the above shown code:*
    Inform me about updated answers to this question

       
    Related Questions
    View Answer
    What are visual attributes?
    View Answer
    What is a property clause?
    View Answer
    Can a property clause itself be based on a property clause?
    View Answer
    What are the important difference between property clause and visual attributes?
    View Answer
    What are different types of canvas views?
    View Answer
    Explain about content canvas views?
    View Answer
    Explain about stacked canvas views?
    View Answer
    Explain about horizontal, Vertical tool bar canvas views?
    View Answer
    Name of the functions used to get/set canvas properties?
    View Answer
    How can a cross product be created?
    View Answer
    How can a group in a cross products be visually distinguished from a group that does not form a cross product?
    View Answer
    Atleast how many set of data must a data model have before a data model can be base on it?
    View Answer
    Is it possible to have a link from a group that is inside a cross product to a group outside ?
    View Answer
    Is it possible to link two groups inside a cross products after the cross products group has been created?
    View Answer
    What is an user exit used for?
    View Answer
    What are the three types of user exits available ?
    View Answer
    How can values be passed bet. precompiler exits & Oracle call interface?
    View Answer
    How can I message to passed to the user from reports?
    View Answer
    What is a Text_io Package?
    View Answer
    What is a User_exit?
    View Answer


    Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

    View ALL General Oracle Interview Questions

    User Options
    Sponsored Links


    Copyright ©2003-2014 CoolInterview.com, All Rights Reserved.
    Privacy Policy | Terms and Conditions

    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | C Interview Questions & Answers

    Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes


    Cache = 0.03125 Seconds