Interested to Buy Any Domain ? << Click Here >> for more details...
Explain DBMS, RDBMS?
- 6 Answers
- 23680 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nagarajan p
dbms is a collection of data in a database
rdms is a collection of related data in a database
| Is This Answer Correct ? | 59 Yes | 12 No |
Answer / antony
Explain the DBMS, RDBMS?
DBMS:
DBMS is Data Base Management System. It is a
collection of data in a database. DBMS is just collection
of tables that dont have relations and dependencies.Client
Side processing File Level traffic is High Distributed
Network not supported Nomenclature concept of File. Dbms
won't allow you share the data server to clint.Only one
user can access the database at a time in DBMS.ADBMS is
enabled by vector field and is "one"dimensional.
RDBMS:
RDBMS is Relational Data Base Management System.
RDBMS is a collection of related data in a database.In
RDBMS we have relations of tables say primary key ,foreign
keys relation ,,that involves refrential integrity and
normalication like concepts where as Server Side Processing
Row Level Locking Network traffic is Low Distributed
Network Supported Nomenclature Concept of Table.But in
RDBMS we can share data server to client.But RDBMS allows
simultaneous access of users to the database. RDBMS is
enabled nu static "2"-dimensional tables.
| Is This Answer Correct ? | 43 Yes | 7 No |
Answer / ghous
in rdbms we have relations of tables say primary
key ,foreign keys relation ,,that involves refrential
integrity and normalication like concepts
where as
dbms is just collection of tables that dont have relations
and dependencies
| Is This Answer Correct ? | 47 Yes | 13 No |
Answer / sachin patil
DBMS : Client Side processing
File Level Locking
Network traffic is High
Distributed Network not Supported
Nomenclature
Concept of File
RDBMS : Server Side Processing
Row Level Locking
Network traffic is Low
Distributed Network Supported
Nomenclature
Concept of Table
| Is This Answer Correct ? | 23 Yes | 4 No |
Answer / rajkamal
*RDBMS is use to the relation between the table and objects
*DBMA is use to the collection of information and table
| Is This Answer Correct ? | 10 Yes | 2 No |
Answer / shaheem
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 ? | 3 Yes | 0 No |
How to populate a table in sql server?
What are the differences between ms sql server & oracle?
What is 'Join' and explain its various types.
How do I setup a local sql server database?
An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).
What is tempdb database? : SQL Server Architecture
What is the difference between char and varchar2 datatype in sql?
What are Row versions of DataRow?
How do I determine how many instances of sql server are installed on a computer?
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????
What is model database? : SQL Server Architecture
Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
