wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

DBMS ER Model

Total questions: 77

Worksheet time: 46mins

Name
Class
Date
1.

An entity is a

a)

object of relation

b)

present working model

c)

thing in real world

d)

model of relation

2.

Which of the following is not a component of ER Model in DBMS?

a)

entity

b)

database

c)

attribute

d)

relationship

3.

A relationship is

a)

an item in an application

b)

a meaningful dependency between entities

c)

a collection of related entities

d)

a related data

4.

The expansion of ER Diagram is

a)

Entity Relationship diagram

b)

Entity Relative diagram

c)

Entity Relation diagram

d)

Entity Rationalized diagram

5.

Entity is represented as

a)

ellipse

b)

double ellipse

c)

rectangle

d)

double rectangle

6.

In one to many relationship, the entity that is on the one side of relationship is called

a)

subtype

b)

child

c)

instance

d)

parent

7.

Property that describes the characteristics of entity is

a)

entities

b)

relationship

c)

attributes

d)

identifiers

8.

Entities can be associated with one another in which of the following

a)

attribute

b)

identifiers

c)

entities

d)

relationship

9.

By relation cardinality we mean

a)

number of items in a relationship

b)

number of relationships in which an entity can appear

c)

number of items in an entity

d)

number of entity sets which may be related to a given entity

10.

If an entity appears in N relationship then it is

a)

a 1:1 relationship

b)

a 1:N relationship

c)

a N:1 relationship

d)

a N:M relationship

11.

Rows of a relation is called

a)

a relation row

b)

an entity

c)

a data structure

d)

tuples

12.

The columns of a relation

a)

must be in specified order

b)

may be in any order

c)

with key field in first column

d)

with largest width column last

13.

Attributes are

a)

properties of relationship

b)

attributed to entities

c)

properties of members of an entity set

14.

In ER diagram relationships is represented by

a)

circles

b)

rectangles

c)

ellipse

d)

diamond shaped box

15.

One entity may be

a)

related to only one other entity

b)

related to itself

c)

related to only two other entities

d)

related to many other entities

16.

The function that an entity plays in a relationship is called that entity’s _____________

a)

Participation

b)

Position

c)

Role

d)

Instance

17.

The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is

a)

Single valued

b)

Multi valued

c)

Composite

d)

Derived

18.

The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called

a)

Simple attribute

b)

Composite attribute

c)

Multivalued attribute

d)

Derived attribute

19.

An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as

a)

One-to-many

b)

One-to-one

c)

Many-to-many

d)

Many-to-one

20.

Which one of the following uniquely identifies the elements in the relation?

a)

Secondary Key

b)

Primary key

c)

Foreign key

d)

Composite key

21.

Which of the following symbols represent relationship sets in an ER diagram

a)

Divided rectangles

b)

Diamonds

c)

Lines

d)

Undivided rectangles

22.

What do double line represent in an ER diagram

a)

They link entity sets to relationship sets

b)

Total participation of an entity in a relationship set

c)

Relationship sets linked to weak entity sets

d)

None of the mentioned

23.

How are roles specified in an ER diagram

a)

By labelling the rectangles

b)

By labelling the diamonds

c)

Roles cannot be specified in an ER diagram

d)

By labelling the lines

24.

ER Modelling Technique is a

a)

Top-down technique

b)

Bottom-Up Technique

c)

Left to Right

d)

None of the above

25.

An ________ is a set of entities of the same type that share the same properties, or attributes.

a)

Entity set

b)

Attribute set

c)

Relation set

d)

Entity model

26.

Which of the following is incorrect regarding levels of abstraction in database?

a)

Physical level describes how to store a record and not the relationship among the data.

b)

Logical level describes what data to stored in database and the relationship among the data.

c)

View level hides the details of data types

d)

Physical level describes what data to stored in the database.

27.

Which of the following is true about data independence?

It is the ability:

a)

To modify schema definition in one level without affecting schema definition in the next lower level.

b)

To modify schema definition in one level without affecting schema definition in the next higher level.

