Questions from Database Systems


Q: The Google search engine provides a feature whereby web sites can display

The Google search engine provides a feature whereby web sites can display advertisements supplied by Google. The advertisements supplied are based on the contents of the page. Suggest how Google might...

See Answer

Q: Show that, in SQL, <> all is identical to not

Show that, in SQL, all is identical to not in.

See Answer

Q: What is the motivation for splitting a long transaction into a series

What is the motivation for splitting a long transaction into a series of small ones? What problems could arise as a result, and how can these problems be averted?

See Answer

Q: Suppose the price of memory falls by half, and the speed

Suppose the price of memory falls by half, and the speed of disk access (number of accesses per second) doubles, while all other factors remain the same. What would be the effect of this change on the...

See Answer

Q: List at least four features of the TPC benchmarks that help make

List at least four features of the TPC benchmarks that help make them realistic and dependable measures.

See Answer

Q: Why was the TPC-D benchmark replaced by the TPC-

Why was the TPC-D benchmark replaced by the TPC-H and TPC-R bench- marks?

See Answer

Q: Explain what application characteristics would help you decide which of TPC-

Explain what application characteristics would help you decide which of TPC- C, TPC-H, or TPC-R best models the application.

See Answer

Q: Given that the LDAP functionality can be implemented on top of a

Given that the LDAP functionality can be implemented on top of a database system, what is the need for the LDAP standard?

See Answer

Q: In what order are block chain transactions serialized?

In what order are block chain transactions serialized?

See Answer

Q: Since block chains are immutable, how is a transaction abort implemented

Since block chains are immutable, how is a transaction abort implemented so as not to violate immutability?

See Answer