wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

ITS 200 A Pre-Mid Term Exam

Total questions: 75

Worksheet time: 1hrs 15mins

Name
Class
Date
1.

Any facts, figures, statistics and etc. that having no particular meaning.

a)

Data

b)

Record

c)

Relation

d)

Database

2.

It is a collection of related records.

a)

Data

b)

Record

c)

Relation

d)

Database

3.

It is a collection of related relation.

a)

Data

b)

Record

c)

Relation

d)

Database

4.

The following are the other terms of column in the relation, except?

a)

Fields

b)

Attribute

c)

Domains

d)

Name

5.

The following are the other terms of row in the relation, except?

a)

Tuple

b)

Records

c)

Data

d)

Database Instances

6.

It is collection of interrelated data and a set of programs to access those data.

a)

Database

b)

Database Management System

c)

Database System

d)

Management System

7.

Base on the image, can you consider that as a database?

a)

YES

b)

NO

8.

Base on the image, can you consider that as a database?

a)

YES

b)

NO

9.

The following are synonymous words in Database Management System, except?

a)

Data or Record

b)

Table or Relation

c)

Fields, Attributes or Domains

d)

Tuples or Records

10.

It is to provide a way to store and retrieve database information that is both convenient and efficient.

a)

Database Management Systems

b)

File-Processing System

c)

Relation

d)

Database

11.

It is a collection of interrelated data and a set of programs to access those data. This is a collection of related data with an implicit meaning and hence is a database.

a)

Database Management Systems

b)

File-Processing System

c)

Relation

d)

Database

12.

A kind of system that stores permanent records in various files, and it needs different application programs to extract records from.

a)

Database Management Systems

b)

File-Processing System

c)

Relation

d)

Database

13.

TRUE or FALSE.

Difficulty in accessing data because of Database Management Systems.

a)

TRUE

b)

FALSE

14.

TRUE or FALSE.

Data are scattered in various files, and files may be in different formats, writing new application programs to retrieve the appropriate data is difficult in Database Management System.

a)

TRUE

b)

FALSE

15.

TRUE or FALSE.

Data are not secured in Database Management Systems.

a)

TRUE

b)

FALSE

16.

TRUE or FALSE.

In a file-processing system, by having a centralized database and centralized control of data by the DBA the unnecessary duplication of data is avoided.

a)

TRUE

b)

FALSE

17.

TRUE or FALSE.

Database Management System eliminates the extra time for processing the large volume of data.

a)

TRUE

b)

FALSE

18.

TRUE or FALSE.

In Database Management System data are accurate.

a)

TRUE

b)

FALSE

19.

TRUE or FALSE.

In Database management system provides the interface between the application programs and the data.

a)

TRUE

b)

FALSE

20.

It is the simplest architecture of Database in which the client, server, and Database all reside on the same machine.

a)

1-Tier Architecture

b)

2-Tier Architecture

c)

3-Tier Architecture

d)

4-Tier Architecture

21.

In this architecture, the database is directly available to the user. It means the user can directly sit on the DBMS and uses it

a)

1-Tier Architecture

b)

2-Tier Architecture

c)

3-Tier Architecture

d)

4-Tier Architecture

22.

It is a Database architecture where the presentation layer runs on a client (PC, Mobile, Tablet, etc.), and data is stored on a server.

a)

1-Tier Architecture

b)

2-Tier Architecture

c)

3-Tier Architecture

d)

4-Tier Architecture

23.

It is the most popular client server architecture in DBMS in which the development and maintenance of functional processes, logic, data access, data storage, and user interface is done independently as separate modules.

a)

1-Tier Architecture

b)

2-Tier Architecture

c)

3-Tier Architecture

d)

4-Tier Architecture

24.

This architecture contains a presentation layer, an application layer, and a database server

a)

1-Tier Architecture

b)

2-Tier Architecture

c)

3-Tier Architecture

d)

4-Tier Architecture

25.

Following are the goals of 3-Tier architecture, except?

a)

To separate the user applications and physical database

b)

To support DBMS characteristics

c)

Program-data independence

d)

Supporting single view of the data

26.

TRUE or FALSE.

An Architecture of DBMS helps in design, development, implementation, and maintenance of a database.

a)

TRUE

b)

FALSE

27.

TRUE or FALSE.

