Questions from Database Management

Q: Explain what capabilities the new temporal features added to the SQL standard

Explain what capabilities the new temporal features added to the SQL standard in SQL:2011.

Q: Describe a relational DBMS (RDBMS), its underlying data model,

Describe a relational DBMS (RDBMS), its underlying data model, its data storage structures, and how data relationships are established.

Q: What are some of the advantages and disadvantages of an SQL standard

What are some of the advantages and disadvantages of an SQL standard?

Q: Describe the components and structure of a typical SQL environment.

Describe the components and structure of a typical SQL environment.

Q: Explain the three classes of SQL commands and when they would be

Explain the three classes of SQL commands and when they would be used.

Q: Define each of the following terms: a. dynamic view

Define each of the following terms: a. dynamic view b. correlated subquery c. materialized view d. base table e. join f. equi-join g. self-join h. outer join i. virtualized table

Q: Explain why it is necessary to limit the kinds of updates performed

Explain why it is necessary to limit the kinds of updates performed on data when referencing data through a view.

Q: Determine the company’s use of intranet, extranet, or other Web

Determine the company’s use of intranet, extranet, or other Web-enabled business processes. For each type of process, determine its purpose and the database management system that is being used in con...

Q: When should we use joining and sub-query techniques?

When should we use joining and sub-query techniques?

Q: Explain the purpose of the WITH CHECK OPTION in a CREATE VIEW

Explain the purpose of the WITH CHECK OPTION in a CREATE VIEW SQL command.