Font size
WorksheetsNat5- Computing 2018 Paper Revision
Total questions: 32
Worksheet time: 21mins
Which of the following is NOT an example of effective user-interface design?
Position of navigational links
Consistent style across multiple pages
Using lots of different colours to increase user satisfaction
Using appropriate file formats for media files.
What is the purpose of a wireframe?
Helps to navigate the website
To design the layout of the software
To allow the user to test the usability of the website
To To design usability tests using porotyping
Select the correct answer:
Internal hyperlinks: take you from one web page to another in the same website. External hyperlinks: take you from one web page to another in a different website.
Internal hyperlinks: take you from one web page to another in the different website. External hyperlinks: take you from one web page to another in a different website.
Internal hyperlinks: take you from one web page to another in the same website. External hyperlinks: take you from one web page to another in a same website.
Internal hyperlinks: take you from one web page to another in the different website. External hyperlinks: take you from one web page to another in a same website.
Which of the following standard file formats allows you to create an animation?
WAV
GIF
PNG
JPEG
Why is compression important?
To increase transmission speeds.
To reduce bit depth.
To reduce file sizes so that transmission speed is slowed.
To allow lossy compression to remove extra data.
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">
Which tag is missing from the html code above?
<item>__</item>
<li>__</li>
<ol>__</ol>
<i>__</i>
What does CSS allow you to do?
Change the content of a web page.
Add design notations to a web page.
Change the style of a web page.
Add interactivity to the web page.
Which data type can only hold True or False
Boolean
Integer
Real
Single
Select all Standard Algorithms for National 5
Traversing a 1D Array
Input Validation
Running Total Within a Loop
Conditional Statement
Which component carries data to and from Main Memory
Control Unit
Registers
Address Bus
Data Bus
Which component is temporary storage inside the processor?
Control Unit
Registers
ALU
RAM
Floating point representation stores real numbers in binary using...
mantissa and exponent
vector and exponent
mantissa and resolution
vector and resolution
What is a logic error?
The program won't run as the mistake in the code breaks the rules of the programming language
The program runs but in testing it produces the wrong result
The program runs but then crashes while running
The program created doesn't match the design
Which file type for sound uses lossy compression?
MP3
WAV
RAW
JPG
Select the correct SQL statement to add a new record for Mr Alford to the Teacher table
SELECT * FROM Teacher WHERE Title="Mr" AND Surname="Alford";
INSERT INTO Teacher (Title, Surname) VALUES ("Mr","Alford");
INSERT (Title, Surname) VALUES ("Mr","Alford") INTO Teacher;
INSERT (Title, Surname) VALUES ("Mr","Alford") FROM Teacher;
Select the correct CSS rules to ensure all the text in paragraphs is blue
P { color: blue; }
P { colour: blue; }
P { text-color: blue; }
P { font-colour: blue };
Vector Graphics store...
A colour code for every pixel
Objects and attributes as text
Animation and transparency
Thumbnails
Increasing the resolution of a graphic will
Increase file size and increase quality
Increase file size and decrease quality
Decrease file size and increase quality
Decrease file size and decrease quality
Select all advantages of compressing a graphic to be shown on a web page
Takes up less space on the server
Takes less time to transfer over a network
Takes up less screen area
Is easier to read/see
Which validation would be added to a database field to ensure data is entered in that field?
Range Check
Presence Check
Length Check
Restricted Choice
What is a parameter in a predefined function?
Data that is sent into the function to allow it to do it's job
An error that stops the function from working
Details from the creator on what the function does
A subprogram called by an event
Which law protects individuals' personal data?
GDPR (General Data Protection Regulation)
The Copyright, Designs and Patents Act
The Computer Misuse Act
The Communications Act
The Regulation of Investigatory Powers Act
What piece of legislation protects copyrighted works?
European Union (Withdrawal) Act 2019
Copyright Designs and Patents Act 1988
Communications Act 2003
Official Secrets Act 1989
What SQL query deletes "Xi Jinping" from the table "mass_surveillance"
DELETE FROM mass_surveillance WHERE name="Xi Jinping";
DELETE "Xi Jinping" FROM table="mass_surveillance";
UPDATE "mass_surveillance" SET name=" " WHERE name="Xi Jinping";
What does the ADDRESS BUS do?
Carries Data one way from the CPU to the Registers.
Carries address information from processor to
main memory. One direction only.
Carries adress information from processor to
main memory. One direction only.
Carries address information from processor to
main memory, both ways.
In "1.2984x10^-6", what is the mantissa?
-6
1
1.2984
.2984
What legislation protects personal information in databases?
European Union (Withdrawl) Act 2019
Data Protection Act 1998
General Data Protection Regulation 2016/679
Directive (EU) 2019/790
What does an equi-join do?
An equi-join does not exist in databases.
Exists so that a SQL statement can use relationships in 1 table
Exists so that a SQL statement can incorporate the relationship between two tables
Exists so that a SQL statement can contact the The Communist's Party, Ministry of State Security to ensure that the SARS virus is not in any database
What do you have to do to show copyrighted works on your website?
Include credits somewhere in the website?
Use the content anyways and claim free use.
Ask for the copyright holder's permission.
Move to China where copyright laws does not exist.
Convert 187 to binary
1001 0101
1011 1001
1011 1011
1011 1000
What is the exponent of this number? 1.2984x10^-6
-6
1.2984
x10^-6
1
