Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Which are initial RDBMS, Hierarchical & N/w database?

April 26, 2017database Hierarchical initial RDBMS

0

10 Posted

Which are initial RDBMS, Hierarchical & N/w database?

1 Answer

0

Posted

Ans – RDBMS – R system Hierarchical – IMS N/W – DBTG 62. Difference between Oracle 6 and Oracle 7 ORACLE 7 has the following features – • Cost based optimizer • Shared SQL Area user • Multi Threaded Server • Hash Clusters • Roll back Size Adjustment • Truncate command • Database Integrity Constraints • Stored procedures, functions packages & triggers • Resource profile limit. It prevents user from running away with system resources • Distributed Database • Table replication & snapshots ORACLE 6 has the following features – • Rule based optimizer • SQL area allocated for each user • Single Threaded Server • Only B-Tree indexing • No provision for Roll back Size Adjustment • No provision for Truncate command • Provision at Application Level • No provision for Stored procedures, functions packages & triggers • No provision for Resource profile limit.