Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Database Management System Class 10 Quiz

Total questions: 76

Worksheet time: 38mins

Name
Class
Date
1.

Databases are being used to _.

a)

Store

b)

Manipulate

c)

Manage

d)

All of the above

2.

In Database which type of data we can store.

a)

All of the above

b)

Text

c)

Image

d)

Audio and Video

3.

Data is a collection of _.

a)

Table

b)

Database

c)

Raw facts

d)

None of the above

4.

The facts may be related to __.

a)

All of the above

b)

Place

c)

Any person

d)

Activity or things

5.

Data can be processed in the proper way to generate meaningful __.

a)

None of the above

b)

Data

c)

Information

d)

Database

6.

Which of the following is known as an organized form of data.

a)

Data

b)

None of the above

c)

Database

d)

Information

7.

A _ is a collection of logically related data items stored in an organized manner.

a)

Data

b)

Database

c)

Information

d)

None of the above

8.

Which of the following software is used to retrieve, update and create data in a database.

a)

Database Management System (DBMS)

b)

Data Manager (DM)

c)

Database Manager (DM)

d)

None of the above

9.

Which of the following is a common example of DBMS.

a)

All of the above

b)

Oracle or MySQL

c)

OpenOffice or LibreOffice Base

d)

MS Access

10.

The data in the database is stored in an __.

a)

None of the above

b)

Both a) and b)

c)

Tabular method

d)

Organized manner

11.

A __ helps to analyze the data based on certain criteria.

a)

Database

b)

None of the above

c)

Digital Document

d)

Impress

12.

What do you mean by Data Redundancy?

a)

Same data will not be repeated in several tables

b)

It can create same data multiple times

c)

Data can be shared to multiple users

d)

None of the above

13.

What do you mean by Data consistency?

a)

Reliability of the data

b)

Accuracy of the data

c)

Uniformity of the data

d)

All of the above

14.

Database helps to maintain the same data across all the tables, this is known as _.

a)

Data Consistency

b)

Data Redundancy

c)

Data Sharing

d)

None of the above

15.

Data redundancy and inconsistency can be minimized in a database which helps to increase.

a)

Accuracy

b)

None of the above

c)

Security

d)

Validity

16.

The data is translated in such a manner in a database that unauthorized users are not able to read is known as _.

a)

Consistency

b)

None of the above

c)

Validity

d)

Encryption

17.

The structure of the database is known as _.

a)

Data

b)

Data Base

c)

Data Model

d)

None of the above

18.

Which of the following data models is used in the database.

a)

Hierarchical data model

b)

Relational data model

c)

All of the above

d)

Network data model

19.

In which data model the data is organized into a tree-like structure.

a)

Network data model

b)

All of the above

c)

Hierarchical data model

d)

Relational data model

20.

In which of the following data models are used to link multiple records to the master file.

a)

Network data model

b)

Hierarchical data model

c)

All of the above

d)

Relational data model

21.

In which data model is based on the principle of setting relationships between two or more tables of the same database.

a)

Relational data model

b)

All of the above

c)

Hierarchical data model

d)

Network data model

22.

Which of the following is the most commonly used database model in DBMS.

a)

Hierarchical data model

b)

All of the above

c)

Network data model

d)

Relational data model

23.

The relational database model was proposed in __.

a)

1970

b)

1980

c)

1990

d)

2000

24.

The relational database model is proposed by __.

a)

E. F. Codd

b)

John von Neumann

c)

Linus Torvalds

d)

M. K. Rose

25.

In relational data models the data are stored in different tables made up of __.

a)

None of the above

b)

Both a) and b)

c)

Rows

d)

Columns

26.

In which data model the relations are set between tables based on common fields.

a)

All of the above

b)

Relational data model

c)

Network data model

d)

Hierarchical data model

27.

Which of the following is a real world object which stores the information in a database.

a)

Entity

b)

All of the above

c)

Attribute

d)

Field

28.

The details associated with the entity are called __.

a)

Attribute

b)

Entity

c)

Field

d)

All of the above

29.

A __ is a collection of logically related records.

a)

Field

b)

Table

c)

Entity

d)

Attribute

30.

A _ is the smallest entity in the database.

a)

Attribute

b)

Field

c)

Record

d)

Database

31.

A collection of fields in the table make a _.

a)

Attribute

b)

Field

c)

Record

d)

Database

32.

A collection of records makes a _.

a)

Attribute

b)

Field

c)

Record

d)

Table

33.

A collection of tables make a __.

a)

Record

b)

Field

c)

Database

d)

Attribute

34.

_ hold the data values of one type of data.

a)

Database

b)

Attribute

c)

Field

d)

Record

35.

The raw data represented in the form of alphanumeric, character or numeric data is known as _.

a)

Attribute

b)

Record

c)

Data value

d)

Field

36.

A __ is the set of data values for all the fields related to a person or object.

a)

Attribute

b)

Database

c)

Field

d)

Record

37.

A __ holds the data values of all the fields for a single person or object in a table.

a)

Attribute

b)

Field

c)

Record

d)

Database

38.

A _ key is a field that uniquely identifies a row in a table.

a)

Primary key

b)

Candidate key

c)

Foreign key

d)

None of the above

39.

In a table if more than one field identifies a record, it is known as _.

a)

Composite key

b)

Foreign key

c)

None of the above

d)

Primary key

40.

__ key helps to build a relation between two or more tables in a database.

a)

Foreign key

b)

None of the above

c)

Composite key

d)

Primary key

