What do we call a row in a database mcq

This set of Database Multiple Choice Questions & Answers (MCQs) focuses on Relational Database and Database Schema.1. A relational database consists of a collection ofa) Tables

What do we call a row in a database mcq

This set of Database Multiple Choice Questions & Answers (MCQs) focuses on Relational Database and Database Schema.

1. A relational database consists of a collection of
a) Tables
b) Fields
c) Records
d) Keys
View AnswerAnswer: a
Explanation: Fields are the column of the relation or tables. Records are each row in a relation. Keys are the constraints in a relation.advertisement

2. A ________ in a table represents a relationship among a set of values.
a) Column
b) Key
c) Row
d) Entry
View AnswerAnswer: c
Explanation: Column has only one set of values. Keys are constraints and row is one whole set of attributes. Entry is just a piece of data.

3. The term _______ is used to refer to a row.
a) Attribute
b) Tuple
c) Field
d) Instance
View AnswerAnswer: b
Explanation: Tuple is one entry of the relation with several attributes which are fields.Subscribe Now: DBMS Newsletter | Important Subjects Newsletters
advertisementadvertisement

4. The term attribute refers to a ___________ of a table.
a) Record
b) Column
c) Tuple
d) Key
View AnswerAnswer: b
Explanation: Attribute is a specific domain in the relation which has entries of all tuples.

5. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
a) Domain
b) Relation
c) Set
d) Schema
View AnswerAnswer: a
Explanation: The values of the attribute should be present in the domain. Domain is a set of values permitted.Become Top Ranker in Database Management System Now!advertisement

6. Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
a) Instance, Schema
b) Relation, Schema
c) Relation, Domain
d) Schema, Instance
View AnswerAnswer: d
Explanation: Instance is an instance of time and schema is a representation.

7. Course(course_id,sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________
a) Relations, Attribute
b) Attributes, Relation
c) Tuple, Relation
d) Tuple, Attributes
View AnswerAnswer: b
Explanation: The relation course has a set of attributes course_id,sec_id,semester .advertisement

8. Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.
a) Attributes of common
b) Tuple of common
c) Tuple of distinct
d) Attributes of distinct
View AnswerAnswer: c
Explanation: Here the relations are connected by the common attributes.

9. A domain is atomic if elements of the domain are considered to be ____________ units.
a) Different
b) Indivisbile
c) Constant
d) Divisible
View AnswerAnswer: b
Explanation: None.advertisement

10. The tuples of the relations can be of ________ order.
a) Any
b) Same
c) Sorted
d) Constant
View AnswerAnswer: a
Explanation: The values only count. The order of the tuples does not matter.

Sanfoundry Global Education & Learning Series  Database Management System.To practice all areas of Database Management System, here is complete set on 1000+ Multiple Choice Questions and Answers on Database Management System.» Next - Database Questions and Answers  KeysNext Steps:

  • Get Free Certificate of Merit in Database Management System
  • Participate in Database Management System Certification Contest
  • Become a Top Ranker in Database Management System
  • Take Database Management System Tests
  • Chapterwise Practice Tests: Chapter 1, 2, 3, 4, 5, 6, 7, 8, 9, 10
  • Chapterwise Mock Tests: Chapter 1, 2, 3, 4, 5, 6, 7, 8, 9, 10Related Posts:

  • Practice Computer Science MCQs
  • Practice RDBMS MCQ
  • Apply for Computer Science Internship
  • Apply for Information Technology Internship
  • Practice Programming MCQs

Video liên quan