[Solved] In the section relation which of the following is used as a foreign key?

Q.	In the section relation which of the following is used as a foreign key?
A.	course_id
B.	course_id,sec_id
C.	room_number
D.	course_id,sec_id,room_number
Answer» A. course_id

2.4k

Do you find this helpful?

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation
An attribute in a relation is a foreign key if the key from one relation is used as an attribute in that relation.
An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.
A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
State true or false: If a relation consists of a foreign key, then it is called a referenced relation of the foreign key dependency.
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called
A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency
State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.