Questions from Database Systems


Q: Describe and contrast the information needs at the strategic, tactical,

Describe and contrast the information needs at the strategic, tactical, and operational levels in an organization. Use examples to explain your answer.

See Answer

Q: In a SELECT query, what is the difference between a WHERE

In a SELECT query, what is the difference between a WHERE clause and a HAVING clause?

See Answer

Q: Explain why the following command would create an error, and what

Explain why the following command would create an error, and what changes could be made to fix the error. SELECT V_CODE, SUM(P_QOH) FROM PRODUCT;

See Answer

Q: Write a query to display the first name, last name,

Write a query to display the first name, last name, street, city, state, and zip code of any customer who purchased a Foresters Best brand top coat between July 15, 2015, and July 31, 2015. If a custo...

See Answer

Q: What type of integrity is enforced when a primary key is declared

What type of integrity is enforced when a primary key is declared?

See Answer

Q: Explain why it might be more appropriate to declare an attribute that

Explain why it might be more appropriate to declare an attribute that contains only digits as a character data type instead of a numeric data type.

See Answer

Q: Describe the evolution from centralized DBMSs to distributed DBMSs.

Describe the evolution from centralized DBMSs to distributed DBMSs.

See Answer

Q: List and discuss some of the factors that influenced the evolution of

List and discuss some of the factors that influenced the evolution of the DDBMS.

See Answer

Q: What are the advantages of the DDBMS?

What are the advantages of the DDBMS?

See Answer

Q: What are the disadvantages of the DDBMS?

What are the disadvantages of the DDBMS?

See Answer