Font size
WorksheetsOCR A level computer science
Total questions: 200
Worksheet time: 2hrs 53mins
Select the 'real' methodologies:
Agile
XP (extreme programming)
XD
Spiral
Waterfall
Iterative development methodology which values end-user input:
Agile
Waterfall
Spiral
RAD (rapid application development)
Iterative development methodology which values code quality:
XP
Agile
Waterfall
Spiral
RAD
Iterative development methodology which values speed of development:
XP
Agile
Waterfall
Spiral
RAD (rapid application development)
Iterative development methodology which focuses on risk-management:
XP
Agile
Waterfall
Spiral
RAD
Sequential development methodology which focuses on comprehensive documentation:
XP
Agile
Waterfall
Spiral
RAD
A large company who want to develop their software so people actually want to use it should use:
XP
Agile
Waterfall
Spiral
RAD
A processor company who need to develop high-quality code with minimal errors should use:
XP
Agile
Waterfall
Spiral
RAD
A company who need to manage a lot of risk should use:
XP
Agile
Waterfall
Spiral
RAD
This methodology is:
XP
Agile
Waterfall
Spiral
RAD
This methodology is:
XP
Agile
Waterfall
Spiral
RAD
A translator for high level code that translates code all at once into machine code
Assembler
Compiler
Interpreter
Programmer
A translator for high level code that translate codes as the program is being run.
Compiler
Interpreter
Assembler
Programmer
A translator used to convert a low level language into machine code
Compiler
Interpreter
Assembler
Programmer
Text area used to enter code in an IDE.
Breakpoints
Code Editor
Error Diagnostics
Run time environment
These are tools provided by IDE's which give detailed feedback on errors in your code.
Breakpoints
Code Editor
Error diagnostics
Run time environment
Enables the program to be run in an IDE to test the program
Breakpoints
Code Editor
Error diagnostics
Run time environment
Colours command words in different colours to make code more readable
Error diagnostics
Run time environment
Syntax completion
Keyword highlighting
A programming language like Python that is designed to be easy for humans to read and write and uses English command words and needs to be translated using a compiler or interpreter
Translator
High level language
Low level language
Machine code
A programming language that is uses mnemonics, is harder for a human to understand and needs to be translated using an assembler.
Translator
High level language
Low level language
Machine code
Converts either a high level language or a low level language into machine code
Translator
High level language
Low level language
Machine code
Binary code that can be directly run by a computer without being translated
Python Code
High Level Code
Low Level Code
Machine Code
Mouse
Input
Output
Storage
None of the Above
Foot pedal
Input
Output
Storage
None of the Above
Braille Printer
Input
Output
Storage
None of the Above
Microphone
Input
Output
Storage
None of the Above
CD
Input
Output
Storage
None of the Above
What type of memory is an HDD?
Optical
Magnetic
Flash
ROM
What are the 2 types of processors?
usable processors and unusable processors
CISC and RISC
RISC and BISC
RISC and BISC
How can multiple tasks be completed simultaneously?
with the use of threading
by having multiple core CPUs
by having parallel systems
What data type should be used to store phone numbers eg. 01724 282998?
Integer
String
Character
Long
Perform a logical shift right by three places on the binary number 010101100 and convert to decimal?
3.5
18.25
21.5
30.5
In what form of memory management is a process address broken down into fixed sized blocks?
Segmentation
Paging
Virtual memory
Partitioned
In which form of scheduling is processor time divided equally amongst all running tasks?
First come, first serve
Shortest job first
Multi-level feedback queue
Round robin
What is the role of the compiler?
Translate high-level code into machine code all at once, after carrying out a number of checks and reporting back any errors.
Translates machine code into high-level code all at once, after carrying out a number of checks and reporting back any errors.
Makes sure that the code has the correct syntax and variables have been assigned correctly
Runs low-level code and reports back any errors
What does the I in ACID stand for?
Integrity
Isolation
Integrated
Internal
Which of these is not in the SQL syntax?
LIKE
AND
UPDATE
WHEN
The control unit has many jobs, please select all which apply
Decoding instructions
Store results from calculations
Performs an interrupt request
Managing the flow of data between the CPU and other devices
Inside the processor, there is a multitude of parts. Please select all which are found inside the processor
Processor connection wire
Connection Bus
Data Bus
Interrupter
What does the operand always do?
Specifies the instruction to be performed
Holds an address related to where this data is stored
Holds a value which is related to the data on which the instruction is to be performed
It is a particular instance of a class
The register which holds the address of the location to or from which data are to be transferred is called
Index Register
Instruction Register
Memory Address Register
Memory Data Register
The register used as a working area in CPU is
Program Counter
Instruction Register
Instruction Decoder
Accumualtor
Which of the following register is used in the control unit of the CPU to indicate the next instruction which is to be executed ?
Accumulator
Index Register
Instruction Decoder
Program Counter
The function of program counter (PC) holds
Temporary
Address for Memory
memory Operand
Address of Instruction
Which of the following is not part of the CPU?
ALU
CU
MAR
ROM
The purpose of ROM is to...
Provide backup storage
Store application files
Acts as a fast type of memory for the CPU
Store the BIOS instructions
Volatile memory that runs the Operating System and other applications
Virtual Memory
Registers
RAM
ROM
Extremely fast memory that is built into the CPU. Used as temporary stores for data and instructions.
Cache Memory
Flash Memory
Registers
Virtual Memory
The computer uses the _________ to start the computer and launch the operating system
RAM
BIOS
HDD
DVD
Which statement best describes RAM?
Fast, permanent storage
Fast, volatile storage
Slow, volatile storage
Slow, permanent storage
What is usually held in the contents of RAM?
BIOS and Boot sequence needed to start the computer
Software programs stored within the computer
Operating System and currently running programs
Recently executed instructions in case they are needed again
The Control Unit
Controls the flow of data around the CPU and also decodes instructions
Only controls the flow of data around the CPU
Controls how much power is directed to all components within the computer
Only decodes instructions
What is the purpose of Cache?
Performs Arithmetic and Logical operations
Decodes and directs instructions to be carried out
Processes graphical functions
Stores frequently used data and instructions
Which of the following operating systems is free and open-source?
Windows
Mac OS X
Linux
UNIX
It uses the same physical memory address for instructions and data
Von Neumann Architecture
Harvard Architecture
It uses separate memory address for instructions and data
Von Neumann Architecture
Harvard Architecture
Simpler control unit design and development of one is cheaper and faster
Von Neumann Architecture
Harvard Architecture
Control unit for two buses is more complicated which adds to the development cost
Von Neumann Architecture
Harvard Architecture
Data transfers and instruction fetches cannot be performed simultaneously
Von Neumann Architecture
Harvard Architecture
Used in personal computers, laptops and workstations
Von Neumann Architecture
Harvard Architecture
Used in microcontrollers and signal processing
Von Neumann Architecture
Harvard Architecture
Physically large in size and require more silicon to make thus more expensive
CISC
RISC
Used in smartphones and tablets, based around ARM processor
CISC
RISC
Multiple machine cycles per instruction
CISC
RISC
Greater energy consumption
CISC
RISC
Smaller in size as less complex circuitry required, less silicon needed to make thus cheaper
CISC
RISC
Used in laptops and desktop computers, made by Intel or AMD
CISC
RISC
Has more complex hardware
CISC
RISC
Can support pipelining
CISC
RISC
Has simpler hardware
CISC
RISC
Cannot support pipelining
CISC
RISC
Uniform instruction format, using a single word with the opcode in the same bit positions in every instruction = easier decoding.
CISC
RISC
Which speed of CPU would process instructions the fastest?
2.4 GHz
1.2 MHz
48 KHz
1000 Hz
What is the speed of a CPU measured in?
Bytes
RAM
Hertz
Flops
Which of the following units of storage holds the most data?
Gigabyte
Kilobyte
Byte
Megabyte
GPUs ...
Are efficient at manipulating computer graphics and image processing
Can speed up edit render times
Can decrease render times of programs
Only manipulate computer graphics
GPUs are better than CPUs at ...
Processing commands such as basic word processing
Processing lots of smaller more efficient cores to handle multiple tasks simultaneously
Processing large blocks of visual data simultaneously (in parallel)
Processing lots of larger blocks of non visual data
A parallel system is ...
Where a process is split 2 parts, which are executed simultaneously on different processors attached to the same computer
Where a process is split into parts, which are executed simultaneously on the same processor attached to the same computer
Where a process is split into 2 parts, which are executed simultaneously on the same processor attached to the same computer
Where a process is split into parts, which are executed simultaneously on different processors attached to the same computer
What is ISR
Interrupt service Register
Interrupt Service Routine
Interrupt Stock Register
Round Robin
what is the main part of the operating system
user interface
kernel
system utilities
device drivers
True or False: Closed Source software is sold without usage restrictions
TRUE
FALSE
Which of the following is NOT a translator?
Assembler
Compiler
Interpreter
Executable
Original data ready to be encrypted is called
Plaintext
Ciphertext
Cipher
Key
Encrypted data is called
Plaintext
Ciphertext
Cipher
Key
Algorithms used to encrypt data is called
Plaintext
Ciphertext
Cipher
Key
Hashing is ...
The interception of a key that is used to decrypt data
The transformation of a string of characters into a fixed length value or key that represents the original input string
When data from a database is mismanaged
When minor changes in the original string can completely change the hash value
Hashing is ...
Changes data before it reaches the spreadsheet records to be compared to
Is very secure
Is not very secure
Changes data before it reaches the database records to be compared to
Hashing ...
Changes data before it reaches the spreadsheet records to be compared to
Never stores sensitive data as plain text
Is not very secure
Stops hackers being able to see data and they will only see the hashed values
SELECT title
FROM videogames
WHERE title LIKE '%2'
SELECT title
FROM videogames
WHERE title LIKE '4%'
Which of the following 2 options should be included in a conceptual data model?
Table names
Entity names
Entity Relationships
Attributes
Complete the sentence below.
A database that is a quality, effective & appropriate solution must be normalised to _____ normal form.
1st
2nd
3rd
4th
Normalisation is:
Removing all necessary data from a database
Organising a database to remove repeated entries and increase the accuracy of the data
Putting fields from different tables into one big database
Which of the following statements fully describes data in 2NF:
When any repeating fields have been removed and the table is given a primary key
When all repeating entries of data are removed and the fields in each table are directly related to the primary key and no fields are present that are not related to each other
When all the fields in each table are directly related to the primary key
An advantage of normalisation is:
The storage space needed for a normalised database is likely to be smaller
The process of normalising a database is very easy and doesn’t require any skill
It is possible to see previous details that have been changed, such as a customer’s address, as we can look back at an older entry
What is an atomic field?
A field that contains multiple items of data
A field that is repeated
A field that contains only one item of data
What is a foreign key?
A unique identifier in a database
A primary key of one table that appears in another table
A field that should not be in a table and needs removing
A relation is in 1NF if it doesn't contain any ____________?
Determinants
Repeating groups
Null values in primary key fields
Functional dependencies
A table is in 2NF if the table is in 1NF and what other condition is met?
There are no functional dependencies.
There are no null values in primary key fields.
There are no repeating groups.
There are no attributes that are not functionally dependent on the relation's primary key.
When you normalize a relation by breaking it into two smaller relations, what must you do to maintain data integrity?
Remove any functional dependencies from both relations
Assign both relations the same primary key field(s)
Create a primary key(s) for the new relation
Tables in ____ will perform suitably in business transactional databases.
0NF
1NF
2NF
3NF
A table in ____ contains no transitive dependencies.
1NF
2NF
3NF
none of the above
When is a table is said to be 3NF
Normalization improves performance by reducing redundancy.
If and only if it is in 2NF and every non key attribute is Non-transitively dependent on the primary key
It involves introduction of redundancy in data
None of the above
To remove a record from a table which SQL statement would you use?
Remove
Cancel
Delete
Eradicate
Which statement is used to extract data from a database?
Extract
Get
Open
Select
Less than or equal to?
>=
=>
=<
<=
Which word is missing from the following SQL statement?
Select * table_name
With
Where
From
And
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%’
SQL query to find all the cities whose humidity is 95.
SELECT city WHERE humidity = 95
SELECT city FROM weather WHERE humidity = 95
SELECT humidity = 89 FROM weather
SELECT city FROM weather
SQL query to find the temperature in increasing order of all cities.
SELECT city FROM weather ORDER BY temperature
SELECT city, temperature FROM weather
SELECT city, temperature FROM weather ORDER BY temperature
SELECT city, temperature FROM weather ORDER BY city
... states that database modifications must follow an “all or nothing” rule.
Consistency
Atomicity
Durability
Isolation
... states that only valid data will be written to the database.
Consistency
Atomicity
Durability
Isolation
... requires that multiple transactions occurring at the same time do not impact each other’s execution.
Consistency
Atomicity
Durability
Isolation
... ensures that any transaction committed to the database will not be lost.
Consistency
Atomicity
Durability
Isolation
5.23 would be stored as:
Integer
Real Number
String
Character
Boolean
What is an integer?
A number
A positive number
A whole number
A number with a decimal part
Which of these cannot be accurately stored as a floating point number?
1/8
2/3
4.00000000000000000001
4/4
17/9
Which one of these binary numbers is the normalised form of 6.5?
6.5 = 00000110.1
0.1011 0011
0.1101 0011
1.1001 0010
1.1010 1010
What does the number 10000001 represent when using two’s complement form?
1
-1
-127
-128
How would -22 be represented with 6-bits in sign and magnitude form?
010110
110110
101010
10010110
101110
What is the major advantage of using Unicode over ASCII?
It uses up more memory
It can represent more characters
It sounds much cooler
67
What value do you get when you use 00110001 as an XOR on the value 01101101?
01111100
01011100
01010110
01101101
Write out the Boolean expression for this Karnaugh Map
A^¬B
A^B
¬A^¬B
¬A^B
Write out the Boolean expression for this Karnaugh Map
¬A^¬B
A^¬B
¬A^B
A^B
Identify the correct expression for this Karnaugh Map
A v ¬B
A ^ ¬B
A ^ B
A v B
Select the simplest expression for this Karnaugh Map
B ^ ¬ D v A ^ ¬ B
A v B ^ ¬ D
Identify the correct expression for this Karnaugh Map
A ^ ¬ B v C ^ D
A ^ B v C ^ ¬ D
Identify the correct simplified expression using this Karnaugh Map
¬A^B v A^C
A v ¬B^C
What type of logic gate is this table showing?
AND
OR
NOT
What type of logic is this table showing:
AND
OR
NOR
XOR
Which logic gate is represented by this truth table?
Which truth table is correct for this logic gate?
"The burglar alarm will go off if either the door or the window or both are opened". This is an example of which type of Logic?
AND
OR
NOT
NOR
Determine the output expression for output X if given
A =1
B = 0
C = 1
X= 0
X= 1
What will the circuit's output be?
1
0
Which of the following shows the commutative law?
A
B
C
D
E
Which of the following shows the associative law?
A
B
C
D
E
Which of the following shows the absorption law?
A
B
C
D
E
Which of the following shows the distributive law?
A
B
C
D
E
Which of the following shows the De Morgan’s law?
A
B
C
D
E
When adding two binary numbers, which logic gate is used to calculate the carry bit?
an AND gate
an OR gate
a NAND gate
an XOR gate
In a full adder, which logic gate is used to check if either one of the carry bits is true?
an OR gate
an AND gate
an XOR gate
a NAND gate
Which logic gate almost exactly describes the addition of two binary numbers (for sum)?
an AND gate
a NOR gate
a NAND gate
an XOR gate
The circuit that sums A and B, and has two outputs, sum (S) and carry (C), is called ___
a half adder
a full adder
a simple summer
a digital combiner
A digital circuit that sums two numbers, and includes a carry bit (C) as input is called ___
a half adder
a full adder
a partial compiler
a complete compiler
Latches are used to
store single bit
store 2 bits
store 1 byte
none of the above
Which is a circuit that can be used to store the value of a single binary digit?
Half adder
Full adder
D-type flip-flop
