material view and view disadvantages?
Explain the role of metadata for the three-layer architecture.
what is storage manager?
What is compound key?
Describe why operational and informational systems are separate.
What are the steps to follow when preparing to create a table?
what are the advantages of using them.
Describe the difference between embedded and dynamic sql.
Briefly describe an outer join.
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?