Assume a query optomizer processed the command SELECT * FROM person WHERE person.age> 100 AND person.zipcode = '45638' If the optomizer discovers that the column person hasan average of 25 with a standard deviation of 5, and the zipcode column is evenly distributed, which column (zipcode or age) would have a lower filter factor (or FF)?

Illustrate how SQL can be used to create the index called CUSTOMER_INDEX, on the table with name CUSTOMERS based on the CUSTOMER_AGE (descending) and CUSTOMER_ZIPCODE (ascending) attribute types. Give the minimum of three reasons why choosing an appropriate index can be beneficial.

If a database is using the hashed join algorithm, with the hash function F(x) = 1,

the hashed join algorithm becomes what join algorithm?

Argue/explain.

Discuss the ACID properties of transaction management and the responsibility of the DBMS's transaction management system to ensure this.