Multiple Choice
Partial dependency exists if what conditions exist?
A) a column is dependent on a portion of the table that is not identified as the primary key
B) a column is dependent only on a portion of a composite primary key
C) the data contains repeating groups
D) the table is not in first normal form (1NF)
Correct Answer:
Verified
Correct Answer:
Verified
Q14: SQL commands can be issued in Oracle
Q15: Analyzing historical data stored in a database
Q16: A(n)_ is a group of related fields.
Q17: The simplest approach to remove a partial
Q18: A(n)_ table can be added to the
Q20: If at least one value in a
Q21: In which step of the Systems Development
Q22: Data is in second normal form if
Q23: A straight line with a crow's foot
Q24: If uncontrolled,what can lead to data anomalies?<br>A)