wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Year 11 Pre Test Hangman Technical Proposal Dataset

Total questions: 50

Worksheet time: 40mins

Name
Class
Date
1.

What does "SQL" stand for?

a)

Structured Question Language

b)

Structured Query Language

c)

Simple Query Language

d)

Simple Question Language

2.

Which statement is used to extract data from a database?

a)

Extract

b)

Get

c)

Open

d)

Select

3.

Which statement allows us to add a record to a table?

a)

Add To

b)

Update To

c)

Add Into

d)

Insert Into

4.

Less than or equal to?

a)

>=

b)

=>

c)

=<

d)

<=

5.

Which character returns all the data found in a table?

a)

%

b)

#

c)

*

d)

/

6.

What does SQL stand for?

a)

Standard Query Language

b)

Sequential Query Language

c)

Structured Question Language

d)

Structured Query Language

7.

Which symbol would you use to represent more than 50

a)

= 50

b)

< 50

c)

> 50

d)

# 50

8.
Which SQL statement is used to insert new data in a database?
a)
 ADD NEW
b)
 ADD RECORD
c)
 INSERT NEW
d)
 INSERT INTO
9.

What would the SQL query pictured do?

a)

Find all the men

b)

Find all of the female writers

c)

Find all of Elgar's friends

d)

Find all the male writers

e)

Find all the fish

10.

What would the query pictured do?

a)

Find all of Elgar's friends who were born in 1869

b)

Find all of Elgar's family who were born in the 1860s.

c)

Find all the the ducks in Birmingham.

d)

Find all of Elgar's colleagues born in 1860.

e)

Find all of Elgar's colleagues who were born in the 1860s.

11.

How would you find out the nature of Elgar's relationship with the member of his database who was a shop assistant?SELECT RelationshipToElgar FROM Elgar's Friends WHERE Occupation = 'Shop Assistant'

a)

SELECT Connection FROM Elgar's Friends WHERE Occupation = 'Shop Assistant'

b)

SELECT RelationshipToElgar FROM Table WHERE Occupation = 'Shop Assistant'

c)

SELECT RelationshipToElgar FROM Elgar's Friends WHERE Job = 'Shop Assistant'

d)

SELECT RelationshipToElgar IN Elgar's Friends WHERE Occupation = 'Shop Assistant'

e)

CHOOSE RelationshipToElgar FROM Elgar's Friends WHERE Occupation = 'Shop Assistant'

12.

How many fields are there?

a)

4

b)

5

c)

6

d)

7

13.

How many records are in this table?

a)

7

b)

6

c)

5

d)

4

14.

What is the ID of the records that are returned when the SQL statement "SELECT * FROM Gymnasts WHERE Name='Xavier'"?

a)

0001

b)

0002

c)

0003

d)

0004

e)

0005

15.

What is the ID of the records that are returned when the SQL statement "SELECT * FROM Gymnasts WHERE HighScore > 8.4"?

a)

0001

b)

0002

c)

0003

d)

0004

e)

0005

16.

Which of the following statements will return the most records?

a)

SELECT * FROM Gymnasts WHERE HighScore > 8.0

b)

SELECT * FROM Gymnasts WHERE Competition LIKE R%

c)

SELECT * FROM Gymnasts WHERE Competition LIKE %o%

d)

SELECT * FROM Gymnasts WHERE Name LIKE %i%

17.

How many records are there in this table?

a)

6

b)

7

c)

9

d)

42

18.

How many fields are there in this table?

a)

6

b)

7

c)

9

d)

42

19.

How many records would be returned by the following SQL "SELECT * FROM songs WHERE TimesPlayed >=3

a)

0

b)

2

c)

3

d)

4

20.

Which of the queries is most likely to have produced this result?

a)

ANSWER: SELECT id, name, year FROM movies WHERE year > 2010;

b)

ANSWER: SELECT id, name, year FROM movies WHERE year < 2010;

c)

ANSWER: SELECT * FROM movies WHERE year > 2010;

d)

ANSWER: SELECT id, name, year FROM movies WHERE YEAR > 2010;

21.
Write a code for the following: Return all romances that have an imdb_rating over 6.
a)
SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating > 6;
b)
SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating < 6;
c)
SELECT imdb_rating, name FROM movie WHERE genre = ‘romance’ AND imdb_rating > 6;
d)
SELECT * FROM movies WHERE genre = romance and imdb_rating < 6;
22.
What is a special value in SQL that represents missing or unknown data?
a)
%
b)
?
c)
NULL
d)
*
23.
What causes most errors in a database?
a)
SQL
b)
humans
c)
servers
d)
Internet access
24.

Which of the following statements best defines the word 'database'?

a)

A database is a collection of data or information which is stored in a logical and structured way

