Logical Database Design – General Questions1. The entity integrity rule states that: A. no primary key attribute may be null. B. no primary…
Modeling Data in the Organization – True or False1. An attribute is a person, place, object, event in a user environment. A. True B. False 2.…
Modeling Data in the Organization – General Questions1. A binary relationship is which of the following? A. A relationship between two attributes B. A relationship…
The Database Environment – True or False1. All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by…
The Database Environment – General Questions1. 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 False1. MySQL is just as powerful as Oracle and is half the price. A. True B. False 2.…
JDBC, Java Server Pages, and MySQL – General Questions1. How many JDBC driver types does Sun define? A. One B. Two C. Three D. Four 2.…
ODBC, OLE DB, ADO, and ASP – General Questions1. ODBC minimum SQL grammar contains which of the following? A. INSERT, UPDATE, DELETE only B. Stored Procedures…
Managing Databases with Oracle – True or False1. Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values. A.…
Managing Databases with Oracle – General Questions1. What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?…