wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

First QUIZ of Database - Edited by: Eng. Javier Daza 2023-1

Total questions: 40

Worksheet time: 20mins

Name
Class
Date
1.

Please read analytically and choose the correct answer…

………… is collection of related data and its metadata organized in a structured format

a)

Register

b)

Database Management System (DBMS)

c)

Database

d)

Database System

2.

Please read analytically and choose the correct answer…

............ that define and regulate the collection, storage, management, and use of data within a database environment

a)

Database

b)

Register - Row

c)

Database System

d)

Database Management System (DBMS)

3.

Please read analytically and choose the correct answer…

............ is a software that enables easy creation, access, and modification of databases

a)

Database

b)

Register - Row

c)

Database System

d)

Database Management System (DBMS)

4.

Please read analytically and choose the correct answer…

............ is an integrated system of hardware, software, people, procedures, and data

a)

Database

b)

Register - Row

c)

Database System

d)

Database Management System (DBMS)

5.

Please read analytically and choose the correct answer…

............ is for efficient and effective database management

a)

Database

b)

Register - Row

c)

Database System

d)

Database Management System (DBMS)

6.

Please read analytically and choose the correct answer…

............ is for optimized information management

a)

Database

b)

Register - Row

c)

Database System

d)

Database Management System (DBMS)

7.

Please read analytically and choose the correct answer…

............ manages interaction between end users and database

a)

Database

b)

Register - Row

c)

Database System

d)

Database Management System (DBMS)

8.

Please read analytically and choose the correct answer…

............Hardware, Software (OS, DBMS, Applications), People, Procedures, Data, are....

a)

Database

b)

Database System Environment

c)

Database System

d)

Database Management System (DBMS)

9.

Please read analytically and choose the correct answer…

....Optimizes data management and Transforms data into information are purposes of....

a)

Database System

b)

Database System Environment

c)

Database

d)

Database Management System (DBMS)

10.

Please read analytically and choose the correct answer…

....Avoid data redundancy & ensure data integrity are the importances of....

a)

Database System

b)

Database System Environment

c)

Database Management System (DBMS)

d)

Database Design

11.

Please read analytically and choose the correct answer…

Stores data and related data entry forms, report definitions, etc., are functions of......

a)

Database System

b)

Database System Environment

c)

Database

d)

Database Design

12.

Please read analytically and choose the correct answer…

......Planning & Analysis represents......

a)

What

b)

When

c)

Why

d)

How

13.

Please read analytically and choose the correct answer…

......is an example of a Data Models....

a)

SQL

b)

Object-Oriented

c)

MySQL

d)

Access

14.

Please read analytically and choose the correct answer…

Database: User-centered:

The user has the right to a system that performs exactly as promised, that is...

a)

Perspective

b)

Instruction

c)

Compliance

d)

Usability

15.

Please read analytically and choose the correct answer

Database: User-centered:

The user is always right. If there is a problem with the use of the system, the system is the problem, not the user, that is...

a)

Perspective

b)

Instruction

c)

Compliance

d)

Usability

16.

Please read analytically and choose the correct answer

Database: User-centered:

The user has the right to easy-to-use instructions (user guides, online or contextual help, error messages) for understanding and utilizing a system to achieve desired goals and recover efficiently and gracefully from problem situations, that is...

a)

Perspective

b)

Instruction

c)

Compliance

d)

Usability

17.

Please read analytically and choose the correct answer

Database: User-centered:

The user should be the master of software and hardware technology, not vice-versa. Products should be natural and intuitive to use, that is...

a)

Perspective

b)

Instruction

c)

Compliance

d)

Usability

18.

Please read analytically and choose the correct answer

Basic Building Blocks:

................ a characteristic of an entity

a)

Constraint

b)

Relationship

c)

Attribute

d)

Entity

19.

Please read analytically and choose the correct answer

Basic Building Blocks:

................ restrictions placed on the data

a)

Constraint