The simplest database system architecture is 3 tier where the Client, Server, and Database all reside on the same machine.

a)

TRUE

b)

FALSE

28.

TRUE or FALSE.

A two-tier architecture is a database architecture in DBMS where presentation layer runs on a client and data is stored on a server.

a)

TRUE

b)

FALSE

29.

TRUE or FALSE.

Three-tier client-server architecture consists of the Presentation layer (PC, Tablet, Mobile, etc.), Application layer (server) and Database Server.

a)

TRUE

b)

FALSE

30.

It is facts, figures, statistics, etc. having no particular meaning.

a)

Record

b)

Data

c)

Data Model

d)

Record Model

31.

It is the modeling of the data description.

a)

Record

b)

Data

c)

Data Model

d)

Record Model

32.

It is the modeling of the data semantics.

a)

Record

b)

Data

c)

Data Model

d)

Record Model

33.

It provides the conceptual tools for describing the design of a database.

a)

Record

b)

Data

c)

Data Model

d)

Record Model

34.

The following are the data models, except?

a)

Relational Data Model

b)

Entity-Relationship Data Model

c)

Structured Data Model

d)

Object-Based Data Model

35.

This is a type of model that design the data in the form of relation?

a)

Relational Data Model

b)

Entity-Relationship Data Model

c)

Semistructured Data Model

d)

Object-Based Data Model

36.

This model is the logical representation of data as objects and relationships.

a)

Relational Data Model

b)

Entity-Relationship Data Model

c)

Semistructured Data Model

d)

Object-Based Data Model

37.

A type of model with notions of functions, encapsulation, and object identity.

a)

Relational Data Model

b)

Entity-Relationship Data Model

c)

Semistructured Data Model

d)

Object-Based Data Model

38.

This model allows the data specification at places.

a)

Relational Data Model

b)

Entity-Relationship Data Model

c)

Semistructured Data Model

d)

Object-Based Data Model

39.

This model is widely used in database designing.

a)

Relational Data Model

b)

Entity-Relationship Data Model

c)

Semistructured Data Model

d)

Object-Based Data Model

40.

What is another term for instance of the database?

a)

Domain

b)

Data

c)

Tuple

d)

Field

41.

Following are the same term of instance of the database, except?

a)

Record

b)

Data

c)

Tuple

d)

Rows

42.

What is the name of the data which is stored in the database?

a)

instance of the database

b)

tuple of the database

c)

record of the database

d)

row of the database

43.

It is the skeleton structure of the database?

a)

Data Model

b)

Data Model Schema

c)

Database Model

d)

Database Schema

44.

It represents the logical view of the entire database?

a)

Data Model

b)

Data Model Schema

c)

Database Model

d)

Database Schema

45.

It contains schema objects like table, keys, columns and data types, and stored procedure.

a)

Data Model

b)

Data Model Schema

c)

Database Model

d)

Database Schema

46.

It can be represented by using the visual diagram.

a)

Data Model

b)

Data Model Schema

c)

Database Model

d)

Database Schema

47.

In the database schema describe in the image, how STUDENT and GRADE_REPORT relations has relationship?

a)

Through Name attribute

b)

Through Student_number attribute

c)

Through Class attribute

d)

Through Major attribute

48.

In the database schema describe in the image, how COURSE and PREREQUISITE relations has relationship?

a)

Through Course_name attribute

b)

Through Course_number attribute

c)

Through Credit_hours attribute

d)

Through Department attribute

49.

In the database schema describe in the image, how SECTION and PREREQUISITE relations has relationship?

a)

Through Section_identier attribute

b)

Through Course_number attribute

c)

Through Semester attribute

d)

Through Instructor attribute

50.

In the database schema describe in the image, how STUDENT and SECTION relations has relationship?

a)

Through Section_identier attribute from the GRADE_REPORT relation

b)

Through Course_number attribute from the PREREQUISITE relation

c)

Through Semester attribute from the SECTION relation

d)

Through Instructor attribute from the SECTION relation

51.

It is a data independence that refers characteristic of being able to change the conceptual schema without having to change the external schema.

a)

Logical Data Independence

b)

Data Independence

c)

Physical Data Independence

d)

External Level Independence

52.

It used to separate the external level from the conceptual view.

a)

Logical Data Independence

