DBMS vs. RDBMS
Answers were Sorted based on User's Feedback
Answer / vamsikrishna.ch
• Relationship among tables is maintained in a RDBMS whereas
this not the case DBMS as it is used to manage the database.
• DBMS accepts the ‘flat file’ data that means there is no
relation among different data whereas RDBMS does not accepts
this type of design.
• DBMS is used for simpler business applications whereas
RDBMS is used for more complex applications.
• Although the foreign key concept is supported by both DBMS
and RDBMS but its only RDBMS that enforces the rules.
• RDBMS solution is required by large sets of data whereas
small sets of data can be managed by DBMS.
Is This Answer Correct ? | 17 Yes | 0 No |
What happens if you lost a data file?
Explain coalesce function?
What is Database Trigger ?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is a view and how is it different from a table?
Explain joins in oracle?
What happens to indexes if you drop a table?
What are the numeric comparison operations?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
What happens to the data files if a tablespace is dropped?
How to convert characters to times in oracle?
What is Public Database Link ?