Questions from Database Systems


Q: a. What is an XSS attack? b. How

a. What is an XSS attack? b. How can the referrer field be used to detect some XSS attacks? XSS attacks:

See Answer

Q: What is multifactor authentication? How does it help safeguard against stolen

What is multifactor authentication? How does it help safeguard against stolen passwords?

See Answer

Q: Consider the bank database of Figure 2.18. Assume that

Consider the bank database of Figure 2.18. Assume that branch names and customer names uniquely identify branches and customers, but loans and accounts can be associated with more than one customer. a...

See Answer

Q: Give four ways in which information in web logs pertaining to the

Give four ways in which information in web logs pertaining to the web pages visited by a user can be used by the web site.

See Answer

Q: One of the characteristics of Big Data is the variety of data

One of the characteristics of Big Data is the variety of data. Explain why this characteristic has resulted in the need for languages other than SQL for processing Big Data.

See Answer

Q: Suppose your company has built a database application that runs on a

Suppose your company has built a database application that runs on a centralized database, but even with a high-end computer and appropriate indices created on the data, the system is not able to hand...

See Answer

Q: The map-reduce framework is quite useful for creating inverted indices

The map-reduce framework is quite useful for creating inverted indices on a set of documents. An inverted index stores for each word a list of all document IDs that it appears in (offsets in the docume...

See Answer

Q: Although SQL does not support functional dependency constraints, if the database

Although SQL does not support functional dependency constraints, if the database system supports constraints on materialized views, and materialized views are maintained immediately, it is possible to...

See Answer

Q: Fill in the blanks below to complete the following Apache Spark program

Fill in the blanks below to complete the following Apache Spark program which computes the number of occurrences of each word in a file. For simplicity we assume that words only occur in lowercase, and...

See Answer

Q: Suppose a stream can deliver tuples out of order with respect to

Suppose a stream can deliver tuples out of order with respect to tuple times- tamps. What extra information should the stream provide, so a stream query processing system can decide when all tuples in...

See Answer