Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ОИС 55 ВОПРОС ТОГЖАН 100/100 БУЙЫРСА

Total questions: 55

Worksheet time: 33mins

Name
Class
Date
1.

What is a system made of tools like computers (hardware), programs (software) and networks

that work together to collect and manage information, helping people in a company make

decisions and stay organized?

It's objective is to provide appropriate information to the user, gather the data, process the data,

and communicate information to the user of the system.

a)

Database Management System

b)

Information System (IS)

c)

SRS

d)

Information Technology (IT)

2.

______________________is the use of computers, storage, networking and other physical devices, infrastructure and processes to create, process, store, secure and exchange all forms of electronic data.

a)

Information system (IS)

b)

Database management system

c)

Network communications

d)

Information technology (IT)

3.

The set of instructions or programs used to control and coordinate hardware, and analyze and process data, is called

a)

networking communication

b)

software

c)

IT

d)

hardware

4.

The information system is made up of five essential components. What are these components?

a)

programming, hacking, debugging, coding, and designing

b)

software, dbms, internet, tools and users

c)

hardware, software, database, networking communication, and people

d)

hardware, storage, applications, networking communication, and customers

5.

(a)   means raw facts like numbers, letters, sounds, pictures, and symbols. By itself, it isn’t very useful. But when we collect it, organize it, and store it in a database, it becomes meaningful and helpful for decision-making.

6.

(a)   is the physical technology that includes all physical devices and materials used in information processing. That means it includes all the tangible equipment used for input, output, and processing of data.

7.

Which type of Information System helps a business handle daily tasks like sales, payments, bookings, and payroll?

a)

Decision Support System (DSS)

b)

Executive Support System (ESS)

c)

Management Information System (MIS)

d)

Transaction Processing System (TPS)

8.

Which of the following is an example of an Office Automation System (OAS)?

a)

Clash of Clans – for playing games

b)

Spotify – for listening to music

c)

Adobe Illustrator – for graphic design only

d)

Google Docs – for typing and sharing documents

9.

Which of the following sequences correctly represents the main functions of an Information System?

a)

Input → Output → Storage →Processing → Feedback

b)

Input → Processing → Storage → Output → Feedback

c)

Processing → Input → Storage→Output → Feedback

d)

Feedback →Storage → Output → Input → Processing

10.

Which function of an IS involves the activity of gathering and capturing raw data?

a)

Output

b)

Processing

c)

Input

d)

Feedback

11.

Which of the following is an example of the "Output" function in an IS?

a)

Data being analyzed and transformed.

b)

A correction made to a process based on performance data.

c)

A report generated from processed data.

d)

Data entered into a system.

12.

Examples of databases include:

a)

Cloud computing

b)

MySQL

c)

relational database management systems

d)

NoSQL

e)

MongoDB

13.

Examples of IT:

a)

Salesforce, used for managing customer relationships

b)

A database server

c)

Operating systems like Windows and Linux

e)

A Wi-Fi router

14.

Examples of IS:

a)

Microsoft Word for writing text with no data processing or storage

b)

Google Maps for showing locations and analyzing geographic data+

c)

Platonus, a university platform for grades and schedules+

d)

Adobe Photoshop for editing images

15.

_____1____ focuses on the technology itself. This includes hardware, software, and networks. On the other hand, ____2_____ involves more than just technology. ______2_____ combines technology, people, and processes to solve problems. It's about how people use technology to manage data and support decision-making.

a)

1 - IS, 2 – process

b)

1 - IS, 2 – IT

c)

1 - technologies, 2 – systems

d)

1 - IT, 2 – IS

16.

What type of Information System helps businesses manage customer relationships effectively?

a)

Executive Support System (ESS)

b)

Geographic Information System (GIS)

c)

Customer Relationship Management System (CRM)

d)

Management Information Systems (MIS)

e)

Transaction Processing System (TPS)

17.

On those social media platforms IS components are:

  • ● the Twitter or Facebook app and the web version are the _______1________

  • ● the computers in Facebook's and Twitter's offices and their data centers are the _______2_____. It could also involve the devices on which users access those social media platforms

  • ● the ______3_____ is the biodata of users, the tweets and posts, and the engagements they have

  • ● the ______4______are the employees of the social media platforms, and possibly the users

  • ● the ______5_________are the steps taken to convey the data and the resulting information to the users

a)

1 - technologies, 2 - systems, 3 - information, 4 - people, 5 – processes

b)

1 - programs, 2 - IT, 3 - information, 4 - people, 5 – processes

c)

