WorksheetsGeneral Revision
Total questions: 50
Worksheet time: 32mins
What is referential integrity?
When the primary key is different from the foreign key and no changes are applied to either
When the foreign key is similar to the primary key any changes are just applied to the foreign key
When the primary key and the foreign key are the same and any changes are applied to both keys
Select the correct parts of the CPU (Multiple answers)
Control Unit
Address Bus
ALU
Registers
What is 76 converted into Binary?
01001100
00110011
01001111
01001101
What is the purpose of JavaScript in a web page?
For fun
To add interactivity to a web page
To make the web page look better
To make the web page more interesting
Which of the following units of storage are smaller than an Megabyte?
Bit
Kilobyte
Terabyte
Gigabyte
What kind of validation fits this description: Limiting what the user can enter
Presence Check
Field Length Check
Restricted Choice
What will this SQL statement do? SELECT username, activetime FROM userdetails WHERE online = 'TRUE';
It will show all information from current online players
It will show the username of any user who's played for longer than 50 mins
It will show the username and amount of time they've been active of any user that is currently online
It will show the username and amount of time they've been active of any user that is currently not online
What bit depth does JPEG use?
24 bits, providing over 16 million colours
8 bits, providing 256 colours
What would this CSS show?
p{ text-align: left;
color: Blue;
font-size: 18px;
Align paragraph text to the left
Set the font colour to Blue
Set the background colour to blue
Set the font size to 18
Align all text to the left
Which of these statements is true when describing an Interpreter? (Multiple Answers)
It translates statements while it executes the program, making it slow
Interpreted code requires less memory than complied code
Interpreter will run until it finds an error
Interpreter is very complicated
The address bus...
is used to carry data from a memory location to the processor and vice versa
is used to send out signals to initiate events
is used to specify which memory location is to be used to read or write data to
Which of these is are ways to improve the readability of your code? (Multiple Answers)
Meaningful variable names
Indentations
Internal Commentary
White Space
Which audio file uses lossless compression but has larger file sizes?
MP3
WAV
Which one of these graphics files is Lossless and therefore keeps its quality?
PNG
GIF
JPEG
What field type would be used to store the following data "0125-5221"
Text
Number
Time/Date
What kind of hyperlink takes you to another page on another website?
Internal Link
Exit Link
External Link
Inside Link
Lossy compression means? (Two answers)
The file will not return to original quality
The file size will remain smaller than the original
The file will return to original quality
The file is deleted
What is the purpose of a wireframe?
To design the layout of the website
To design the layout of a web page
To allow the user to test the usability of the website
To To design usability tests using porotyping
The type of addressing shown in the href attribute is:
Absolute Addressing
Relative Addressing
Domain Addressing
URL Addressing
Which of the following examples shows the correct way to display an image on a web page?
<source src=""filename.jpg" alt="A Picture"></source>
<image src="filename.jpg" alt="A Picture">
<img src="filename.jpg" alt="A Picture">
<file src="filename.jpg" alt="A Picture">
p {color: red;}
Which of the following has the highest priority in a HTML document?
Inline CSS
Internal CSS
External CSS
Describe what will happen when this code is run
Text will change to Goodbye when the mouse is over it then change back to Hello when the mouse isn't over it
Text will change to Hello when the mouse is over it then to Goodbye when the mouse isn't over it
Text will display Goodbye when the page is loaded
Describe how a website is evaluated
If the website meets the functional and end user requirements it is fit for purpose
If the website looks nice it is fit for purpose
If the website runs without error it is fit for purpose
If the website is design and developed as quickly as possible it is fit for purpose
You are a writing a program to add up the total cost of all the items in a shopping cart. State the standard algorithm you should use?
Running Total
Traversing an array
Input Validation
What kind of design technique is being shown?
Psuedocode
Flowchart
Structure Diagram
You are a writing a program to add up the total cost of all the items in a shopping cart. State the standard algorithm you should use?
Running Total
Traversing an array
Input Validation
State the result from the following program:
number = 7.89321
MsgBox("Number is " & Math.Round(num))
7.8932
7
8
What kind of design notation is shown above?
Flowchart Chart
Structure Diagram
Pseudocode
Decomposition Diagram
What kind of error is this?
Syntax
Logic
Execution
What makes a program Fit For Purpose
The program meets the requirements stated in the analysis stage
The program works
The program doesn't crash
The program has all the right variable names
What is a flat file database?
A database that consists of one large table with repeated data
A database that uses more than one table that are linked together
A database that is empty
A database that only contains information about flat things
What does SQL stand for?
Structured Query Lines
Structured Quandaries Language
Sand Quack Linguine
Structured Query Language
Identify two ways to save power when using a computer
Just don't use one
Adjust the monitor brightness
Use sleep mode or power settings if not used after a period of time
Throw it out the window after use
How is a bit-map graphic stored?
In a grid of object and attributes
In a grid of pixels
In a grid of pixels where the colour is also stored as text
In a grid of pixels where each pixel is stored as a binary number to represent the colour of the pixel
How is a vector graphic stored?
Each pixel is stored as a binary number
As a collection of objects
As a collection of objects with the attributes of each object stored
Each pixel is stored as a binary number in a grid of pixels.
How is an image represented in a wireframe?
What kind of cardinality is displayed here?
One to one
One to many
Many to many
How is a primary key indicated in an ER Diagram?
The field name is underlined
The field name has an asterisk
You just have to guess
How is a foreign key indicated in an ER Diagram?
The field name is underlined
The field name has an asterisk
You just have to guess
How would you write internal CSS?
Have CSS in a different file from your HTML
Have CSS in line with the elements in HTML
Have CSS in a <style> within the <head> in HTML
Explain the purpose of prototyping in web design
To demonstrate user interaction
To demonstrate the navigation of the website
Just to look at the website
To try the design
Identify which code below correctly defines an array of strings with a length of 15
Dim array As Integer
array = 15
Dim array() 15 As Integer
Dim array(15) As Integer
Dim array * 15 As Integer
Describe the term Iterative Development
Repeating a phase of development like going from Testing stage back to the Implementation stage to correct the code
Double checking your work to make sure it is right before moving on
Using loops in your program
Doing all the work again because the file got deleted
Identify the three things that are outlined in the functional requirements (three answers)
Inputs
Coding Language
Processes
Outputs
Hardware Required
What would the output be in the age was set at 18?
You are too young to attend the dance
You can attend the dance
You are too old to attend the dance
If an SQL query is displaying all the fields correctly but is showing some records that don't meet the criteria it is said to be?
Not fit for purpose
Not accurate
Fit for purpose
Accurate
Which is the correct UPDATE statement to update this address ( 99 Willow Way ) in a Staff table of the staff member with the code DD56
UPDATE Staff
SET address = "99 Willow Way"
WHERE staffCode = "DD56"
SET address = " 99 Willow Way"
WHERE staffCode = "DD56"
UPDATE Staff
WHERE staffCode = "DD56"
UPDATE Staff
SET address = "99 Willow Way"
Which of the following standard file formats allows you to create an animation?
WAV
GIF
PNG
JPEG
