Questions from Database Management

Q: What is a materialized view, and when would it be used

What is a materialized view, and when would it be used?

Q: State four rules for choosing indexes for a relational database.

State four rules for choosing indexes for a relational database.

Q: How can an SQL command be structured to allow parallel execution?

How can an SQL command be structured to allow parallel execution?

Q: Contrast the following terms: a. scalar aggregate; vector

Contrast the following terms: a. scalar aggregate; vector aggregate b. DDL; DML c. catalog; schema

Q: Explain the purpose of the CHECK clause within a CREATE TABLE SQL

Explain the purpose of the CHECK clause within a CREATE TABLE SQL command.

Q: What can be changed about a table definition using the SQL command

What can be changed about a table definition using the SQL command ALTER? Can you identify anything about a table definition that cannot be changed using the ALTER command?

Q: Talk with a database administrator or designer from the organization. What

Talk with a database administrator or designer from the organization. What type of metadata does this organization maintain about its databases? Why did the organization choose to keep track of these...

Q: Explain the difference between the WHERE and HAVING clause.

Explain the difference between the WHERE and HAVING clause.

Q: What is the purpose of the EXPLAIN or EXPLAIN PLAN command?

What is the purpose of the EXPLAIN or EXPLAIN PLAN command?

Q: What are SQL-92, SQL:1999, SQL:

What are SQL-92, SQL:1999, SQL:2011, and SQL:2016? Briefly describe how SQL:2016 differs from SQL:1999.