1. (TCO E) Which of the following can only interact with relational database and table-like data structures? (Points : 5)
ODBC
ASP
ADO
All of the above
Question 2. 2. (TCO E) The characteristics of an object are called _____. (Points : 5) |
classes collections methods properties procedures |
Question 3. 3. (TCO G) What type of JDBC driver is known as a JDBC-ODBC bridge? (Points : 5) |
Type J-O driver Type 1 driver Type 2 driver Type 3 driver Type 4 driver |
Question 4. 4. (TCO G) PHP can be used to access the following database systems. (Points : 5) |
A. Oracle B. MSSQL C. Access A and B A, B, and C |
Question 5. 5. (TCO F) When changing the minimum cardinality on the parent side of the relationship from zero to one, the foreign key _____. (Points : 5) |
must be changed from NULL to NOT NULL must be changed from NOT NULL to NULL must be changed to a composite key must be changed to a surrogate key does not change |
Question 6. 6. (TCO F) Match the following SQL key words with their definitions. (Points : 15) |
Potential Matches: | 1 : Used to define an alternate key x = b- | 2 : Used to name a new table and describe the table's columns- | 3 : Used to limit column values to specific values- | 4 : Used in conjunction with the SQL key words PRIMARY KEY and FOREIGN KEY- |
Answer | : CREATE | : CONSTRAINT | : UNIQUE | : CHECK |
|
Question 7. 7. (TCO F) What is reverse engineering and how well does it work? (Points : 20) |