b)

Relationship

c)

Attribute

d)

Entity

20.

Please read analytically and choose the correct answer

Basic Building Blocks:

................ describes an association among entities

a)

Constraint

b)

Relationship

c)

Attribute

d)

Entity

21.

Please read analytically and choose the correct answer

Basic Building Blocks:

................ thing about which data are to be collected and stored

a)

Constraint

b)

Relationship

c)

Attribute

d)

Entity

22.

Please read analytically and choose the correct answer


Data prior to the 1950s......

a)

they were stored in magnetic tapes

b)

were stored in paper records.

c)

they were stored on hard disks

d)

They were stored in solid state memories

23.

Please read analytically and choose the correct answer


Data between 1950s and early 1960s......

a)

they were stored in magnetic tapes

b)

were stored in paper records.

c)

they were stored on hard disks

d)

they were stored in solid state memories

24.

Please read analytically and choose the correct answer


Data late 1960s and 1970s......

a)

they were stored in magnetic tapes

b)

were stored in paper records.

c)

they were stored on hard disks

d)

they were stored in solid state memories

25.

Please read analytically and choose the correct answer


File based systems are adequate for......

a)

large applications

b)

huge applications

c)

medium applications

d)

small applications

26.

Please read analytically and choose the correct answer


.......begin with a strictly defined tree of data nodes.

a)

Object - Oriented model

b)

Hierarchical model

c)

Relational model

d)

Network model

27.

Please read analytically and choose the correct answer


.......Similar to Hierarchical Model.

a)

Object - Oriented model

b)

Hierarchical model

c)

Relational model

d)

Network model

28.

Please read analytically and choose the correct answer


......unify the data and metadata in a single form of representation.

a)

Object - Oriented model

b)

Hierarchical model

c)

Relational model

d)

Network model

29.

Please read analytically and choose the correct answer


E.F. Codd introduced the relational model in....

a)

1950

b)

1960

c)

1970

d)

1980

30.

Please read analytically and choose the correct answer


…………… are large complex pieces of software designed specifically for the efficient management of data.

a)

MS DOS

b)

SQL

c)

DDL and DML

d)

DBMS

31.

Please read analytically and choose the correct answer


The ………..….. relational database language was standardized between 1982 and 1986.

a)

MS DOS

b)

SQL

c)

DDL and DML

d)

DBMS

32.

Please read analytically and choose the correct answer


The area in the red circle of the blue table represents ........

a)

a database

b)

a record (row)

c)

a table

d)

a field (column)

33.

Please read analytically and choose the correct answer


The area in the red circle of the blue table represents ........

a)

a database

b)

a record (row)

c)

a table

d)

a field (column)

34.

Please read analytically and choose the correct answer


An ................ is a business object that represents a group, or category of data.

a)

relationship

b)

record (row)

c)

entity

d)

field (column)

35.

Please read analytically and choose the correct answer


A .................................. is a link that relates two entities that share one or more attributes

a)

entity

b)

record (row)

c)

database

d)

relationship

36.

Please read analytically and choose the correct answer


In the entity-relation database model, the rhombus represents...

a)

Entity

b)

Weak Entity

c)

Attribute

d)

Relationship

37.

Please read analytically and choose the correct answer


In the entity-relation database model, the rectangle represents...

a)

Entity

b)

Weak Entity

c)

Attribute

d)

Relationship

38.

Please read analytically and choose the correct answer


In the entity-relation database model, the oval represents...

a)

Entity

b)

Weak Entity

c)

Attribute

d)

Relationship

39.

Please read analytically and choose the correct answer


In the entity-relationship database model, the double rectangle represents...

a)

Entity

b)

Weak Entity

c)

Attribute

d)

Relationship

40.

Please read analytically and choose the correct answer


Based on the entity relationship model scheme given, the primary key attribute is represented by ...

a)

Price

b)

Registration Number

c)

Model Number

d)

Color

e)

Car