Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Introduction To DBMS

Total questions: 40

Worksheet time: 20mins

Name
Class
Date
1.

Which language is used to request information from a Database?

a)

Relational

b)

Structural

c)

Query

d)

Compiler

2.

The ---------- diagram gives a logical structure of the database graphically?

a)

Entity - Relationshipt

b)

Entity

c)

Architectural Representation

d)

Database

3.

The ---------- diagram gives a logical structure of the database graphically?

a)

Strong entity set

b)

Weak entity set

c)

Identity set

d)

Owner set

4.

---------- Command is used to delete a database.

a)

Delete database database_name

b)

Delete database_name

c)

drop database database_name

d)

drop database_name

5.

Which type of below DBMS is MySQL?

a)

Object Oriented

b)

Hierarchical

c)

Relational

d)

Network

6.

MySQL is freely available and is open source.

a)

True

b)

False

7.

---------- represents a “tuple” in a relational database?

a)

Table

b)

Row

c)

Column

d)

Object

8.

Communication is established with MySQL using

a)

SQL

b)

Network calls

c)

Java

d)

API’s

9.

Which is the MySQL instance responsible for data processing?

a)

MySQL Client

b)

MySQL Server

c)

SQL

d)

Server Daemon Program

10.

The structure representing the organizational view of entire

database is known as -------- in MySQL database.

a)

Schema

b)

View

c)

Instance

d)

Table

11.

________ is the hierarchical database model.

a)

Information Management System

b)

Integrated Data Store

c)

Oracle

d)

DB2

12.

________ is the network database model.

a)

Information Management System

b)

Integrated Data Store

c)

Oracle

d)

DB2

13.

Identify the relational database model.

a)

Information Management System

b)

Integrated Data Store

c)

Oracle

d)

DB2

14.

Which is not a RDBMS?

a)

MySql

b)

Ms Access

c)

Oracle

d)

Ms word

15.

____ is defined as the collection of data.

a)

Table

b)

Row

c)

Column

d)

Database

16.

Each column is known as

a)

Tuple

b)

Record

c)

Relation

d)

Attribute

17.

A single entry in a table is called as

a)

Row

b)

Tuple

c)

Record

d)

All the above

18.

Which key is used for identification task _______

a)

Primary Key

b)

Candidate Key

c)

Super Key

d)

Alternate Key

19.

Non primary keys are called _________

a)

Primary Key

b)

Candidate Key

c)

Super Key

d)

Alternate Key

20.

The _____ is also known as minimal super keys

a)

Primary Key

b)

Candidate Key

c)

Super Key

d)

Alternate Key

21.

_____ is a column that creates a relationship between two tables.

a)

Primary Key

b)

Candidate Key

c)

Super Key

d)

Foreign Key

22.

A key with more than one attribute to identify rows uniquely in a table is called

a)

Primary Key

b)

Candidate Key

c)

Super Key

d)

Composite key

23.

______ also known as Compound Key

a)

Primary Key

b)

Candidate Key

c)

Super Key

d)

Composite key

24.

The basic concept of ER model consists of

a)

Entity

b)

Relationship

c)

Attributes

d)

All the above

25.

An _____ is an object or component of data.

a)

Entity

b)

Relationship

c)

Attribute

d)

Instance

26.

A ______ is the one which doesn’t depend on any other entity on the database

a)

Strong entity

b)

Weak entity

c)

Entity Instance

d)

None of the above

27.

______ are the values for the entity

a)

Strong entity

b)

Weak entity

c)

Instance

d)

None of the above

28.

An _______describes the property of an entity.

a)

Entity

b)

Relationship

c)

Attribute

d)

Instance

29.

How many types of attributes are there?

a)

2

b)

3

c)

4

d)

5

30.

Uniquely identifies each entity in the entity set is called

a)

Key attribute.

b)

Composite Attribute

c)

Multi valued attribute

d)

Derived attribute

31.

____ have atomic values, which cannot be divided further.

a)

Simple attributes

b)

Composite Attribute

c)

Multi valued attribute

d)

Derived attribute

32.

____ can be subdivided into simple attributes without change in the meaning of that attribute.

a)

Simple attributes

b)

Composite Attribute

c)

Multi valued attribute

d)

Derived attribute

33.

Contains only one value for the attribute and they don’t have multiple numbers of values?

a)

Simple attributes

b)

Composite Attribute

c)

Multi valued attribute

d)

Single Valued attribute

34.

A _____ has more than one value for that particular attribute.

a)

Simple attributes

b)

Composite Attribute

c)

Multi valued attribute

d)

Single Valued attribute

35.

•A relationship is represented by

a)

Diamond shape.

b)

Oval

c)

Circle

d)

Rectangle

36.

When a single instance of an entity is associated with a single instance of another entity then it is called

a)

One to one relationship.

b)

One-to-Many relationship

c)

Many-to-Many relationship

d)

Many to one relationship

37.

When a single instance of an entity is associated with more than one instances of another entity then it is called

a)

One to one relationship.

b)

One-to-Many relationship

c)

Many-to-Many relationship

d)

Many to one relationship

38.

Each instance of the relationship between members of these entity types is called a

a)

Entity

b)

Relationship

c)

Attribute

d)

Relationship instance

39.

The number of entity types involved is known as

a)

Relationship type

b)

Cardinality

c)

Degree of relationship

d)

None of the above

40.

The number of items that must be included in a relationship is called

a)

Relationship type

b)

Cardinality

c)

Degree of relationship

d)

None of the above