ExamGecko
Question list
Search
Search

Question 8 - FC0-U61 discussion

Report
Export

Which of the following describes something in a database that refers to the unique identifier in the parent table?

A.
Attribute
Answers
A.
Attribute
B.
Constraint
Answers
B.
Constraint
C.
Foreign key
Answers
C.
Foreign key
D.
Schema
Answers
D.
Schema
Suggested answer: C

Explanation:

A foreign key is a column or a set of columns in a table that refers to the unique identifier (orprimary key) in another table. A foreign key establishes a relationship between two tables andensures referential integrity. For example, in a database that stores information about studentsand courses, the student table may have a column called student_id that is the primary key foreach student record. The course table may have a column called student_id that is the foreignkey that refers to the student_id in the student table.This way, the database can link eachcourse record to the corresponding student record34.Reference:= CompTIA IT Fundamentals(ITF+) Study Guide, 2nd Edition, Chapter 5: Database Fundamentals2; What is RDBMS(Relational Database Management System) - Javatpoint5; What is a Relational DatabaseManagement System?| Microsoft Azure6

asked 02/10/2024
Yohan Frachisse
28 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first