c)

To modify the data at one level without affecting the data in the next lower level

d)

To modify the data at one level without affecting the data in the next higher level.

28.

3. Identify the following the correct way/s to delete all rows at a time from salary table.

a)

DELETE * FROM salary;

b)

TRUNCATE TABLE salary;

c)

DELETE FROM SALARY;

d)

TRUNCATE TABLE FROM salary;

29.

The actual content in the database at a particular point.

a)

Schema

b)

Attribute

c)

Parameter

d)

Instance

30.

A characteristic of an entity.

a)

Relation

b)

Attribute

c)

Parameter

d)

Constraint

31.

ODBC Stands for

a)

Object Database connectivity

b)

Oral Database connectivity

c)

Oracle Database connectivity

d)

Open Database connectivity

32.

The Database schema is written in

a)

DCL

b)

DDL

c)

DML

d)

TCL

33.

In ER model Relationship is represented by

a)

Rectangle

b)

Ellipse

c)

Rhombus

d)

Triangle

34.

An advantage of DBMS is

a)

Data is dependent on programs

b)

Data redundancy is increases

c)

Data is integrated and can be accessed by multiple programs.

d)

None of these.

35.

The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called

a)

composite

b)

structured

c)

multi valued

d)

derived

36.

check the incorrect option

a)

ER is an conceptual Data model

b)

DBMS avoids Data redundancy

c)

we cannot create a table without a primary key

d)

An attribute of an entity can have more than one value

37.

The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is



(a)  

38.

for the following two entities which one is the correct option CUTOMER/ORDER

a)

one to one

b)

one to many

c)

many to one

39.

For the following two entities which is the correct option RULER/COUNTRY

a)

one to many

b)

one to one

c)

many to one

40.

Record in a database is

a)

can have information about a person

b)

Known as row

c)

group of related record

d)

Known as column

41.

for the following two entities which is appropriate relationship Zoo/Animal

a)

one to one

b)

one to many

c)

many to one

42.

Entity-relationship diagrams is

a)

a tool that graphically shows the collections of entities in a system

b)

a tool that graphically shows the connections among entities in a system

43.

Identify the primary key from the following

a)

name

b)

mark

c)

telephone number

d)

Gender

44.

can a primary key be null

a)

yes

b)

no

45.

A recursive relationship is a relationship between an entity and ___________.

a)

itself

b)

a subtype entity

c)

an archetype entity

d)

an instance entity

46.

Properties that describe the characteristics of entities are called:

a)

entities

b)

attributes

c)

identifiers

d)

relationships

47.

Entities can be associated with one another in which of the following?

a)

entities

b)

attributes

c)

identifiers

d)

relationships

48.

The function that an entity plays in a relationship is called that entity’s _________.

a)

Participation

b)

Position

c)

Role

d)

Instance

49.

The attribute name could be structured as an attribute consisting of first name, middle name and last name. This type of attribute is called :

a)

Simple attribute

b)

Composite attribute

c)

Multi-valued attribute

d)

Derived attribute

50.

In a relation between the entities the type and condition of the relation should be specified. That is called as ______ attribute.

a)

Descriptive

b)

Derived

c)

Recursive

d)

Relative

51.

The relationship between a weak entity set is called as the:

a)

Weak relationship

b)

Identifying relationship

c)

Connecting relationship

d)

Associative relationship

52.

The complement of Generalization is:

a)

Specialization

b)

Relation

c)

Distribution

d)

Normalization

53.

The need of EER diagram arise depending upon the:

a)

Nature of problem

b)

Nature of entities

c)

Preferences of the database designer

d)

All of these

54.

The process of minimizing the differences between entities by identifying their common characteristics is known as:

a)

Specialization

b)

Generalization

c)

Multiplicity

d)

Normalization

55.

_______ is a bottom up process.

a)

Specialization

b)

Generalization

c)

Association

d)

Aggregation

56.

The minimum and maximum values of connectivity is called the __________ of the relationship.

a)

cardinality

b)

degree

c)

modality

d)

