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.