1 - software, 2 - hardware, 3 - data, 4 - people, 5 – processes

d)

1 - software, 2 - hardware, 3 - processing data, 4 - people, 5 - managing data

18.

(a)   refers to processed, organized, and structured data. It gives context for the facts and facilitates decision-making. In other words, it is processed data that makes sense to us.

19.

What are examples of Data? (more than one answer)

a)

Student Grades: A list of numerical scores obtained by students on a test, like “85”, “92”, “78”.

b)

Weather Report: Based on the temperature reading a weather report can be generated.

c)

Temperature Readings: Numbers representing temperature throughout the day, such as “72°F”, “68°F”, “75°F”.

d)

Grade Average: Based on the student grades, the average grade of class can be derived.

20.

Which sequence correctly describes how an Information System (IS) works?

1) The system takes data and information from a variety of sources, including sensors, keyboards, scanners, and databases.
2) The system converts raw data into useful information using a variety of techniques such as sorting, classifying, calculating, analyzing, and synthesizing.
3) The system stores the processed data in a structured and safe manner, such as in a database, file system, or cloud storage.
4) The system displays information to users such as reports, graphs, charts, or dashboards.
5) The system requests feedback from users and other stakeholders to assess its effectiveness and enhance its design and functioning.

a)

1 - Data, 2 - Processing, 3 - Ouput, 4 - Storage, 5 – Feedback

b)

1 - Input, 2 - Storage, 3 - Processing, 4 - Output, 5 – Control

c)

1 - Input, 2 - Processing, 3 - Storage, 4 - Output, 5 – Feedback

d)

1 - Gather input, 2 - Processing, 3 - Storage, 4 - Feedback, 5 – Output

21.

Databases are managed using specialized software called a ____________________, which allows users to store, retrieve, and manipulate data efficiently.

a)

Software Development Life System

b)

Relational Databases

c)

Database Management System (DBMS)

d)

Centralized Databases

22.

A (a)   is an electronically stored, systematic collection of data that can include words, numbers, images, videos, and other types of files.
Write your answer in CAPITAL LETTERS (one word)

23.

Examples of Relational Database Management System (RDBMS)

a)

MySQL

b)

Oracle

c)

Microsoft SQL Server

d)

Postgre SQL

e)

Cassandra

24.

__________ is a common language used for reading, updating, creating and deleting data from the RDBMS.

a)

Software Query Language

b)

Structured Query Language

c)

Structure Quality Language

d)

System Queries Language

25.

________________ organizes data into tables composed of rows and columns. It uses primary keys to uniquely identify rows and foreign keys to establish relationships between tables.

a)

Hierarchical Database

b)

Object-Oriented DBMS

c)

Relational Database Management System (RDBMS)

d)

NoSQL DBMS

26.

_________________ are commands used to interact with the database, allowing users to retrieve, manipulate, or update data. For instance, SELECT * FROM Customers WHERE Country = 'USA'; retrieves all customers from the USA.

a)

Data

b)

Queries

c)

Schema

d)

DBMS

27.

Match types of databases:

1) ______________ contents are arranged as a collection of tables with rows and columns. It is used in e-commerce platforms, banking systems, and HR management.
2) The data is represented and stored as
objectswhich are similar to the objects used in the object-oriented programming language.
3) ________________ handle 
unstructured and semi-structured data. They are highly scalable and flexible, making them ideal for real-time applicationssuch as social media platforms, IoT applications.

a)

1 - Graph Databases, 2 - Object-Oriented Databases, 3 - NoSQL Databases

b)

1 - Relational Databases, 2 - Object-Oriented Databases, 3 - Cloud Databases

c)

1 - Relational Databases, 2 - Object-Oriented Databases, 3 - Hierarchical Databases

d)

1 - Relational Databases, 2 - Object-Oriented Databases, 3 - NoSQL Databases

28.

Here data is stored in tabular form - columns and rows. This table is an example of _____________________

a)

NoSQL databases

b)

Hierarchical databases

c)

Relational databases

d)

Graph databases

29.

_

is a repository of data.

Write your answer in CAPITAL LETTERS (one word)

(a)  

30.

What are data types are shown here?

a)

1 - Unstructured, 2 - Hierarchial data, 3 - Structured data

b)

1 - Non organized, 2 - Semi-organized data, 3 - Organized data

c)

1 - Unstructured, 2 - Semi-structured data, 3 - Structured data

d)

1 - Structured, 2 - Semi-structured data, 3 - Relational data

31.

Examples of structured data include:

(more than one answer)

a)

Text documents (e.g., PDFs, Word documents, and open-ended survey responses)