tuple

57.

The data stored in database at a particular moment of time is called ________ of database.

a)

Instance

b)

Schema

c)

E-R Diagram

d)

Relation

58.

Based on the figure above, identify the number of tuples that will be returned by the following relational algebra query :  σ \sigma\  Type = 'Saving' (Account)

a)

2

b)

3

c)

6

d)

0

59.

Choose the CORRECT symbol of SELECT in the Relational Algebra

a)

x

b)

π\pi

c)

∩\cap

d)

σ\sigma

60.

Choose the CORRECT symbol of SELECT in the Relational Algebra

a)

x

b)

π\pi

c)

∩\cap

d)

σ\sigma

61.

Identify the CORRECT output for table (Student Difference Lecturer) or (Student - Lecturer) in table above

a)
b)
c)
d)
62.

Write the CORRECT relational algebra expression base on the figure above

a)

π\pi managerID, managerName ( σ\sigma workExprience = 5) (MANAGER)

b)

σ\sigma managerID, managerName ( π\pi workExprience = 5) (MANAGER)

c)

\sigma managerID, managerName ( \pi workExprience > 5) (MANAGER)

d)

\pi managerID, managerName ( \sigma workExprience > 5) (MANAGER)

63.

Write the relational algebra to list student's number and student'a name whose age is 20 years old or state in Terengganu.

a)

π\pi StudentID, Name ( σ\sigma Age=20 AND State = "Terengganu" (STUDENT)

b)

\pi StudentID, Name ( \sigma Age=20 OR State = "Terengganu" (STUDENT)

c)

σ\sigma StudentID, Name ( π\pi Age=20 AND State = "Terengganu" (STUDENT)

d)

\sigma StudentID, Name ( \pi Age=20 OR State = "Terengganu" (STUDENT)

64.

Base on the table given, identify output that will be produced when, σ Salary > 3000 ˅ City = ‘Batu Pahat’ (WORKER).

a)
b)
c)
d)
65.

Base on the table given, identify output that will be produced when, σ Salary > 3000 ˅ City = ‘Batu Pahat’ (WORKER).

a)
b)
c)
d)
66.

Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.

a)

Relational

b)

Structural

c)

Procedural

d)

Fundamental

67.

Is equivalent to

a)
b)
c)
d)
68.

Which of the following are relational algebra operators?

a)
b)
c)
d)
e)
69.

Which of the following are relational algebra operators?

a)
b)
c)
d)
e)
70.

In the results of what Join types are NULL values possible?

a)

Natural Join

b)

Theta join

c)

Left/Right Outer Join

d)

Full Outer Join

71.

What are some of the extensions suggested to the relational algebra language?

a)

Generalized projection

b)

Generalized selection

c)

Aggregation

d)

Union

e)

Sorting

72.

In relational data model, the total number of rows can be identified as ______________________ .

a)

Cardinality

b)

Degree

c)

Attribute

d)

Entity

73.

Identify the total number of attributes in a relational data model.

a)

Tuple

b)

Entity

c)

Degree

d)

Cardinality

74.

In relational data model, the total number of attributes can be identified as ______________________ .

a)

Cardinality

b)

Degree

c)

Tuple

d)

Entity

75.

If related data exists in more than one table, they can be joined by using the Primary Key link to the same key in the other table. Identify this key.

a)

Foreign Key

b)

Primary Key

c)

Candidate Key

d)

Composite Key

76.

For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigma.

a)

Predicates, relation

b)

Relation, Predicates

c)

Operation, Predicates

d)

Relation, Operation

77.

The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.

a)

Union

b)

Set-difference

c)

Difference

d)

Intersection

Similar Resources on Wayground

SAP MDG_90

80 questions

SAP MDG_90

quiz

Worksheet

•

Professional Development

LS Retail

80 questions

LS Retail

quiz

Worksheet

•

Professional Development

Dynamics BC 365 - Application & Supply Chain

80 questions

Dynamics BC 365 - Application & Supply Chain

quiz

Worksheet

•

Professional Development