b)

Data Independence

c)

Physical Data Independence

d)

External Level Independence

53.

It is a data independence can be defined as the capacity to change the internal schema without having to change the conceptual schema.

a)

Logical Data Independence

b)

Data Independence

c)

Physical Data Independence

d)

External Level Independence

54.

It is used to separate conceptual levels from the internal levels.

a)

Logical Data Independence

b)

Data Independence

c)

Physical Data Independence

d)

External Level Independence

55.

Where in the diagram is the occurrence of the logical data independence?

a)

1

b)

2

c)

3

d)

4

56.

Where in the diagram is the occurrence of the physical data independence?

a)

1

b)

2

c)

3

d)

4

57.

It is used to define database structure.

a)

Data Definition Language

b)

Data Manipulation Language

c)

Data Control Language

d)

Transaction Control Language

58.

It is used to create schema, tables, indexes, constraints, etc. in the database.

a)

Data Definition Language

b)

Data Manipulation Language

c)

Data Control Language

d)

Transaction Control Language

59.

It is used for accessing and manipulating data in a database.

a)

Data Definition Language

b)

Data Manipulation Language

c)

Data Control Language

d)

Transaction Control Language

60.

It is used for accessing and manipulating data in a database.

a)

Data Definition Language

b)

Data Manipulation Language

c)

Data Control Language

d)

Transaction Control Language

61.

It is used to retrieve the stored or save data.

a)

Data Definition Language

b)

Data Manipulation Language

c)

Data Control Language

d)

Transaction Control Language

62.

Create: It is used to create objects in the database. In what DBMS Language that task belong?

a)

Data Definition Language

b)

Data Manipulation Language

c)

Data Control Language

d)

Transaction Control Language

63.

Alter: It is used to alter the structure of the database. In what DBMS Language that task belong?

a)

Data Definition Language

b)

Data Manipulation Language

c)

Data Control Language

d)

Transaction Control Language

64.

Drop: It is used to delete objects from the database. In what DBMS Language that task belong?

a)

Data Definition Language

b)

Data Manipulation Language

c)

Data Control Language

d)

Transaction Control Language

65.

Delete: It is used to delete all records from a table. In what DBMS Language that task belong?

a)

Data Definition Language

b)

Data Manipulation Language

c)

Data Control Language

d)

Transaction Control Language

66.

Insert: It is used to insert data into a table. In what DBMS Language that task belong?

a)

Data Definition Language

b)

Data Manipulation Language

c)

Data Control Language

d)

Transaction Control Language

67.

An ACID property that defines data remains atomic.

a)

Atomicity

b)

Consistency

c)

Isolation

d)

Durability

68.

An ACID property that means the value should remain preserved always.

a)

Atomicity

b)

Consistency

c)

Isolation

d)

Durability

69.

An ACID property that the integrity of the data should be maintained.

a)

Atomicity

b)

Consistency

c)

Isolation

d)

Durability

70.

An ACID property that means separation.

a)

Atomicity

b)

Consistency

c)

Isolation

d)

Durability

71.

An ACID property that ensures the permanency of something.

a)

Atomicity

b)

Consistency

c)

Isolation

d)

Durability

72.

An ACID property that means if a change in the database is made, it should remain preserved always.

a)

Atomicity

b)

Consistency

c)

Isolation

d)

Durability

73.

An ACID property that no data should affect the other one.

a)

Atomicity

b)

Consistency

c)

Isolation

d)

Durability

74.

An ACID property that ensures the data after successful execution of the operation becomes permanent in the database.

a)

Atomicity

b)

Consistency

c)

Isolation

d)

Durability

75.

It is a collection of related data.

a)

Data

b)

Record

c)

Relation

d)

Database

Similar Resources on Wayground

Primary 6 Term 2 Computing Assessment

74 questions

Primary 6 Term 2 Computing Assessment

quiz

Worksheet

•

6th Grade - University

SAP - CO

80 questions

SAP - CO

quiz

Worksheet

•

University

Analisis Tema 2 Plataformas 1

70 questions

Analisis Tema 2 Plataformas 1

quiz

Worksheet

•

University

MIS_chapter_5_Kenneth_Laudon

80 questions

MIS_chapter_5_Kenneth_Laudon

quiz

Worksheet

•

University