Which of the following is an example of a one-to-one relationship?
Correct answer: D. Person-phone number
- A. Student-Regno
- B. Person-Automobile
- C. Mother-daughter
- D. Person-phone number
Explanation
A one-to-one relationship exists between two tables when one record in the first table corresponds to exactly one record in the second table, and vice versa. In the case of person-phone number, a single person can have one phone number (primary phone), but cannot have multiple primary phone numbers. On the other hand, a person can have multiple phone numbers (work, mobile, home etc.), but these would be stored in a separate table with a many-to-one relationship with the person table.
Report an error
The more specific you are, the faster it gets fixed. A source beats an opinion.
Prefer email? [email protected]
About Networking and Internet
Networking covers LAN, MAN, WAN and wireless networks, network topologies, transmission media, devices such as switches, routers and modems, and the OSI and TCP/IP models. Internet concepts include IP addresses, DNS, URLs, web browsers, email, protocols such as HTTP, HTTPS, FTP and SMTP, and basic network security.
Practise Networking and Internet
452 free Networking and Internet MCQs from Computer Science and IT, each with the correct answer and an explanation. Unlimited attempts, no account needed.
Discussion
Stuck on an option, or know a faster way to get there? Ask or explain it here.
No comments yet. Be the first to explain this one.
Exams that ask Computer Science and IT questions like this
Computer Science and IT is on 85 papers prepared for on TestUstad, and all of them draw the same bank, so this question is worth knowing for every one of them.
More Networking and Internet questions
Which of the following defines the nature of the relationship?
In a database, the relationship can be of which type?
What is the major advantage of fiber optic media compared to traditional metallic cable media?
Which of the following is a one-to-many relationship?
A relationship between counties and capitals is an example of which relationship?
The identifier of the entity type becomes which of the following of the relations?