b)

A database is a collection of statistics stored only for computers.

c)

A database does not collect data or information.

25.

Which of the following uses paper-based databases?

a)

Phonebook

b)

Smart Phone

c)

Computer

26.

Select one 'school/student based' database term.

a)

Allergies

b)

Type of pet

c)

Social media accounts

27.

Select the computer-based database

a)

Phonebook

b)

Chalkboard

c)

Google search engine

28.
Jennifer is creating a database for several customers. How will she list the Customer ID?  
a)
  Yes/No
b)
  Data 
c)
 Number
d)
 Currency
29.
A manager has requested a list of all products over $100 and in size “Large”. How would this information be retrieved?   
a)
 Sort Ascending 
b)
 Sort Descending
c)
  Filter
d)
  Find
30.
Chloe is creating a database for several customers. What is the data type for the field total sales?  
a)
 Yes/No
b)
  Data 
c)
 Number
d)
  Currency
31.
  A manager has requested a list of products from highest price to lowest. How would this information be retrieved?   
a)
Sort Ascending
b)
  Sort Descending
c)
  Filter
d)
  Find
32.
Which criteria will produce an alphabetical list of drivers who have 150 points?   
a)
  >150 and Sort Ascending
b)
  >150 and Sort Descending
c)
  >=150 and Sort Ascending 
d)
  >=150 and Sort Descending
33.
 Gina needs to create a database of all her friends. Where will all the information be kept? 
a)
 Field
b)
 Record
c)
  Table
d)
  Entry
34.
Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?
a)
NAME
b)
ID
c)
CITY
d)
ID, NAME
35.

HTML stands for...

a)

Hyper Time Multiple Language

b)

Hyper Text Mark-up Language

c)

Hippo T-Rex Mascot Lemur

d)

Hipper Text Make Language

36.

Which of the following codes would create a horizontal line

a)

<br>

b)

<h1></h1>

c)

<hr>

d)

<p>

37.

Copyright is a form of protection for intellectual property?

a)

True

b)

False

38.
Which of the following is the largest heading? 
a)
H2
b)
H3
c)
H4
d)
H6
39.
Google Chrome, Mozilla Firefox and Microsoft Edge are all examples of what?
a)
Search engines
b)
Websites
c)
Web Browsers
d)
Text editors
40.
</h> is
a)
Header Tag
b)
Headline Tag
c)
Half of a tag
d)
Closing header tag
41.

The <h1> tag marks what type of content?

a)

heading

b)

paragraph

c)

hyperlink

d)

unordered list

42.

The <p> tag marks what type of content?

a)

paragraph

b)

heading

c)

hyperlink

d)

picture

43.
</p> is
a)
punctuation tag
b)
closing paragraph tag
c)
closing punctuation tag
d)
paragraph tag
44.
</body>
a)
Body tag
b)
Paragraph tag
c)
Closing body tag
d)
Header tag
45.
</html>
a)
Found after </h1>
b)
Found after </style>
c)
Found after </body>
d)
Found at bottom of written code
46.
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
47.
Which format usually works best for photos?
a)

JPEG

b)

DOC

c)

GIF

d)

WAV

48.
Which is NOT a web browser?
a)
Chrome
b)
Internet explorer
c)
FireFox
d)
Yahoo
49.

Greater than or equal to

a)

> or =

b)

> || =

c)

>=

d)

<=

50.
Computer alows you to ......and ........information 
a)
copy and paste 
b)
store and process
c)
save and play 

Similar Resources on Wayground

G11 TVL CSS NC II - FINAL ASSESSMENT

50 questions

G11 TVL CSS NC II - FINAL ASSESSMENT

quiz

Worksheet

•

11th Grade

Workplace Technology Skills - Semester Review

50 questions

Workplace Technology Skills - Semester Review

quiz

Worksheet

•

9th - 12th Grade

Multiview Sketches

47 questions

Multiview Sketches

quiz

Worksheet

•

6th - 12th Grade

PLTW EOC review #1

50 questions

PLTW EOC review #1

quiz

Worksheet

•

9th - 12th Grade

Ag Structures - Framing and Foundation #2

50 questions

Ag Structures - Framing and Foundation #2

quiz

Worksheet

•

9th - 12th Grade

CSE Quiz #5

50 questions

CSE Quiz #5

quiz

Worksheet

•

9th - 12th Grade

EMPOWERMENT TECHNOLOGIES MIDTERM EXAM for STEM GOLD 2023-2024

55 questions

EMPOWERMENT TECHNOLOGIES MIDTERM EXAM for STEM GOLD 2023-2024

quiz

Worksheet

•

11th Grade

XI TKJ

50 questions

XI TKJ

quiz

Worksheet

•

11th Grade