Questions from Database Systems


Q: Explain how multiple operations can be executed on a stream using a

Explain how multiple operations can be executed on a stream using a publish subscribe system such as Apache Kafka.

See Answer

Q: Why is column-oriented storage potentially advantageous in a database system

Why is column-oriented storage potentially advantageous in a database system that supports a data warehouse?

See Answer

Q: Consider each of the takes and teaches relations as a fact table

Consider each of the takes and teaches relations as a fact table; they do not have an explicit measure attribute, but assume each table has a measure attribute rig count whose value is always 1. What...

See Answer

Q: Consider the star schema from Figure 11.2. Suppose an

Consider the star schema from Figure 11.2. Suppose an analyst finds that monthly total sales (sum of the price values of all sales tuples) have decreased, instead of growing, from April 2018 to May 201...

See Answer

Q: Construct a schema diagram for the bank database of Figure 2.

Construct a schema diagram for the bank database of Figure 2.18.

See Answer

Q: Suppose half of all the transactions in a clothes shop purchase jeans

Suppose half of all the transactions in a clothes shop purchase jeans, and one- third of all transactions in the shop purchase T-shirts. Suppose also that half of the transactions that purchase jeans...

See Answer

Q: The organization of parts, chapters, sections, and subsections in

The organization of parts, chapters, sections, and subsections in a book is related to clustering. Explain why, and to what form of clustering.

See Answer

Q: Suggest how predictive mining techniques can be used by a sports team

Suggest how predictive mining techniques can be used by a sports team, using your favorite sport as an example.

See Answer

Q: Given two relations r(A, B, valid time)

Given two relations r(A, B, valid time) and s(B, C, valid time), where valid time de- notes the valid time interval, write an SQL query to compute the temporal Nat intervals overlap and the ∗ operator...

See Answer

Q: List the physical storage media available on the computers you use routinely

List the physical storage media available on the computers you use routinely. Give the speed with which data can be accessed on each medium.

See Answer