An attribute that can be calculated from related attribute values is called a(n) ________ attribute.
A) simple
B) composite
C) multivalued
D) derived
Q. 2A primary key that consists of more than one attribute is called a:
A) foreign key.
B) composite key.
C) multivalued key.
D) cardinal key.
Q. 3In the figure below, which attribute is derived?
A) Years_Employed
B) Employee_ID
C) Skill
D) Address
Q. 4The SDLC phase in which database processing programs are created is the ________ phase.
A) planning
B) design
C) analysis
D) implementation
Q. 5An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:
A) link attribute.
B) link key.
C) foreign key.
D) foreign attribute.
Q. 6In the figure below, which attribute is multivalued?
A) Years_Employed
B) Employee_ID
C) Skill
D) Address
Q. 7The SDLC phase in which every data attribute is defined, every category of data is listed and every business relationship between data entities is defined is called the ________ phase.
A) planning
B) design
C) analysis
D) implementation
Q. 8An attribute (or attributes) that uniquely identifies each row in a relation is called a:
A) column.
B) foreign field.
C) primary key.
D) duplicate key.
Quick Reply
