ADVERTISEMENT
ADVERTISEMENT

DBMS Relational Model Concepts Multiple-Choice Questions (MCQs)

DBMS Relational Model Concepts MCQs: This section contains DBMS Relational Model Concepts Multiple-Choice Questions (MCQs) and Answers.
Submitted by Anushree Goswami, on February 19, 2022

1. Tables with rows and columns can be viewed as ___.

  1. Analytical Models
  2. Relational Models
  3. Composite Models
  4. Database Models

Answer: B) Relational Models

Explanation:

Tables with rows and columns can be viewed as relational models.

Discuss this Question


2. What is a row in a table also known as?

  1. Tuple
  2. Name
  3. Attribute
  4. None

Answer: A) Tuple

Explanation:

Row in a table is also known as Tuple.

Discuss this Question


3. What column in a table is contained?

  1. Tuple
  2. Name
  3. Attribute
  4. Both B. and D.

Answer: D) Both B. and D.

Explanation:

Column in a table contains Name or Attribute.

Discuss this Question


4. In ___, there are a set of possible atomic values that apply to an attribute.

  1. Attribute
  2. Instance
  3. Domain
  4. Schema

Answer: C) Domain

Explanation:

In Domain, there are a set of possible atomic values that apply to an attribute.

Discuss this Question


5. In ___, columns in a particular table are listed by their names.

  1. Domain
  2. Attribute
  3. Instance
  4. Schema

Answer: B) Attribute

Explanation:

In Attribute, columns in a particular table are listed by their names.

Discuss this Question


6. ___ should be there in each attribute.

  1. Keys
  2. Schema
  3. Instance
  4. Domain

Answer: D) Domain

Explanation:

Domain should be there in each attribute.

Discuss this Question


7. What is TRUE about Relational Instance?

  1. Relational database systems store data in tuples, which represent a relational instance.
  2. There are no duplicate tuples in relation instances.
  3. Both A. and B.
  4. None of the above

Answer: C) Both A. and B.

Explanation:

In case of Relational Instance -

  1. Relational database systems store data in tuples, which represent a relational instance.
  2. There are no duplicate tuples in relation instances.

Discuss this Question


8. The ___ indicates the name of each relationship and all of its columns and attributes.

  1. Relational Instance
  2. Relational Keys
  3. Relational Schema
  4. Relational Database

Answer: C) Relational Schema

Explanation:

The relational schema indicates the name of each relationship and all of its columns and attributes.

Discuss this Question


9. What is TRUE about Relational Keys?

  1. There are one or more attributes in each row of the relational key.
  2. A unique ID can be assigned to each row in the relation.
  3. Both A. and B.
  4. None of the above

Answer: C) Both A. and B.

Explanation:

In case of Relational Keys -

  1. There are one or more attributes in each row of the relational key.
  2. A unique ID can be assigned to each row in the relation.

Discuss this Question


10. How many properties of relations are there?

  1. 4
  2. 5
  3. 6
  4. 7

Answer: C) 6

Explanation:

There are 6 properties of relations.

  • = is reflexive (2=2)
  • = is symmetric (x=2 implies 2=x)
  • < is transitive (2<3 and 3<5 implies 2<5)
  • < is irreflexive (2<3 implies 2≠3)
  • ≤ is antisymmetric (xy and yx implies x=y)

Discuss this Question


11. Which of the following is/are the property/properties of the relations?

  1. Unlike all other relations, the relation has a unique name.
  2. An atomic (single) value resides in each relation cell
  3. There are distinct names for each attribute
  4. All of the above

Answer: D) All of the above

Explanation:

The following are the properties of the relations -

  1. Unlike all other relations, the relation has a unique name.
  2. An atomic (single) value resides in each relation cell.
  3. There are distinct names for each attribute.

Discuss this Question


12. Which of the following is FALSE about the properties of relations?

  1. There is no significance to attribute domains
  2. Duplicate values are present in the tuple
  3. Tuples can be ordered in any order
  4. None of the above

Answer: B) Duplicate values are present in the tuple

Explanation:

Duplicate values are not present in the tuple.

Discuss this Question



ADVERTISEMENT
ADVERTISEMENT


Comments and Discussions!



ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.