Computing

Question 1

1A server-side language used with databases on websites is

Easy

A. HTML B. CSS C. PHP D. JPEG

Question 2

2Organising database tables to reduce repeated data is

Medium

A. normalisation B. compilation C. encryption D. fragmentation

Question 3

3A web page that adjusts its layout to fit phones, tablets and computers uses

Easy

A. responsive design B. fixed design C. static images only D. printed design

Question 4

4The SQL command to add a new record is

Easy

A. ALTER B. INSERT C. SELECT D. DROP

Question 5

5A web server

Easy

A. prints documents B. creates databases only C. only sends e-mail D. stores and delivers web pages to browsers

Question 6

6Software used to create and manage databases, such as MySQL, is a

Easy

A. compiler B. web browser C. database management system (DBMS) D. spreadsheet

Question 7

7In SQL, which clause filters the rows returned by a query?

Easy

A. SELECT B. FROM C. WHERE D. ORDER BY

Question 8

8The SQL clause used to filter records is

Easy

A. FROM B. GROUP C. WHERE D. ORDER BY

Question 9

9JavaScript is mainly used to

Easy

A. design databases only B. build hardware C. format hard disks D. make web pages interactive

Question 10

10The SQL statement SELECT name FROM students ORDER BY score DESC returns names

Hard

A. from lowest to highest B. from highest to lowest score C. alphabetically D. randomly