Questions from Database Systems

Q: What are the three basic components of the ODBC architecture?

What are the three basic components of the ODBC architecture?

Q: What steps are required to create an ODBC data source name?

What steps are required to create an ODBC data source name?

Q: What is OLE-DB used for, and how does it

What is OLE-DB used for, and how does it differ from ODBC?

Q: Explain the OLE-DB model based on its two types of

Explain the OLE-DB model based on its two types of objects.

Q: How does ADO complement OLE-DB?

How does ADO complement OLE-DB?

Q: What is ADO.NET, and what two new features make

What is ADO.NET, and what two new features make it important for application development?

Q: Explain the difference between data and information. Give some examples of

Explain the difference between data and information. Give some examples of raw data and information.

Q: What special considerations must you take into account when introducing a DBMS

What special considerations must you take into account when introducing a DBMS into an organization?

Q: Describe the DBA's responsibilities.

Describe the DBA's responsibilities.

Q: Write a query to display the SKU (stock keeping unit),

Write a query to display the SKU (stock keeping unit), description, type, base, category, and price for all products that have a PROD_BASE of water and a PROD_CATEGORY of sealer. FIGURE P7. 45 WATER-...