WorksheetsY13 Mock prep (epic 75 questions)
Total questions: 75
Worksheet time: 1hrs 9mins
What is record locking?
Preventing a record from being changed while it is being used by a transaction
A security measure to protect records from unauthorized access
Permanently deleting a record
Copying records to another location
In a hospital system, the relationship between a nurse to a ward would be:
One-to-One
One-to-Many
Many-to-Many
Many-to-One
In a hospital system, the relationship between a patient to a surgeon would be:
One-to-One
One-to-Many
Many-to-Many
Many-to-One
A primary key is...
A unique identifier for each record
An identifier which can be shared between multiple records
The first number in the record
A way of looking up data in related tables
A foreign key is...
A unique identifier which links a record to a related record in another table
A unique identifier for each record in a table
A shared identifier for all records in one table
What is the primary key?
Sales ID
Item ID
Item Name
Address
Payment Complete?
Which field is likely to be a foreign key?
Sales ID
Item ID
Item Name
Address
Payment Complete?
Is this table in first normal form?
Yes
No
Don't Know
Is this table in first normal form?
Yes
No
Don't Know
Is this table in second normal form?
Yes
No
Don't Know
What normal form is this table in?
1NF
2NF
3NF
What does ACID stand for in database transactions?
Atomicity, Connectivity, Isolation, Durability
Accuracy, Consistency, Integrity, Durability
Accuracy, Consistency, Isolation, Diversity
Atomicity, Consistency, Isolation, Durability
What is a database?
A programming language
A type of computer
An organized collection of data
A web browser
What is a secondary key?
A duplicate of the foreign key
A backup primary key
A key used for secondary storage
A field indexed for search purposes
What is a flat file database?
A database with a single table
A database optimized for flat data
A database without any relationships
A database stored on a flat disk
What does a hashing function do?
Decompresses data files
Transforms a string of characters into a fixed length value
Translates one programming language into another
Encrypts data into an unreadable format
What happens if even a slight change is made to the original message in hashing?
It produces a totally different hash value
The hash value remains unchanged
The change is ignored by the hashing function
It results in an error
How is hashing different from other encryption techniques?
Hashing requires a key to decrypt
Hashing can easily be reversed
Hashing is slower than encryption
Hashing is a one-way process
Why is hashing ideal for storing passwords?
It makes passwords easier to remember
It reduces the size of the password
It prevents passwords from being read by hackers
It encrypts the password into a readable format
Which html tag defines a numbered list
(a)
which html tag defines an individual list entry (whether ordered or unordered)
(a)
is this CSS
inline
internal
external
will the background colour on the section of the webpage with #page style applied to it be predominantly
red
green
blue
this is an example of a CSS (a)
how many times has that class been applied to this page?
(a)
what's the name of the external css file here?
(a)
A Parent or Super Class is...
A class about children
A class which other classes can inherit functionality from
A class which other classes can inherit members from
A private class
Which methodology is a risk-driven software development process?
Waterfall
Rapid Application Development
Spiral
Agile
Which methodology focuses on producing successive prototypes?
Waterfall
Rapid Application Development
Spiral
Agile
Which methodology emphasizes building each iteration in a sprint cycle?
Waterfall
Rapid Application Development
Spiral
Agile
Which methodology aims to produce high-quality code and promote developers' quality of life?
Waterfall
Rapid Application Development
Spiral
Extreme Programming
What is an embedded operating system?
Built into a particular device
Used for multiple users
Used for real-time processing
Used for scheduling tasks
What is the first come first served scheduling algorithm?
Executes the shortest job first
Executes each process in the order it arrives
Executes the process with the shortest remaining time
Executes processes based on priority
What is multi-level feedback queues used for?
To manage user accounts
To split processes into different queues
To execute commands with little delay
To simulate another computer system
The operating system is responsible for device _____________: the management of all _____________, such as I/O devices and graphics cards (including storage devices).
management, devices.
power, expectation
Peripherals are ..............
is physical parts that make your computer. Usually used to take input, store data, display output and execute commands.
are pieces of hardware that are added to a computer to expand its abilities and to work more efficiently.
It is used to put information into and get information out of the computer.
Example: Keyboard and motherboard
Example: printer and scanner
Which operating system type is crucial for applications that require immediate processing and response?
Multi-tasking operating system
Real-time operating system
Distributed operating system
Embedded operating system
What is the main function of a multi-tasking operating system?
To allow multiple users to access the system
To run multiple applications simultaneously
To process data in real-time
To manage network resources
Which type of operating system is most suitable for a network of computers that need to work together?
Multi-user operating system
Distributed operating system
Real-time operating system
Embedded operating system
Which scheduling algorithm assigns a fixed time slice to each task?
First Come First Served (FCFS)
Shortest Job First (SJF)
Round Robin
Multi-Level Feedback Queue
What is an interrupt in the context of an operating system?
A request for immediate attention from the processor
A type of keyboard input
A method for processing long tasks
A device driver
What can cause a processor to be interrupted?
A change in the computer's color scheme
Completion of a long-running process
A request for immediate attention from a hardware device
An increase in the processor's speed
OOP term "a blueprint for an object"
(a)
text files
image files that need to remain high quality
Reorder the following
Checks for interrupts after FDE cycle finishes
If interrupt places next FDE cycles on a stack in memory
Loads in the ISR
Completes all the FDE cycles for the ISR
If no further interrupts reloads the FDE cycles back into memory
Match the following
Equal time slice per job
Round robin
Looks at the job with the shortest job and processes that first
SJF
Looks at the job with the shortest time left which can jump the queue
STR
Has different queues for various priorities
Multi-level feedback
Goes to the first job that comes into the processor
FCFS
CD
DVD
Internal hard drive
Blu-ray
Solid-state drive
Magnetic tape
Floppy disk
USB
SD card
What is a stack?
A data structure that adds the last added data item.
A data structure that increases data items first.
Data structure that removes the last added data item first
A data structure that multiplies data items
What two operations do stacks require?
Push
Draw
Stretch
Drag
Pop
What operation adds a new item onto the top of the stack?
Pull
Push
Add
Multiply
What operation removes the item from the top of the stack
Pull
Add
Pop
Subtract
If you have a stack containing 'A' 'D' 'G' . What will happen if you push 'C' into the stack?
'C' Will be added on top of the stack
'C' Will be added from the bottom of the stack
'C' Will be removed from the stack
'C' Will not be added to the stack
If you carry out a pop operation on this stack what will you be left with?
What will happen if you carry out a push operation with the word 'Bill'?
A queue is a first in, ________ data structure.
Last in
Last out
First out
All of the above
What will the stack contain after the following actions?
Push(1);
Push(2);
Push(3);
Push(4);
Pop();
Pop();
Push(5);
1, 2, 3
1, 2, 3, 5
1, 2, 3, 4, 5
1, 2, 5
Which of the following is LIFO?
Stack
Linked List
Queue
Inverse Queue
Which registers hold and transfer data or instructions?
Accumulator
MDR
MAR
PC
CIR
Which registers hold and transfer the memory addresses of data or instructions?
Accumulator
MDR
MAR
PC
CIR
What parallel processing technique does the following image describe?
Pipelining
Multi-Tasking
Multi-Threading
Cache
Which of these is an advantage of RFID?
Less expensive than Bar code
Doesn't need line of sight to scan
Less Durable
More interesting than Bar Code
This methodology is:
XP
Agile
Waterfall
Spiral
RAD
This methodology is:
XP
Agile
Waterfall
Spiral
RAD
A small start-up who want to get a prototype onto the market for testing should use:
XP
Agile
Waterfall
Spiral
RAD
Organize these options into the right categories
Car braking system
Medical monitoring system
Flight control system
Robotic surgery system
What type of compression would be used on this image?
(a)
What is this diagram showing?
(a)
What is being illustrated here?
(a)
Organize these options into the right categories
Splits data up, travels different routes
No wasted bandwidth
Wastes bandwidth
Dedicated path for data travel
Allows for dynamic routing
Data packets can arrive out of order
Scalable for large networks
Connection is established before data transfer
Fixed bandwidth allocation
Lower latency for continuous data streams
More reliable for voice communication
Organize these options into the right categories
<b>
<img src>
inline
<a href>
<div>
<h1>
internal
external
Skeleton structure of a webpage
Adds a presentation layer
Adds behaviour and interactivity to webpages
body {background-color: blue}
