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 |
Explain the dml?
What are the oracle differences between nvl and coalesce
What is oracle database 10g express edition?
How to define default values for formal parameters?
How would you go about verifying the network name that the local_listener is currently using?
How to create a table in a specific tablespace?
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
Explain the difference between a procedure and a function?
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?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is merge in oracle?
How would you extract DDL of a table without using a GUI tool?