Font size
WorksheetsIGSCE The 1st Year Revision
Total questions: 123
Worksheet time: 1hrs 14mins
Which statement is correct:
The CPU takes data and programs held in hard drive and puts them into RAM temporarily
The CPU takes data and programs held in RAM and puts them into hard drive temporarily
CPU is connected to the memory through the:
Arithmetic and logic unit
Control unit
Buses
HDD
What are the small & very fast circuits that store intermediate values from calculations or instructions inside the CPU?
Registers
Buses
Ports
Which type of memory is faster:
Cache
RAM
What is the role of system clock in CPU:
Measures the time one CPU action takes
Synchronises all computer operations
Measures the time it takes to transmit the data through the CPU buses
Instructions are fetched from RAM in a machine cycle:
True
Only the first time
False
The correct order is:
Decode, Fetch, Execute
Execute, Decode, Fetch
Decode, Execute, Fetch
Fetch, Decode, Execute
What controls the flow of data and instructions in CPU?
Registers
Control unit
Arithmetic and logic unit
Which one type of memory is permanently holding data even if power is switched off:
ROM
RAM
Which one type of memory it can be written to or load from:
ROM
RAM
Which one is faster?
Solid state drive
Hard disk drive
What external secondary memory device you can name?
USB
HDD
RAM
What secondary memory devices you know?
HDD
USB
RAM
ROM
IP addresses of the sender and receiver are being sent in which part of the data packet:
Header
Payload
Trailer
The actual data is being sent in which part of the data packet:
Header
Payload
Trailer
Packet switching is:
A method of error detection based on particular actions with packets
A method of data transmission in which a message is broken up into number of packets
A method in which CPU switches it's buses
One of the key benefits of the packet switching is that:
Data can't be lost
There is no need to depend on one communication line
Hopping method is designed to avoid:
The slow work of CPU
A loss of data packets
The slow data transmission
A loss of memory
The direction of half-duplex data transmission mode is:
One direction only
Both directions but not at the same time
Both directions at the same time
An example of simplex data transmission mode is:
Broadband internet connection
Sending some data from computer to printer
Walkie-talkie
What types of data transmission there exist:
Serial and parallel
Serial and duplex
Simplex and parallel
Even parity can be observed in which byte of information:
10110010
11101010
10101011
An agreement about the type of parity used between the sender and receiver is usually made:
Before sending the data
After sending the data
Which method allows to identify which particular bit is in error
Parity bit added to the string of bits
Parity block
When we are using echo check method, a data is re-sent to the receiver when:
No errors were found in transmitted data before
Some errors were found in transmitted data before
Public and private keys are being used to encrypt the information in:
Symmetric encryption
Asymmetric encryption
The same key to encrypt and decrypt information is being used in:
Symmetric encryption
Asymmetric encryption
Data that has gone through the encryption algorithm is called:
Ciphertext
Plaintext
Decrypted text
Private key is used to:
Encrypt information
Decrypt information
Which of these is not an input device:
Printer
Barcode scanner
Digital camera
Touch screen
What kind of sensors a typical security system might consist of:
Humidity
pH
Acoustic
Infrared
What is a charge couple device:
Light-sensitive part of the digital camera that consists of millions of tiny sensors and that converts light into electricity
The membrane under the keyboard that identifies the press of a particular button of it
A device that can charge a laptop or mobile phone twice as fast as usual charger
Which of these is not an output device:
Light projectors
Printer
Loud speaker
Microphone
How the physical quantities are being converted to the digital data in such devices as microphone, camera, etc.:
By the analogue to digital converter
By the digital to analogue converter
By the electrodes to data converter
What would be the examples of 3D scanners:
3D printer
Magnetic resonance
X-ray
Passports' scanner at the airport
Documents' scanner
What type of touch screens you are familiar with:
2D, 3D
LCD, LED
Capacitive, infrared, resistive
What type of touch screen use electrical properties of human body to identify the touch:
Capacitive
Resistive
Electrical
What type of light projectors you are familiar with:
Digital light projector (DLP) and liquid crystal display (LCD)
Light emitting diodes projector (LED) and liquid crystal display (LCD
Inkjet projector and laser
How the optical mouse identifies the movement of it:
The built-in sensor identifies the movement of a hand
The tiny camera captures the reflected red LED light from the surface
Which type of printer is better designed for the high volume of printing:
Inkjet
Laser
Which type of printer is producing solid physical objects:
Laser
3D printer
Inkjet
Each character on the keyboard has:
ASCII value
QR value
DAC value
Embedded system is:
Hardware
Software
Combination of hardware and software
Embedded system can be based on:
Microcontrollers, microprocessors, system on chips
Microcontrollers, microprocessors, microcomputers
Microcontrollers, microprocessors
Benefits of embedded system include:
Consume little power
Small in size and can fit into other devices
If it has any errors, no need for specialists to fix it - anyone can fix it
In all the cases, it is really easy to upgrade it and take advantage of new technology
Which type of embedded system can be upgraded easily:
Programmable
Non-programmable
In a case of lighting system in an office (as an example of embedded system) which parameters are being controlled by the sensors:
Room occupation
A day of the week and time of the day
Brightness of the room
What is a barcode:
Series of dark and parallel lines of varying thickness
Square of black pixels on a light background
Each digit of a barcode consists of:
Two dark lines and two white lines
One dark line and one white line
Two dark lines and one white line
After being scanned, barcode is:
The photo of barcode is being taken and compared with other images on the database
Converted to digital data - binary form, and looked up in the database
The advantages of using barcode by the management of a store are:
The barcodes on items never become damaged (not like physical price tags)
Automatic stock control
Much easier to change prices of items
QR codes can:
Hold more information than barcodes
Hold less information than barcodes
The three large squares at the corners of the QR code are responsible for:
Size recognition - helps scanner to identify how far away it is from the QR code
Alignment - ensures that even if scanner is tilted, it can still be read
Each one of them can contain different web address to redirect reader to
One of the disadvantages of the QR code is:
They can redirect to malicious websites
They are harder to read for the scanner than barcodes
Only developers with special knowledge can generate QR code
QR code with the 8 x 8 pixels can store:
16 bytes of data
64 bytes of data
8 bytes of data
What is an OS:
Software that manages the hardware and software resources of a computer
Hardware that manages the hardware and software resources of a computer
Which of these is not a function of an OS:
Provide a user interface
Allow the computer to multi-task
Improves CPU performance
Manages memory
What do device drivers do?
Allows the OS to communicate with hardware
Drives around the CPU
Increases the amount of storage on HDD
What does GUI stand for?
Genuine Umpire Impressions
Graphical User Interface
Graphic Up Industry
Graphical User Interaction
How can the OS help manage security of the system?
The OS can hire backup
User accounts may be password protected
Files can self destruct after a set time
The ability for different people to use the same computer is made possible through:
Open-source software
Desktop elements
User accounts
Settings app
Which of the following is a function of the operating system?
To compose and send email.
To edit photographs and other high-resolution images.
To manage files.
All of these are operating system functions.
Which of the followings is not GUI operating system?
DOS
Windows
iOS
How many applications can be processed by the CPU at a time?
1
Up to 1000
As many as it is possible at a time
What is an example of short term memory?
SSD
RAM
HDD
What is a correct order of structure consisting of 'Hardware', 'User', 'OS' and 'Application'?
User->Application->OS->Hardware
Application->User->OS->Hardware
Hardware->User->OS->Application
What does CLI stands for:
Command-line interface
Command-linear interface
Computer-line interface
Command-limited interface
Which one of these gives user more control:
GUI
CLI
An example of the goal of particular application software could be:
To edit audio files
To manage peripheral devices
To manage memory
What is a trace table
A technique used to test algorithms
A technique used to write algorithms
When you copy someone's table
Look at the Algorithm Below. In the corresponding Trace Table, what value should 'B' be?
1
3
5
7
Look at the Algorithm Below. In the corresponding Trace Table, what value should 'C' be?
1
3
8
13
The second reason why trace tables are used:
To find the errors that are not easily spotted.
To automate the algorithm by using machine learning and AI techniques.
Look at the Algorithm Below. What is the name of the variable?
number
i
A
B
C
How many columns will the trace table have of this program (apart from the 'Line of the code' column)?
0
1
2
3
4
Look at the Algorithm Below. In the corresponding Trace Table, what value should 'D' be?
13
18
21
8
How many columns trace table have of this program (apart from the 'Line of the code' column)?
0
1
2
3
4
The trace table will contain two columns: Output and ...?
Even
This loop will repeat (a) times
A computer hardware component that connects a computer to a computer network is:
Network interface card (NIC)
Media Access Control (MAC)
Internet Protocol (IP)
Central Processing Unit (CPU)
A physical address of a network device, generated at the manufacturing stage:
Network interface card (NIC)
Media Access Control (MAC)
Internet Protocol (IP)
Central Processing Unit (CPU)
What is the goal of the Dynamic Host Configuration Protocol (DHCP)?
To encrypt the data sent between two devices
To provide and assign domain to the new website
To provide and assign IP addresses to devices connected to the network
Which type of programming languages is closer to machine and offers more control over hardware?
Low-level programming languages
High-level programming languages
Which type of programming languages is harder to write and debug?
Low-level programming languages
High-level programming languages
What is a purpose of a translator in a context of programming?
It is a tool that converts source code into machine code (binary)
It is a tool that converts machine code (binary) into programming language
It is a tool that translates from one high-level programming language to another
It is a tool that translates from one low-level programming language to another
What different types of translators you are familiar with?
Compiler, executor, editor
Corrector, translator, assembler
Machine code, high-level programming language, low-level programming language
Compiler, interpreter, assembler
Please convert this binary number to denary: 1 1 0.
(a)
Please convert this denary number to binary: 7.
(a)
Please convert this hexadecimal number to denary: 1A.
(a)
What does "SQL" stand for?
Structured Question Language
Structured Query Language
Simple Query Language
Simple Question Language
Which statement is used to extract data from a database?
Extract
Get
Open
Select
What is the correct order of clauses in a SQL statement?
SELECT, FROM, ORDER BY, WHERE
SELECT, FROM, WHERE, ORDER BY
SELECT, WHERE, FROM, ORDER BY
WHERE, FROM, SELECT, ORDER BY
Which SQL statement would add a record to the database?
INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')
INSERT VALUES ('SMI01', 'M Smith', 'mail@msmith.com', 01224123456') INTO Designer
INSERT ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') INTO Designer
INSERT Designer INTO VALUES (''SMI01', 'M Smith', 'mail@msmith.com', '01224123456')
How do we select all rows for the "Designer" table?
SELECT * FROM Designer
SELECT [All] FROM Designer
SELECT Designer.*
SELECT FROM Designer
With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?
SELECT * FROM Persons WHERE FirstName=’a’
SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
SELECT * FROM Persons WHERE FirstName=’%a%’
CREATE TABLE employee (id INTEGER,name VARCHAR(20),salary NOT NULL);
INSERT INTO employee VALUES (1005,Rach,0);
INSERT INTO employee VALUES (1007,Ross, );
INSERT INTO employee VALUES (1002,Joey,335);
Some of these insert statements will produce an error. Identify the statement.
Insert into employee values (1005,Rach,0);
Insert into employee values (1002,Joey,335);
Insert into employee values (1007,Ross, );
None of the mentioned
Which SQL statement is used to return only different values?
SELECT UNIQUE
SELECT DISTINCT
SELECT DIFFERENT
What is Entity-Relationship Diagram used for?
A referential value
(a) key is an attribute whose values match primary key values in the related table
The difference between OR and XOR Gate
both have 3 inputs
The output of the XOR in case of two ON inputs is 0
OR has 2 inputs and XOR has 3 inputs
They are similar in everything
Which is the truth table for the XOR gate?
The figure below shows a circuit composed of two logic gates. The output of the circuit is true.
Which of the following is a true statement about input A?
Input A must be true.
Input A must be false.
Input A can be either true or false.
There is no possible value of input A that will cause the circuit to have the output true.
Use the logic condition to find the value of Y:
A or B or C
True
False
Use the logic condition to find the value of X:
A or (B and C)
True
False
Which of the following is NOT an acceptable set of possible True and False Combinations
Which of the following is not a logic gate?
AND
OR
IF
NOT
File size of an image is calculated as:
Image resolution (in pixels) x colour depth (in bits)
Sample rate x sample resolution x length of sample
Image resolution + colour depth
Image resolution - colour depth
Pixels get their colour from a combination of which colours?
cyan magenta yellow black
red green blue
primary colours
black white
How many bits was used to encode the original ASCII character set?
7
8
16
4
A sound clip uses a sample rate of 4000Hz, an 8 bit sample resolution, and is 10 seconds long. What is the file size in bits?
4,000
32,000
40,000
320,000
What is lossy compression?
Compressing data without losing any details
Throwing away some information to save space
Compressing data using patterns
None of the above
What is lossless compression?
Compressing data without losing any details
Throwing away some information to save space
Compressing data using patterns
None of the above
Denary is a base ____ number system
2
10
16
50
A bitmap image of 20 by 20 pixels using a colour dept of 8 bits would have a file size of around:
400 bytes
3200 bytes
40 bytes
320 bytes
What is the main uncompressed audio file format?
.mp3
.mp4
.wav
.mov
What is most commonly used compressed audio file format?
.wav
.mp3
.mp4
.ogg
