wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Database Concepts

Total questions: 15

Worksheet time: 8mins

Name
Class
Date
1.

The number of rows in a relation

a)

degree

b)

tuple

c)

cardinality

d)

domain

2.

SQL stands for

(a)  

3.

Data about data is ______________

a)

Data Description

b)

Metadata

c)

Data redundancy

d)

Data inconsistency

4.

Repetition of data is called data ..............

a)

dependance

b)

redundancy

c)

inconsistency

d)

isolation

5.

Mismatched redundant copies of data is known as data ............

a)

dependance

b)

redundancy

c)

inconsistency

d)

isolation

6.

A ............ is an organized collection of structured data.

a)

information

b)

file

c)

database

d)

DBMS

7.

A database ............... is a sketch of design of a planned data.

a)

instance

b)

schema

c)

metadata

d)

relation

8.

A data ................ is a set of rules that define valid data.

a)

constraint

b)

data dictionary

c)

query

d)

all of these

9.

A relational database consists of a collection of ..............

a)

tables

b)

fields

c)

records

d)

keys

10.

Data redundancy may lead to data inconsistency.

a)

True

b)

False

11.

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

a)

Cardinality

b)

Degree

c)

Attribute

d)

Entity

12.

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

a)

Tuple

b)

Entity

c)

Degree

d)

Cardinality

13.
A row in a database.
a)
Record
b)
Field
c)
Entity
d)
Table
14.
What language does the Relational Model use?
a)
Java
b)
Python
c)
SQL
d)
C++
15.
RDBMS
a)
Relational Database Basic Management System
b)
Relational Database Management System
c)
Required Database Management Setup
d)
None of these