DBMS · Relational Model interview questions

42 real DBMS · Relational Model questions from the Computer Science Fundamentals bank, as asked in Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd — free to start.

1. What is Relation?

Junior
  1. A.the candidate key chosen to uniquely identify rows, which cannot be null
  2. B.a minimal super key with no redundant attribute that still identifies tuples uniquely
  3. C.a table of rows and columns representing a set of related data in the relational model
  4. D.the number of tuples (rows) in a relation
Reveal the answer + AI explanation — free account

3. Which statement is correct?

Junior
  1. A.Relation — the set of permitted atomic values that an attribute may take
  2. B.Relation — the rule that a primary key attribute may never contain a null value
  3. C.Relation — the rule that a foreign key must match an existing primary key value or be null
  4. D.Relation — a table of rows and columns representing a set of related data in the relational model
Reveal the answer + AI explanation — free account

4. What is Tuple?

Junior
  1. A.the number of tuples (rows) in a relation
  2. B.any set of attributes that uniquely identifies each tuple in a relation
  3. C.a single row of a relation representing one record
  4. D.the set of permitted atomic values that an attribute may take
Reveal the answer + AI explanation — free account

6. Which statement is correct?

Junior
  1. A.Tuple — the number of tuples (rows) in a relation
  2. B.Tuple — the rule that a primary key attribute may never contain a null value
  3. C.Tuple — a single row of a relation representing one record
  4. D.Tuple — a key made of two or more attributes that together uniquely identify a tuple
Reveal the answer + AI explanation — free account

7. What is Attribute?

Junior
  1. A.any set of attributes that uniquely identifies each tuple in a relation
  2. B.a minimal super key with no redundant attribute that still identifies tuples uniquely
  3. C.the candidate key chosen to uniquely identify rows, which cannot be null
  4. D.a named column of a relation describing one property of its entities
Reveal the answer + AI explanation — free account

9. Which statement is correct?

Junior
  1. A.Attribute — the set of permitted atomic values that an attribute may take
  2. B.Attribute — a minimal super key with no redundant attribute that still identifies tuples uniquely
  3. C.Attribute — the number of tuples (rows) in a relation
  4. D.Attribute — a named column of a relation describing one property of its entities
Reveal the answer + AI explanation — free account

10. What is Domain?

Junior
  1. A.the rule that a primary key attribute may never contain a null value
  2. B.the set of permitted atomic values that an attribute may take
  3. C.a key made of two or more attributes that together uniquely identify a tuple
  4. D.the candidate key chosen to uniquely identify rows, which cannot be null
Reveal the answer + AI explanation — free account

12. Which statement is correct?

Junior
  1. A.Domain — any set of attributes that uniquely identifies each tuple in a relation
  2. B.Domain — a key made of two or more attributes that together uniquely identify a tuple
  3. C.Domain — the rule that a foreign key must match an existing primary key value or be null
  4. D.Domain — the set of permitted atomic values that an attribute may take
Reveal the answer + AI explanation — free account

13. What is Degree?

Junior
  1. A.a table of rows and columns representing a set of related data in the relational model
  2. B.the number of attributes (columns) in a relation
  3. C.the set of permitted atomic values that an attribute may take
  4. D.any set of attributes that uniquely identifies each tuple in a relation
Reveal the answer + AI explanation — free account

15. Which statement is correct?

Junior
  1. A.Degree — a minimal super key with no redundant attribute that still identifies tuples uniquely
  2. B.Degree — the number of attributes (columns) in a relation
  3. C.Degree — a candidate key not chosen as the primary key
  4. D.Degree — a named column of a relation describing one property of its entities
Reveal the answer + AI explanation — free account

16. What is Cardinality?

Junior
  1. A.a candidate key not chosen as the primary key
  2. B.the number of tuples (rows) in a relation
  3. C.the rule that a foreign key must match an existing primary key value or be null
  4. D.any set of attributes that uniquely identifies each tuple in a relation
Reveal the answer + AI explanation — free account

18. Which statement is correct?

Junior
  1. A.Cardinality — the set of permitted atomic values that an attribute may take
  2. B.Cardinality — the number of tuples (rows) in a relation
  3. C.Cardinality — a minimal super key with no redundant attribute that still identifies tuples uniquely
  4. D.Cardinality — the rule that a foreign key must match an existing primary key value or be null
Reveal the answer + AI explanation — free account

19. What is Super key?

Mid
  1. A.a minimal super key with no redundant attribute that still identifies tuples uniquely
  2. B.the rule that a primary key attribute may never contain a null value
  3. C.any set of attributes that uniquely identifies each tuple in a relation
  4. D.a key made of two or more attributes that together uniquely identify a tuple
Reveal the answer + AI explanation — free account

21. Which statement is correct?

Mid
  1. A.Super key — the candidate key chosen to uniquely identify rows, which cannot be null
  2. B.Super key — the rule that a primary key attribute may never contain a null value
  3. C.Super key — the number of tuples (rows) in a relation
  4. D.Super key — any set of attributes that uniquely identifies each tuple in a relation
Reveal the answer + AI explanation — free account

22. What is Candidate key?

Mid
  1. A.the number of attributes (columns) in a relation
  2. B.a minimal super key with no redundant attribute that still identifies tuples uniquely
  3. C.the rule that a primary key attribute may never contain a null value
  4. D.a single row of a relation representing one record
Reveal the answer + AI explanation — free account

24. Which statement is correct?

Mid
  1. A.Candidate key — the set of permitted atomic values that an attribute may take
  2. B.Candidate key — the number of tuples (rows) in a relation
  3. C.Candidate key — a candidate key not chosen as the primary key
  4. D.Candidate key — a minimal super key with no redundant attribute that still identifies tuples uniquely
Reveal the answer + AI explanation — free account

25. What is Primary key?

Junior
  1. A.the candidate key chosen to uniquely identify rows, which cannot be null
  2. B.the rule that a primary key attribute may never contain a null value
  3. C.the number of tuples (rows) in a relation
  4. D.a key made of two or more attributes that together uniquely identify a tuple
Reveal the answer + AI explanation — free account

27. Which statement is correct?

Junior
  1. A.Primary key — a minimal super key with no redundant attribute that still identifies tuples uniquely
  2. B.Primary key — the candidate key chosen to uniquely identify rows, which cannot be null
  3. C.Primary key — the set of permitted atomic values that an attribute may take
  4. D.Primary key — the number of tuples (rows) in a relation
Reveal the answer + AI explanation — free account

28. What is Foreign key?

Mid
  1. A.an attribute referencing the primary key of another relation to enforce a link between tables
  2. B.the number of attributes (columns) in a relation
  3. C.a table of rows and columns representing a set of related data in the relational model
  4. D.a named column of a relation describing one property of its entities
Reveal the answer + AI explanation — free account

30. Which statement is correct?

Mid
  1. A.Foreign key — the rule that a primary key attribute may never contain a null value
  2. B.Foreign key — the candidate key chosen to uniquely identify rows, which cannot be null
  3. C.Foreign key — a minimal super key with no redundant attribute that still identifies tuples uniquely
  4. D.Foreign key — an attribute referencing the primary key of another relation to enforce a link between tables
Reveal the answer + AI explanation — free account

Showing 30 of 42 DBMS · Relational Model questions — the full set, with answers, explanations and an AI tutor on every question, is inside.

Free to start

Answers, AI explanations, and a scored voice mock interview

Sign up free to check your answers with explanations, ask the AI tutor anything on any question, and take one full AI mock interview — scored like a real panel.

Practice DBMS · Relational Model free