Feb
28
A relational database consists of a collection of ?
A. Tables
B. Fields
C.Records
D. Keys
Category: The Relational Model
The Relational Model Mcqs
Feb
28
A _ in a table represents a relationship among a set of values?
A. Column
B. Key
C. Row
D. Entry
Feb
28
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
Feb
28
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
Feb
28
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
Feb
28
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
Feb
28
A domain is atomic if elements of the domain are considered to be?
A. Different units
B. Indivisbile units
C.Constant units
D. Divisible units
Feb
28
The tuples of the relations can be of ?
A. Any order
B. Same order
C. Sorted order
D. Constant order