NEW
Font size
WorksheetsPreliminary Exam-ITSYS
Total questions: 60
Worksheet time: 47mins
1. The physical devices of a computer :
Software
Package
Hardware
System Software
Which of the following is designed to control the operations of a computer
Application Software
System Software
Utility Software
User
Which of the following is not an example of system software?
Language Translator
Utility Software
Communication Software
Word Processors
___________________ is designed to solve a specific problem or to do a specific task.
Application Software
System Software
Utility Software
User
Which of the following software can’t be categorized application software?
DBM
MS-DOS
Spreadsheet
Word processing
Information is ____________________.
Data
Processed Data
Manipulated input
Computer output
Data by itself is not useful unless
It is massive
It is processed to obtain information
It is collected from diverse sources
It is properly stated
Information systems are composed of ___ major components.
5
4
3
2
An ______________________________ interrelated components that collect, process, store, and distribute information to support decision making and control in an organization.
Information system
Knowledge system
Database system
Computer system
The United States Department of Defense created and funded ARPA Net (Advanced Research Projects Administration), an experimental network which eventually became known as the Internet. In what year did this occur?
1949
1959
1969
1979
Who invented the World Wide Web (WWW)?
Marc Andreeson
Vinton Cerf
Arthur C. Clarke
Tim Berners-Lee
Which among the following is the correct sequence of information processing in a computer.
Data, input, output, storage
Input, process, output, storage
Input, storage, process, output
Input, display, process, output
One of the major works of software is to transform data into ……
Information
Video
Website
Software program
If all the hardware fixed properly even then it cannot reboot if …
It doesn’t have loader
It doesn’t have operating system
It doesn’t have compiler
It doesn’t have internet connection
Internet can help you find the shortest route.
True
False
A term in computer terminology is a change in technology a computer is/was being used.
development
generation
advancement
growth
A network that links many different types of computers all over the world.
Intranet
Internet
Arpanet
LAN
Internet was evolved from the basic ideas of ARPANET.
True
False
In the Client-server model, the client receives a request from the server.
True
False
They normally interact with the system via user interface provided by the application software.
Programmers
Developers
Users
Testers
Word processing software is a type of application software.
True
False
A person who designs the programs in a software package is called :
User
Software Manager
Developer
Programmer
The core and brains of the computer.
CPU
ROM
RAM
Motherboard
What is the main function of the motherboard?
It processes the instructions given to a computer
It acts as the brains of a computer
It ties together all of the functions of a computer
It allows a computer to display video
What manages and directs the flow of data between each of the components?
Memory
Motherboard
CPU
Chipset
RAM stand for
Rugs And Mud
Rotten Apple Money
Really Awesome Monkeys
Random Access Memory
Which of these storage devices can hold the most data
DVD
Hard drive
RAM
Flash drive
What does USB stand for?
Universal Signal Board
Universal Signal Bus
Universal Serial Bus
Universal Serial Board
What is the most popular category of portable PCs?
Notebook
Laptop
Palmtop
Suitcase computer
Which of the following system modules makes a PC really portable?
Battery
AC adapter
DC controller
PC Card
The two most obvious output devices are
Monitor and Printer
Floppy disc and CD
Keyboard and Mouse
Windows 2000 and Windows NT
The most common input devices are-
Microphone and Printer
Scanner and Monitor
Digital camera and Speaker
Keyboard and Mouse
_____________ function as a highly mobile computer, able to connect to the Internet through either cell technology or Wi-Fi.
DSLRs
Notepads
Tablets
Smartphones
_____________ have revolutionized computing, bringing the one feature PCs and laptops could not deliver, namely mobility.
Laptops
Smartphones
Tablets
Notepads
Internet of Things (IoT) can be integrated with which of these separate domains:
Cyber physical systems
Big-data networks
Cloud-based storage and computing
All of these
This class of software provides a way to do numeric calculations and analysis, displaying the result in charts and graphs.
Suites
DBMS
Spreadsheets
Word processor
Using this class of software, can create slideshow presentations.
DBMS
Spreadsheets
Powerpoint
Word processor
Using this class of software, can create and edit documents.
Presentation graphics
DBMS
Spreadsheets
Word processing
Which of the following utilities can remove software you no longer want installed.?
Scandisk
Anti-malware
Defragmentation
Winzip
This includes programs that allow you to fix or modify your computer in some way.
Programming software
Utility software
Spreadsheets
Word processing
Most of these programs provide developers with an environment in which they can write the code, test it, and convert/compile it into the format that can then be run on a computer.
Programming software
Utility software
Spreadsheets
Word processing
Is the linkage between an organization’s suppliers, its manufacturing facilities, and the distributors of its products.
Delivery chains
Supply chains
Procurement chains
Distribution chains
This system manages an organization’s customers.
Supply Chain Management
Fulfillment Management
Service and Parts Management
Customer Relationship Management
This software was developed to bring together an entire organization within one program. It utilizes a central database that is implemented throughout the entire organization.
Customer Relationship Management
Electronic Data Interchange
Enterprise Resource Planning
Electronic Fund Transfer
Which of the following is the most common type of virtualization?
Storage
Virtual Machines
Networking
Server
What type of computing technology allows users to access software and data storage services on the Internet.?
Distributed Computing
Cloud Computing
Soft Computing
Parallel Computing
Which of the following are Benefits of Big Data Processing?
Businesses can utilize outside intelligence while taking decisions
Improved customer service
Better operational efficiency
All of the above
The database environment has all of the following components except:
Users
Separate files
Database
Database administrator
Normalization is used to design ________________
join dependencies
relational database
multi-valued dependencies
cyclic dependencies
BOOLEAN is a type of data type which basically gives a tautology or fallacy - 0 or 1, “true” or “false”, “yes” or “no”.
True
False
Which of the following is not a data type?
Alphabetic Data
Numeric Data
Alphanumeric Data
Symbolic Data
What is the full form of SQL?
Structured Query List
Structure Query Language
Sample Query Language
None of these
QBE stands for
Query By Equation
Query By Entity
Query By Entity Set
Query By Example
NoSQL can be referred to as
No SQL
Only SQL
Not Only SQL
SQL Undefined
Metadata is “data that provides information about other data.
True
False
Data can be visualized using?
graphs
charts
maps
All of the above
A Data Warehouse is which of the following?
can be updated by end users.
contains numerous naming conventions and formats.
organized around important subject areas.
contains only current data.
A goal of data mining includes which of the following
To explain some observed event or condition
to confirm that data exists
To analyze data for expected relationships
To create a new data warehouse
Knowledge management is the process of creating, formalizing the capture, indexing, storing, and sharing of the company’s knowledge in order to benefit from the experiences and insights that the company has captured during its existence.
True
False
Machine learning is used to analyze data and build models without being explicitly programmed to do so.
True
False
