Questions from Database Systems

Q: List the balance characteristics of the customers who have made purchases during

List the balance characteristics of the customers who have made purchases during the current invoice cycle—that is, for the customers who appear in the INVOICE table. The results of...

Q: How is the processing of SQL DDL statements (such as CREATE

How is the processing of SQL DDL statements (such as CREATE TABLE) different from the processing required by DML statements?

Q: In simple terms, the DBMS processes queries in three phases.

In simple terms, the DBMS processes queries in three phases. What are those phases, and what is accomplished in each phase?

Q: If indexes are so important, why not index every column in

If indexes are so important, why not index every column in every table? (Include a brief discussion of the role played by data sparsity.)

Q: Describe the different types of database requests and transactions.

Describe the different types of database requests and transactions.

Q: What is the objective of the query optimization functions?

What is the objective of the query optimization functions?

Q: To which transparency feature are the query optimization functions related?

To which transparency feature are the query optimization functions related?

Q: What issues should be considered when resolving data requests in a distributed

What issues should be considered when resolving data requests in a distributed environment?

Q: What are the two basic styles of data replication?

What are the two basic styles of data replication?

Q: What trade-offs are involved in building highly distributed data environments

What trade-offs are involved in building highly distributed data environments?