Font size
S
M
L
XL
WorksheetsYear_8_revision_questions
Total questions: 88
Worksheet time: 1hrs 11mins
Name
Class
Date
1.
What does HTML stand for?
a)
Hypertext Medium Language
b)
Hippo Tries Making Licorice
c)
Hypertext Markup Lingo
d)
Hypertext Markup Language
2.
You should save HTML files with which file extension?
a)
.htm
b)
.index
c)
.webpage
d)
.html
3.
If you wanted to add links to your web page - what tag would you use?
a)
<a>
b)
<p>
c)
<div>
d)
<link>
4.
the tag <IMG> would insert what into a web page?
a)
Insert a title
b)
Insert a link
c)
Insert an image
5.
What will happen to the text in blue? <p>He named his car <i>The lightning</i>, because it was very fast.</p>
a)
the content will be displayed in italic
b)
the content will display an image
c)
the content defines text inserted into a document
6.
What is will the highlighted tag do? <p>My favourite colour is blue<br>I support Southend United.
</p>
</p>
a)
it will make the text bold
b)
it will place the text on another line
7.
What coding would be used to define a header cell in an HTML table
a)
<th>Month</th>
b)
<td>Month</td>
c)
<h1>Month</h1>
d)
<h2>Month</h2>
8.
CSS stands for?
a)
Closed Source Style
b)
Crucial Style Sheets
c)
Cascading Style Sheets
d)
Corresponding Static Style
9.
Which code will make your background red?
a)
<body style=background-color:red;>
b)
<body style="background-color:yellow;">
c)
<body style="background-color:red;">
d)
<body colormybg="background-color:red;">
10.
HTML stands for?
a)
HammersTend To Mostly Lose
b)
HypoText Madeup Language
c)
HyperText Markup Langauge
11.
Which format usually works best for photos?
a)
JPEG
b)
DOC
c)
GIF
d)
WAV
12.
What does the <p> tag do?
a)
Creates preformatted text
b)
places a picture in the website
c)
creates a paragraph break
13.
What will happen to the content in blue?<p>This is a spelling mistake <u>parragraph</u> .<p/>
a)
it will be in bold
b)
it will be underlined
c)
it will be in italics
14.
Which word is not used in HTML structure?
a)
footer
b)
body
c)
head
d)
arm
15.
what does the following tag do <div>
a)
defines a division or a section in an HTML document
b)
defines all the divas in the classroom
16.
Which is NOT a web browser?
a)
Chrome
b)
Internet explorer
c)
FireFox
d)
Yahoo
17.
which tag will create the largest heading
a)
<h6>
b)
<h4>
c)
<h2>
d)
<h3>
18.
What does the <HTML> tag tell the browser
a)
that it is an HTML document
b)
defines the documents body
c)
that it contains all the head elements
19.
How would you centre a H2 heading?
a)
<h1 align="center">
b)
<h2 stickit="center">
c)
<h2 align=center>
d)
<h2 align="center">
20.
Which section is used for text and tags?
a)
Arm
b)
Body
c)
Footer
d)
Head
21.
What best describes CSS
a)
describes how HTML elements are displayed on screen
b)
To logically divide the document
22.
What best describes web authoring software?
a)
it creates HTML code to make web pages.
b)
It is used to view web pages
23.
What best describes an ASSET
a)
an object on a web page (image, video, etc.)
b)
Helps add links to web pages
24.
HTML Language uses
a)
Tabs
b)
Tags
c)
Punctuation
d)
Quotations
25.
A <tag>
a)
Is used to divide sections
b)
Is not needed in HTML
c)
Tells the browser how to format our content
d)
Is part of the title line in HTML
26.
<h> is
a)
Header Tag
b)
Headline Tag
c)
Half of a tag
d)
Closing header tag
27.
</h> is
a)
Header Tag
b)
Headline Tag
c)
Half of a tag
d)
Closing header tag
28.
Style tags are used to;
a)
Apply style to one line
b)
Not used in HTML
c)
Used at the top of the page to apply a style to the entire document
d)
Used sparingly
29.
An attribute is a;
a)
Applies changes to everything
b)
Different options for each tag
c)
Allows for no changes to the site
d)
Gives structure and text
30.
The content of the web (such as your pictures, text, links) will show up here.
a)
Head
b)
Body
c)
Style
d)
Folder
31.
Where is JavaScript used?
a)
In a web page, for the browser to run to make the page interactive.
b)
On a web server, for the server to respond to browser requests
c)
On web browser to draw shapes and animations
d)
ALL of these answers are correct
32.
How do you terminate each line of statement in JavaScript?
a)
Use a semicolon ;
b)
Use a curly brace }
c)
Use a full stop .
d)
Use a colon :
33.
It allows your program to make correct decisions and perform right actions
a)
Decision Statement
b)
Conditional Statement
c)
Agreement
d)
True or False Statement
34.
Why do we write functions?
a)
Make our code easier to understand
b)
Avoid writing repeated code
c)
Make our code reusable
d)
All of these
35.
What statement can we use inside of a loop to end it?
a)
println
b)
break
c)
stop
d)
else
36.
What type of variable is
var numApples = 2;
var numApples = 2;
a)
Int
b)
Float
c)
Boolean
d)
String
37.
What type of variable is
var costOfApples = 3.6;
var costOfApples = 3.6;
a)
Int
b)
Float
c)
Boolean
d)
String
38.
What type of variable is
var typeOfApples="Fuji";
var typeOfApples="Fuji";
a)
Int
b)
Float
c)
Boolean
d)
String
39.
What type of variable is
var age = "5"
var age = "5"
a)
Int
b)
Float
c)
Boolean
d)
String
40.
What type of variable is
var needBushel = false
var needBushel = false
a)
Int
b)
Float
c)
Boolean
d)
String
41.
The following variable is a legal name:
var _privateVariable;
var _privateVariable;
a)
True
b)
False
42.
The following variable is a legal name:
var $specialVariable;
var $specialVariable;
a)
True
b)
False
43.
The following variable is a legal name:
var variable;
var variable;
a)
True
b)
False
44.
The following variable is a legal name:
var 2ballLocation;
var 2ballLocation;
a)
True
b)
False
45.
The following variable is a legal name:
var DONT_CHANGE_VALUE;
var DONT_CHANGE_VALUE;
a)
True
b)
False
46.
The following variable is a legal name:
var student Age;
var student Age;
a)
True
b)
False
47.
The following variable is a legal and valid name:
var stuff;
var stuff;
a)
True
b)
False
48.
A variable's name should describe what the variable is used for or what it stands for.
a)
True
b)
False
49.
Which of the following is not a kind of variable.
a)
if statement
b)
boolean
c)
number
d)
string
50.
What is 9 % 2
a)
4.5
b)
1
c)
9
d)
2
51.
Variables p and q can be true or false:
If p is true and q is true,
p && q would equal
If p is true and q is true,
p && q would equal
a)
True
b)
False
52.
Variables p and q can be true or false.
If p is true and q is false,
p && q would equal
If p is true and q is false,
p && q would equal
a)
True
b)
False
53.
Variables p and q can be true or false.
If p is false and q is true,
p && q would equal
If p is false and q is true,
p && q would equal
a)
True
b)
False
54.
Variables p and q can be true or false.
If p is true and q is true,
p || q would equal
If p is true and q is true,
p || q would equal
a)
True
b)
False
55.
Variable p an be true or false.
If p is false, then !p is
If p is false, then !p is
a)
True
b)
False
56.
Analyze the following data:
var a = 3;
var b = 5;
var c = 2;
var d = 3;
var u = a == d;
var a = 3;
var b = 5;
var c = 2;
var d = 3;
var u = a == d;
a)
True
b)
False
57.
Analyze the following data:
var a = 3;
var b = 5;
var c = 2;
var d = 3;
var v = d >= b;
var a = 3;
var b = 5;
var c = 2;
var d = 3;
var v = d >= b;
a)
True
b)
False
58.
Analyze the following data:
var a = 3;
var b = 5;
var c = 2;
var d = 3;
var t = a > 0;
var a = 3;
var b = 5;
var c = 2;
var d = 3;
var t = a > 0;
a)
True
b)
False
59.
What does SQL stand for?
a)
Structured Query Language
b)
Structured Question Language
c)
Strong Question Language
d)
Strong Query Language
60.
Which SQL statement is used to extract data from a database?
a)
OPEN
b)
GET
c)
EXTRACT
d)
SELECT
61.
Which SQL statement is used to update data in a database?
a)
MODIFY
b)
SAVE AS
c)
UPDATE
d)
SAVE
62.
Which SQL statement is used to insert new data in a database?
a)
ADD NEW
b)
ADD RECORD
c)
INSERT NEW
d)
INSERT INTO
63.
With SQL, how do you select all the columns from a table named "Persons"?
a)
SELECT [all] FROM Persons
b)
SELECT *.Persons
c)
SELECT * FROM Persons
d)
SELECT Persons
64.
With SQL, how can you insert a new record into the "Persons" table?
a)
INSERT INTO Persons VALUES ('Ahmed');
b)
INSERT VALUES ('Ahmed') INTO Persons;
c)
INSERT ('Ahmed') INTO Persons;
d)
INSERT VALUES INTO ('AHMED');
65.
What word is missing from the line below?
SELECT *
_______ CUSTOMER;
SELECT *
_______ CUSTOMER;
a)
FROM
b)
WHERE
c)
SELECT
d)
ORDER BY
66.
What is the purpose of *?
a)
Selects ALL fields from the table
b)
Selects only the first field in the table
c)
Selects the last field in the table
d)
Shows only the first row in the table
67.
Return only the customers who have ER anywhere in their last name.
a)
last_name LIKE "%er%"
b)
last_name = "%er"
c)
last_name = "%er%"
d)
last_name LIKE "%er"
68.
To find the total dollar value of sales, use which?
a)
SUM
b)
COUNT
c)
MAX
d)
MIN
69.
AVG, COUNT, MAX, MIN and SUM are known as what?
a)
Aggregate functions
b)
Wildcard filters
c)
Subqueries
d)
Calculated field
70.
You must always use _____ when filtering string values.
a)
quotes
b)
astericks
c)
exclamation point
d)
percent signs
71.
What is the correct order of clauses?
a)
SELECT, FROM, ORDER BY, WHERE
b)
SELECT, FROM, WHERE, ORDER BY
c)
SELECT, WHERE, FROM, ORDER BY
d)
WHERE, FROM, SELECT, ORDER BY
72.
Use what to separate multiple table names in the FROM clause?
a)
commas
b)
periods
c)
spaces
d)
semicolons
73.
To join a table, connect the ___________ of one table to the ___________ of the other.
a)
primary key, foreign key
b)
group by clause, primary key
c)
filtered by, foreign key
d)
aggregate function, where clause
74.
Which clause allows you to SORT data?
a)
ORDER BY
b)
WHERE
c)
FROM
d)
HAVING
75.
When you select data from 2 tables, you are creating a ________.
a)
JOIN
b)
PRIMARY KEY
c)
FOREIGN KEY
d)
INDEX
76.
What happens if you forget to join two tables together using a WHERE clause?
a)
CREATE CARTESIAN PRODUCT
b)
GET A SYNTAX ERROR
c)
0 RECORDS RETURNED
d)
DELETE ALL
77.
True/False?
SQL table names are case sensitive
SQL table names are case sensitive
a)
True
b)
False
78.
How do you fix an ambiguous error in your SQL statement?
a)
Use long form of field name
b)
Remove that field name from the query
c)
Require unique fieldnames for all
d)
No such thing as ambiguous error
79.
Use which clause to FILTER data?
a)
WHERE
b)
ORDER BY
c)
FROM
d)
HAVING
80.
What represents no value?
a)
NULL
b)
" "
c)
0
d)
N/A
81.
SELECT MAX(price)
FROM PRODUCT
will return how many rows?
FROM PRODUCT
will return how many rows?
a)
1
b)
0
c)
2
d)
As many rows that are in the table
82.
Which word allows you to add more than one filter to a SQL query?
a)
AND
b)
BETWEEN
c)
LIKE
d)
EQUALS
83.
To return strings that match a wildcard value, use which word in your filter?
a)
LIKE
b)
EQUALS
c)
BETWEEN
d)
SEARCH
84.
Use what to remove spaces from the beginning and end of the string value?
a)
TRIM
b)
CROP
c)
NOSPACE
d)
SPACE
85.
A column in a database
a)
record
b)
row
c)
field
d)
data
86.
Return all dramas made after 2004.
a)
SELECT * FROM movies WHERE genre = 'drama';
b)
SELECT * FROM movies WHERE genre = 'drama' AND year > 2004;
c)
SELECT * FROM movies WHERE genre = "drama' AND year < 2004;
d)
SELECT * FROM movies WHERE imdb_rating = 7 AND LIMIT = 7
87.
Return the name and genre of each movie with an imdb_rating greater than 5 and year greater than 2012.
a)
SELECT * FROM movies WHERE imdb_rating > 5 AND year > 2012;
b)
SELECT name, genre FROM movies WHERE imdb_rating < 5 AND year < 2012;
c)
SELECT name, year FROM movies WHERE imdb_rating > 5 year > 2012;
d)
SELECT name, genre FROM movies WHERE imdb_rating > 5 AND year > 2012;
88.
What is a special value in SQL that represents missing or unknown data?
a)
%
b)
?
c)
NULL
d)
*
Reset
