Database Management System using LibreOffice Base · Class 10 · CBSE Information Technology (402)
When creating a relationship between two tables, what is a Foreign Key?
Practice question from Database Management System using LibreOffice Base (Class 10 · CBSE Information Technology (402)), with the correct answer and a step-by-step solution.
medium · MCQ · Q-F3D335
When creating a relationship between two tables, what is a Foreign Key?
- A.A key created using an external software tool outside LibreOffice Base.
- B.A field in one table that uniquely identifies a record in the same table.
- C.A field or set of fields in a child table that refers to the primary key of a parent table.Correct answer
- D.A backup password used to secure the database backend.
Solution
A Foreign Key establishes a link between data in two tables. It is a field in the referencing (child) table that points to the Primary Key of the referenced (parent) table.
More from Database Management System using LibreOffice Base
- Which of the following database objects is used to retrieve and display filtered data from one or more tables based on specific criteria in…
- What is the primary purpose of a Primary Key in a relational database table?
- Which data type in LibreOffice Base is most appropriate for storing large amounts of text, such as product descriptions or user reviews, ex…
- Explain the difference between a Form and a Report in LibreOffice Base, keeping their primary functions in mind.
Practise more Information Technology (402)
Sign up free for adaptive practice on this chapter, with instant feedback and hints on every question.
Start practising freeFree to start · No credit card needed