problem 1: describe the Concept of Conventional File Processing with and illustration in detail. Illustrate the pros and cons of it.
problem 2: Illustrate the differences between Sequential; Indexed Sequential and direct access File organization.
problem 3: What are the tools of Oracle? Compare and Contrast SQL and PL/SQL. As well describe the given DDL commands.
a) CREATE FROM
b) DROP TABLE
c) ALTER TABLE
problem 4: How do you map the Conceptual Data Model into Relational Data Model?
problem 5: What do you mean by recovery? What are the different remedies taken for recovering the database? Describe.
problem 6: What are the Costs and advantages for developing and implementing a database?
problem 7: Illustrate the terms File, Field, Record, Primary Key and Secondary Key in brief with an illustration.
problem 8: Describe One-to-Many recursive association and Many-to-Many recursive associations.
problem 9: What do you mean by Tree data structure? Describe the logic for the construction of the B-Tree.
problem 10: Describe Hierarchical Data Model with a neat block diagram.
problem 11: Describe UNIOUN and MINUS commands of interactive SQL with an illustration.