41.

If the field values that are eligible to be the primary key are known as _.

a)

Primary key

b)

Candidate key

c)

Foreign key

d)

None of the above

42.

In the database table if candidate keys are not chosen as the primary key are called __.

a)

Alternate key

b)

Candidate key

c)

None of the above

d)

Foreign key

43.

The __ key helps to build a relation between two tables.

a)

Foreign key

b)

None of the above

c)

Candidate key

d)

Alternate key

44.

All the field values that are eligible to be the primary key are the __.

a)

None of the above

b)

Candidate key

c)

Alternate key

d)

Foreign key

45.

Which of the following is suitable for candidate keys?

a)

Candidate key field can be left blank

b)

Candidate key field don’t have duplicate values

c)

None of the above

d)

Both a) and b)

46.

If in the database table there are two field roll numbers and admission number both are uniquely identified fields, if roll number is made as primary key then admission number will be __.

a)

Alternate key

b)

Candidate key

c)

Foreign key

d)

None of the above

47.

A structure or feature that is used to store, represent, or retrieve data is called __.

a)

Database

b)

None of the above

c)

Object

d)

Report

48.

What are the different objects present in RDBMS?

a)

Table

b)

Queries

c)

Form & Report

d)

All of the above

49.

__ is a feature of a database, which contains data from users and stored in a database table using a user-friendly manner.

a)

None of the above

b)

Queries

c)

Form

d)

Report

50.

The form consists of _.

a)

Check box

b)

All of the above

c)

Radio button & list box

d)

Text boxes & Labels

51.

The data entered through the forms is stored in _.

a)

Table

b)

None of the above

c)

Forms

d)

Queries

52.

The necessary data is extracted from the database using _.

a)

Queries

b)

None of the above

c)

Forms

d)

Table

53.

The output of a query can be displayed in the form of _.

a)

Queries

b)

Forms

c)

Report

d)

None of the above

54.

_ helps to specify while creating the tables and check only valid data will be entered in the table.

a)

None of the above

b)

Data Type

c)

Data Storage

d)

Validation

55.

__ refers to the type of data that will be stored in the particular field.

a)

None of the above

b)

Validation

c)

Data Storage

d)

Data Type

56.

The memory size of the field varies according to its __.

a)

None of the above

b)

Data Type

c)

Data Storage

d)

Validation

57.

The text data types are a combination of __.

a)

Special Characters

b)

All of the above

c)

Numbers

d)

Letters

58.

No arithmetic calculations can be performed on _ data type.

a)

Decimal Data type

b)

Text Data type

c)

Number Data type

d)

None of the above

59.

__ data type stores maximum length of the characters, data having more than 255 characters.

a)

Text (Varchar)

b)

None of the above

c)

Text(fix) (Char)

d)

Memo (Longvarchar)

60.

_ data type stores exactly the length specified, this data type uses a fixed number of characters.

a)

Text(fix) (Char)

b)

Memo (Longvarchar)

c)

Text (Varchar)

d)

None of the above

61.

__ data type allocated depends on the number of characters entered by the user.

a)

None of the above

b)

Text (Varchar)

c)

Text(fix) (Char)

d)

Memo (Longvarchar)

62.

__ data type consists of number, integer, decimal, real or double type which can perform arithmetic calculation.

a)

Binary Data type

b)

Date Data type

c)

Number Data type

d)

Text Data type

63.

_ data type is used to store decimal values in the database using a table.

a)

Number

b)

Tiny Integer

c)

BigInt

d)

Float

64.

Which data type is used to store monetary values and can store currencies of various countries.

a)

Boolean Data type

b)

None of the above

c)

Currency Data type

d)

Date Data type

65.

Which data type is used to store date and time both in the database.

a)

Timestamp

b)

Time

c)

None of the above

d)

Date

66.

Which data type is used to store date data in the database table.

a)

Date

b)

Time

c)

Timestamp

d)

None of the above

67.

Which data type is used to store time in the database table.

a)

None of the above

b)

Timestamp

c)

Time

d)

Date

68.

In which data type you can store True/False, Yes/No, or On/Off in the database table.

a)

Binary Data type

b)

Text Data type

c)

Number Data type

d)

Boolean Data type

69.

Which data type is used to store digital image, sound, video or file in the database table.

a)

Text Data type

b)

Boolean Data type

c)

Number Data type

d)

Binary Data type

70.

What is the name of a method where you can create a new database using step by step procedure.

a)

Database Wizard

b)

Database Method

c)

None of the above

d)

New Database

71.

In LibreOffice Base if you select the option “No, do not register the database” then what will happen.

a)

Database will not open

b)

Database will not share publicly

c)

Database will not store the data

d)

None of the above

72.

What method is used to create tables in LibreOffice Base?

a)

Both a) and b)

b)

Using Design View

c)

None of the above

d)

Using Table Wizard

73.

Which method is used to create a table in a flexible method.

a)

Using Table Wizard

b)

Using Design View

c)

None of the above

d)

Both a) and b)

74.

In LibreOffice Base, If you want to describe the purpose of the field, it will not be a part of the database table but it helps the user to understand the purpose of the field.

a)

Field Name

b)

Field Type

c)

Description

d)

None of the above

75.

Which of the following shortcut keys is used to save the table in the database.

a)

Alt + S

b)

Ctrl + S

c)

Shift + S

d)

None of the above

76.

The data can be arranged in the table using _.

a)

Arrangement

b)

Sorting

c)

Descending

d)

Ascending