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)
|
Leave a Reply
Want to join the discussion?Feel free to contribute!