Tables in second normal form (2NF): – McqOptions

MCQOPTIONS

1.	Tables in second normal form (2NF):
A.	Eliminate all hidden dependencies
B.	Eliminate the possibility of a insertion anomalies
C.	Have a composite key
D.	Have all non key fields depend on the whole primary key
Answer» B. Eliminate the possibility of a insertion anomalies

Discussion

No Comment Found

Related MCQs

To specify the foreign keys in relations referencing temporal data we need to specify _______
Which of the following is the time of temporal data that record when a fact was recorded in a database?
State true or false: Overlapping time intervals cannot be prevented
The data that have a time interval associated with them during which they are valid are called as ________
Which of the following is not a process of generating a good relational schema?
WHICH_OF_THE_FOLLOWING_IS_THE_TIME_OF_TEMPORAL_DATA_THAT_RECORD_WHEN_A_FACT_WAS_RECORDED_IN_A_DATABASE??$
WHICH_FORMS_ARE_BASED_ON_THE_CONCEPT_OF_FUNCTIONAL_DEPENDENCY:?$
To_specify_the_foreign_keys_in_relations_referencing_temporal_data_we_need_to_specify________$
State true or false: Overlapping time intervals cannot be prevente?
Functional dependencies that have a time associated with them during which they are valid are called as________