wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

DBC-IT105-Prelim Quiz

Total questions: 25

Worksheet time: 13mins

Name
Class
Date
1.

In hierarchy of database, which is the smallest unit of data, representing a binary value?

a)

Bit

b)

Byte

c)

Field

d)

Record

2.

In hierarchy of database, which is the collection of related fields, representing a single entity, such as a

customer or product?

a)

Bit

b)

Byte

c)

Field

d)

Record

3.

In the database hierarchy, which is the collection of related records?

a)

Field

b)

Record

c)

Table

d)

Database

4.

Database minimizes data redundancy to a great extent.

a)

True

b)

False

5.

Sharing of data is not possible using the database.

a)

True

b)

False

6.

Which of the following DBMS organizes data in a tree-like hierarchy with parent-child relationships?

a)

Hierarchical DBMS

b)

Network DBMS

c)

Relational DBMS (RDBMS)

d)

Object-Oriented DBMS (OODBMS)

7.

Which of the following DBMS organizes data into tables (relations) with rows (records) and columns (fields)?

a)

Hierarchical DBMS

b)

Network DBMS

c)

Relational DBMS (RDBMS)

d)

Object-Oriented DBMS (OODBMS)

8.

Which of the following DBMS stores data in various formats like key-value pairs, documents, or

graphs?

a)

Hierarchical DBMS

b)

NoSQL DBMS

c)

Cloud DBMS

d)

In-Memory DBMS

9.

Which of the following DBMS managed and hosted on cloud platforms, allowing scalable, on-demand

resources and services?

a)

Hierarchical DBMS

b)

NoSQL DBMS

c)

Cloud DBMS

d)

In-Memory DBMS

10.

In early computing, file systems were used to store and manage data.

a)

True

b)

False

11.

Databases provide a structured way to store and manage data, supporting large

volumes of data with complex relationships.

a)

True

b)

False

12.

Which functions of DBMS help store data in a structured format and provide tools to retrieve data efficiently?

a)

Data Storage and Retrieval

b)

Data Security

c)

Data Integrity

d)

Data Backup and Recovery

13.

Which functions of DBMS ensure the accuracy and consistency of data over its entire lifecycle?

a)

Data Storage and Retrieval

b)

Data Security

c)

Data Integrity

d)

Data Backup and Recovery

14.

DBMS acts as an intermediary between data and users, allowing disparate data from different applications to be managed.

a)

True

b)

False

15.

Which components of the database system interpret the requests received from end users via an application program into instructions?

a)

Query Processor

b)

Storage Manager

c)

Disk Storage

d)

Database Administrator

16.

The Relational Data Model is one of the most widely used data models for databases.

a)

True

b)

False

17.

An attribute is a single row in a table, representing a single record.

a)

True

b)

False

18.

Which of the following is the minimal set of attributes that can uniquely identify a tuple?

a)

Candidate Key

b)

Primary Key

c)

Foreign Key

d)

Alternate Key

19.

Which of the following is the unique key?

a)

Candidate Key

b)

Primary Key

c)

Foreign Key

d)

Alternate Key

20.

Which of the following is a key it acts as a primary key in one table and it acts as secondary key in another table?

a)

Candidate Key

b)

Primary Key

c)

Foreign Key

d)

Alternate Key

21.

Which of the following DBMS relationships occurs when each record in one entity is related to only one record in another entity, and vice versa?

a)

One-to-One Relationship

b)

One-to-Many Relationship

c)

Many-to-Many Relationship

d)

One-to-Single Relationship

22.

Which of the following DBMS arises when multiple records in one entity can be linked to multiple records in another entity?

a)

One-to-One Relationship

b)

One-to-Many Relationship

c)

Many-to-Many Relationship

d)

One-to-Single Relationship

23.

A domain defines the permissible values for an attribute.

a)

True

b)

False

24.

Keys are special types of attributes that uniquely identify rows or establish relationships between tables.

a)

True

b)

False

25.

Primary keys are not necessarily to be a single column; more than one column can also be a primary key for a table.

a)

True

b)

False