dbms mcq– Relational Database and Database Schema Mcq

Dbms mcq:

1. The tuples of the relations can be of ________ order.
  • Same
  • Any
  • Sorted
  • Constant

2. A domain is atomic if elements of the domain are considered to be ____________ units.
  • Indivisbile
  • Different
  • Divisible
  • Constant

3. 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.
  • Tuple of distinct
  • Attributes of distinct
  • Tuple of common
  •  Attributes of common

4. Course(course_id,sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________
  • Tuple, Relation
  • Tuple, Attributes
  • Attributes, Relation
  • Relations, Attribute

5. 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.
  • Relation, Domain
  • Schema, Instance
  • Relation, Schema
  • Instance, Schema

6. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
  • Domain
  • Relation
  • Schema
  • Set

7. The term attribute refers to a ___________ of a table.
  • Column
  • Tuple
  • Relation
  • Key

8.  The term _______ is used to refer to a row.
  • Tuple
  • Instance
  • Attribute
  • Field

9. A ________ in a table represents a relationship among a set of values.
  • Row
  • Tables
  • Entry
  • Key

10. A relational database consists of a collection of?
  • Fields
  • Tables
  • Keys
  • Records

Dbms tutorials                      

Post a comment

0 Comments