Database Management System Question Bank - 1

Question: 1

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

(A) Union

(B) Select

(C) Projection

(D) Join

Ans: B

Select

Question: 2

In E-R diagram, relationship is represented by

(A) Diamond shaped

(B) Dashed shaped

(C) Ellipse shaped

(D) Rectangle shaped

Ans : A

Diamond shaped

Question: 3

The _____ operation allows the combining of two relations by merging pairs of tubles, one from each relation, into a single tuple.

(A) Intersection

(B) Union

(C) Join

(D) Select

Ans: C

Join

Question: 4

A _____ is an abstract model that describes how the data are organised and represented.

(A) Database

(B) Schema

(C) Instances

(D) Data model

Ans: D

Data model

Question: 5

_____ describe what is in database fields.

(A) Field names

(B) Field definitions

(C) Field markers

(D) Structures

Ans: A

Field names

Related Questions