The Database Environment – True or False
1. All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by…
The Database Environment – General Questions
1. A data warehouse uses: A. partial operational data. B. historical operational data. C. future operational data. D.…
JDBC, Java Server Pages, and MySQL – True or False
1. MySQL is just as powerful as Oracle and is half the price. A. True B. False 2.…
JDBC, Java Server Pages, and MySQL – General Questions
1. How many JDBC driver types does Sun define? A. One B. Two C. Three D. Four 2.…
ODBC, OLE DB, ADO, and ASP – True or False
1. A file data source is one that is local to a single computer. A. True B. False…
ODBC, OLE DB, ADO, and ASP – General Questions
1. ODBC minimum SQL grammar contains which of the following? A. INSERT, UPDATE, DELETE only B. Stored Procedures…
Database Redesign – True or False
1. A correlated subquery is processed as a nested subquery. A. True B. False 2. A regular subquery…
Database Redesign – General Questions
1. Which of the following SQL statements are helpful in database redesign? A. Correlated subqueries only B. EXISTS/NOT…
Data Models into Database Designs – True or False
1. A foreign key is used to implement relationships between tables. A. True B. False 2. The terms…
Database Design Using Normalization – True or False
1. When building a database from an existing set of tables, we may safely assume that referential integrity…