b)

Customer demographic information (e.g., name, address, age, gender)

c)

Photos and videos, because multimedia files are usually stored as raw data and lack predefined fields.

d)

Entity relationship diagrams (e.g., tables, rows, columns, primary keys, foreign keys)

e)

Financial transactions (e.g., sales data, purchase orders, accounting entries)

32.

DBMS examples:

a)

PostgreSQL

b)

MySQL

c)

Microsoft Access

d)

Apache Cassandra

e)

MongoDB

33.

A______is software that helps create and manage databases.

● It lets users add, view, change, and delete data in a database.

● It keeps data safe, accurate, and allows many users to work at the same time.

● It also connects users or apps with the database so the data stays organized and easy to

access.

a)

relational database

b)

Spreadsheet

c)

Database technologies

d)

SQL

e)

DBMS

34.

The data in RDBMS is stored in database objects called ____________. A ___________ is a collection of related data entries and it consists of columns and rows.

a)

database

b)

Table

c)

sql

d)

data structure

35.

Which SQL keyword is used to choose all columns in a table?

a)

EVERY

b)

AND

c)

GET

d)

ALL

e)

*

36.

Which SQL query shows students who wrote a comment that includes the phrase “I love studying OIS”?

a)

SELECT * FROM students WHERE comment LIKE '%I love studying OIS%';

b)

SELECT * FROM students WHERE comment LIKE 'I love studying OIS';

c)

SELECT * FROM students WHERE comment = "I love studying OIS';

d)

SELECT * FROM students WHERE comment CONTAINS 'I love studying OIS';

37.

Which SQL statement correctly adds a new customer to the table?

a)

INSERT INTO customers ('CustomerID', 'CustomerName', 'ContactName') VALUES (92, 'Global Foods', 'Anna Ivanova');

b)

INSERT INTO customers (CustomerID, CustomerName, ContactName) VALUES (92, 'Global Foods', 'Anna Ivanova');

c)

INSERT customers Values (92, 'Global Foods', 'Anna Ivanova');

d)

CREATE customers VALUES (92, 'Global Foods', 'Anna Ivanova');

38.

Which of the following statements is incorrect regarding keys in a relational DBMS?

a)

The rules for primary and foreign keys serve the same purpose

b)

Each table can have only one primary key

c)

A table can contain multiple foreign keys or none at all

d)

A foreign key links one table to another by referencing a primary key

39.

What kind of document is being described in the text above?

Usually, clients and developers speak different languages.
The client imagines how the system will work from the 
outside: what it should do and how users will interact with it.
Developers, on the other hand, think about the 
internal logic of the product.

A 
business analyst helps them understand each other.
The analyst turns the client’s needs into 
requirements, and those requirements into tasksfor developers.
This process begins by creating a 
specific document that describes what the software should do which is called ________.

a)

API

b)

SDLC

c)

SRS

d)

SRSP

e)

Technical task reports

40.

A table can have only one (a)   key, and that key is used to uniquely identify each row in the table. It must UNIQUE values, and cannot contain NULL values.


Write your answer in CAPITAL LETTERS (one word)

41.

_____________________ is a cyberattack where malicious SQL queries are injected into input fields to manipulate a database, enabling unauthorized access, data modification, or corruption.

a)

Phishing

b)

SQL Hacking

c)

SQL Injection

d)

SQL DDos

42.

An ________ is a set of rules that allow different software applications to communicate with each other. Think of it like a bridge that connects two systems and lets them share data or services.

a)

API (access program interface)

b)

API (application programming interface)

c)

API (application protocol interface)

d)

Hypertext Transfer Protocol (HTTP)

e)

(SRS) Software Requirement Specification

43.

What type of API is a simple, flexible API architecture that uses HTTP methods (GET, POST, PUT, DELETE) for communication?

a)

SOAP (Simple Object Access Protocol)

b)

REST (Representational State Transfer)

c)

Web API

d)

GraphQL

44.

What is being described in the text?

A third-party developer creates their own application, function, or operating system.

They create 
it— a set of rules that allows other developers to use their work in different ways.
You receive 
it— it might be publicly available or accessible upon request for clients.
You call 
it inside your own application and use the functions you need.

You don’t need to know how its function works internally. It might be very complex and contain thousands of lines of code, but you can use it with a single call and get the result you want.

You can also create your own its functions for your web application, which is a set of instructions that other apps can follow to interact with yours.
This allows other services to integrate with your system.

a)

How the IS works

b)

How a database stores information

c)

How the API works

d)

How to write full applications from scratch

e)

