mis582 Week 6 quiz latest 2017

Week 6 quiz

1.(TCO E) Which of the following is true about ODBC?

ODBC has experienced little practical success.

ODBC requires developers to have a thorough knowledge of many DBMS native libraries.

ODBC can be used to access data from spreadsheets.

ODBC has an object-oriented interface.

ODBC does not include facilities to return error messages.

Question 2.(TCO E) The characteristics of an object are called _____.

classes

collections

methods

properties

procedures

Question 3.(TCO G) Which of the following is true of JDBC?

Programs must be written in Java.

JDBC only works with open-source products.

JDBC is only available for Unix-like operating systems, such as Linux.

JDBC is actually a DBMS.

A and B

Question 4.(TCO G) Which of the following is not true of PHP?

PHP is easy to learn.

PHP is a competitor to ASP.NET.

PHP is part of the AMP architecture.

PHP is not supported in the Microsoft environment.

PHP is vendor neutral.

Question 5. (TCO F) When increasing cardinalities from 1:N to N:M, which of the following steps are included in the process? (The order the steps are listed below is not relevant.)

Create an intersection table.

Populate the intersection table.

Drop the old foreign key.

A and B

A, B, and C

Question 6.(TCO F) Match the following SQL key words with their definitions.

2

: Used to limit column values to specific values » CHECK

4

: Used in conjunction with the SQL key words PRIMARY KEY and FOREIGN KEY » CONSTRAINT

1

: Used to define an alternate key (x » b) = UNIQUE

3

: Used to name a new table and describe the table's columns » CREATE

Question 7. (TCO F) When redesigning a database that contains data, how can we check assumptions about functional dependencies?