What are the disadvantage in file processing system?
Explain issues for database performance.
Describe the difference between homogeneous and heterogeneous distributed database.
Describe the four types of indexes.
Explain concurrency transparency.
what are the different kinds of indexing?
What is file manager?
does pl/sql support “overloading”? Explain
what are database files, control files and log files. How many of these files should a database have at least? Why?
What is denormalization and why would someone consider doing so?
What is buffer manager?
How view is related to data independence?
How are exceptions handled in pl/sql? Give some of the internal exceptions name?
What is system catalog or catalog relation?
What are some disadvantages of a standard language such as sql?