How to test code for errors

45.

Having a clear list of requirements helps developers build software that meets the client’s needs.

An SRS helps estimate cost, plan the work, and choose the right technologies.

It’s not just for developers:

● Designers use the SRS to understand how the design should look based on user needs.

● Testers use it to create tests that match business needs.

  • ● Investors can understand the project better through presentations based on the SRS.

  • ● It keeps everyone on the same page — developers, project managers, and clients.


What is the main role of an SRS (Software Requirements Specification)?

a)

It helps design the company logo and better interface for clients

b)

It stores user information involved in the project

c)

It manages the project budget for stakeholders

d)

It is a roadmap that guides everyone involved in the project

46.

What distinguishes functional requirements from non-functional requirements in an SRS?

a)

Functional requirements describe what the system should do; non-functional requirements describes how the system should perform.

b)

Functional requirements are optional; non-functional requirements are mandatory and define the purpose, scope, and intended audience of the document

c)

Functional requirements are about system performance; non-functional requirements are about system features

d)

Functional requirements relate to user interfaces; non-functional requirements relate to databases.

47.

Examples of Functional Requirements for Online Banking System
(3 answers)

a)

The system should be able to handle 100 million users with minimal downtime.

b)

The system should respond to user actions in less than 2 seconds.

c)

Users should receive notifications after making a transaction.

d)

Users should be able to log in with their username and password.

e)

Users should be able to check their account balance.

48.

Examples of Non-functional Requirements for Food Delivery App


(3 answers)

a)

The app should load the restaurant menu in under 1 second.

b)

Users can browse the menu and place an order.

c)

The system should support up to 50,000 concurrent orders during peak hours.

d)

The app should be easy to use for first-time users, with an intuitive interface.

e)

Users can make payments and track their orders in real time.

49.

Match each SRS user to how they utilize the document. Choose the correct order:

a)

1 - Investor, 2 - Business Analysts, 3 - Software Developers, 4 - Architect, 5 - QA/QC Engineers, 6 - Project Managers, 7 - Client

b)

1 - Customer, 2 - Business Analysts, 3 - Software Engineers, 4 - Designers, 5 - QA/QC Engineers, 6 - Project Managers, 7 – Investor

c)

1 - Customer, 2 - Project Managers, 3 - Programmers, 4 - Designers, 5 - Testers, 6 - Data and Business Analytics, 7 - Investor and Client

d)

1 - Customer, 2 - Business Analysts, 3 - Software Engineers, 4 - Architect, 5 - QA/QC Engineers, 6 - Project Managers, 7 - Stakeholder

50.

__________ is a way to visually describe how a system works. Just like an architect draws a plan of a building before it’s built, software developers use ___________ to draw a plan of their software system before they start coding. We use _________ diagrams to show the behavior and structure of a system.

a)

UML

b)

HTML

c)

SQL

d)

SDLC

51.

Use Case Diagram Notations:

1)_____________ are external entities that interact with the system. These can include users,

other systems, or hardware devices. In the context of a Use Case Diagram, _______________

initiate use cases and receive the outcomes.

2) _____________

are like scenes in the play. They represent specific things your system can

do. In the online shopping system, examples of

could be "Place Order," "Track

__________

Delivery," or "Update Product Information".

3) _________________

is a visual representation of the scope or limits of the system you are

modeling. It defines what is inside the system and what is outside.

a)

1) Actor 2) Actions 3) System border

b)

1) Users 2) Entities 3) System boundary

c)

1) Actors 2) Use Cases 3) System boundary

d)

1) Customers 2) Use Case 3) System line

52.

Use cases are represented by ___________.

a)

diamonds

b)

square

c)

rectangles

d)

Ovals

53.

What does <<include>> mean?

a)

the use case is optional and comes after the base use case.

b)

this relationship is useful for handling optional or exceptional behavior.

c)

a use case can be extended by another use case. This means that the main use case can be enhanced by adding the functionality of the other use case.

d)

a use case includes the functionality of another use case. The use case being included is a part of the main use case and cannot be used on its own.

54.

_________________ visualizes the relationships between entities like people, things, or concepts in a database. It will also often visualize the attributes of these entities.

a)

Class diagram

b)

Use Case Diagram

c)

ER diagram

d)

Sequence diagram

55.

A __________________ is a type of UML diagram that represents the interaction between actors (users or external systems) and a system under consideration to accomplish specific goals. It provides a high-level view of the system's functionality by illustrating the various ways users can interact with it.

a)

Class diagram

b)

Use Case Diagram

c)

Database design

d)

ER Diagram