wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

OCR A Level Computer Science - 1.3.x

Total questions: 57

Worksheet time: 29mins

Name
Class
Date
1.

What are the key reasons for compressing data?

a)

Less space needed for storage

b)

Less time to transmit

c)

Higher quality files

d)

Reduced amount of processing power

e)

Limited RAM

2.

Lossless compression...

a)

Is used when not all the information is needed

b)

Is not as effective as lossy compression

c)

Can fully regenerate the original file

d)

Includes files such as .ZIP

e)

Would be a sensible choice for a music download site

3.

Lossy compression...

a)

Permanently removes data from a file

b)

Always leads to a noticeable loss of quality

c)

Aims to remove redundant data

d)

Can return the original file to its original quality

e)

Would be a sensible choice for a music download site.`

4.

Dictionary based compression...

a)

Is a lossless compression format

b)

Creates a dictionary of common letter combinations to encode words with fewer characters

c)

Creates a dictionary of smaller letters so less space is used

d)

Sends the dictionary with the data

e)

Doesn't need to send the dictionary with the data

5.

Run-length encoding...

a)

is Lossless

b)

is Lossy

c)

Can only be used for text

d)

Records the number of repeats of an individual element

e)

Can be used for a wide variety of file types

6.

Encryption...

a)

Uses at least one key to cipher data

b)

Is only used on text

c)

Can be symmetric or asymmetric

d)

Is impossible to break

e)

Has developed a lot as processing power has increased

7.

Symmetrical encryption techniques...

a)

Are the most secure types of encryption

b)

Use a single key to encode/decode

c)

Use multiple keys to encode/decode

d)

Include XOR, Caesar and Route

e)

Include RSA, Diffie-Hellman and DSS

8.

Asymmetrical encryption techniques...

a)

Are the most secure types of encryption

b)

Use a single key to encode/decode

c)

Use multiple keys to encode/decode

d)

Include XOR, Caesar and Route

e)

Include RSA, Diffie-Hellman and DSS

9.

Asymmetrical encryption...

a)

Often requires considerable processing power

b)

Is impossible to break

c)

Is being threatened by the possibility of quantum computing

d)

Can be brute-force attacked

e)

Is very widely used, even in small businesses

10.

A database is...

a)

a structured system for holding records

b)

a spreadsheet of information

c)

reliant on good design, as poor structure can cause many problems

d)

simple and easy to create

11.

An entity is...

a)

A thing, about which data is stored in the database such as Student

b)

A property such as Name or Age

12.

An attribute is...

a)

A thing, about which data is stored in the database such as Student

b)

A property such as Name or Age

13.

Entity relationships can be:

a)

One-to-One

b)

Many-to-Many

c)

Many-to-One

d)

One-to-Many

14.

In a hospital system, the relationship between a consultant to a patient would be:

a)

One-to-One

b)

One-to-Many

c)

Many-to-Many

d)

Many-to-One

15.

In a hospital system, the relationship between a nurse to a ward would be:

a)

One-to-One

b)

One-to-Many

c)

Many-to-Many

d)

Many-to-One

16.

In a hospital system, the relationship between a patient to a surgeon would be:

a)

One-to-One

b)

One-to-Many

c)

Many-to-Many

d)

Many-to-One

17.

In a hospital system, the relationship between a consultant to a student would be:

a)

One-to-One

b)

One-to-Many

c)

Many-to-Many

d)

Many-to-One

18.

In a school system, the relationship between a teacher to a pupil would be:

a)

One-to-One

b)

One-to-Many

c)

Many-to-Many

d)

Many-to-One

19.

In a school system, the relationship between a teacher to a department would be:

a)

One-to-One

b)

One-to-Many

c)

Many-to-Many

d)

Many-to-One

20.

A primary key is...

a)

A unique identifier for each record

b)

An identifier which can be shared between multiple records

c)

The first number in the record

d)

A way of looking up data in related tables

21.

A foreign key is...

a)

A unique identifier which links a record to a related record in another table

b)

A unique identifier for each record in a table

c)

A shared identifier for all records in one table

22.

What is the primary key?

a)

Sales ID

b)

Item ID

c)

Item Name

d)

Address

e)

Payment Complete?

23.

Which field is likely to be a foreign key?

a)

Sales ID

b)

Item ID

c)

Item Name

d)

Address

e)

Payment Complete?

24.

What will be returned by the SQL query:

SELECT * FROM Sales WHERE Sales ID = "00113"

a)

00112 1151213215 Keyring 123 Example Ln 1

b)

00112 65465654688 Pencil 123 Example Ln 1

c)

00112 87954121321 Bag 123 Example Ln 1

d)

00113 65465654688 Pencil 77 Bay St 0

e)

00114 65465654688 Pencil 999 Letsbey Ave 1

25.

Which of the following SQL statements will return the Sales ID of all sales which involve a pencil?

a)

SELECT * FROM Sales WHERE Item Name = "Pencil"

b)

SELECT * FROM Sales WHERE Item Name = Pencil

c)

SELECT Sales ID FROM Sales WHERE Item Name = "Pencil"

d)

SELECT Sales ID FROM Sales WHERE Item Name = Pencil

e)

SELECT "Sales ID" FROM Sales WHERE Item Name = "Pencil"

26.

Which of the following SQL statements will return the address of anyone who has ordered a pencil and has paid.

a)

SELECT Address FROM Sales WHERE Item Name = "Pencil" and Payment Complete? = TRUE

b)

SELECT Address FROM Sales WHERE Item Name = "Pencil" and Payment Complete? = "TRUE"

c)

SELECT Address FROM Sales WHERE Item Name = Pencil and Payment Complete? = TRUE

d)

SELECT Address FROM Sales WHERE Item Name = "Pencil" or Payment Complete? = TRUE

e)

SELECT Address FROM Sales WHERE "Item Name" = "Pencil" and "Payment Complete?" = TRUE

27.

Is this table in first normal form?

a)

Yes

b)

No

c)

Don't Know

28.

Is this table in first normal form?

a)

Yes

b)

No

c)

Don't Know

29.

Is this table in second normal form?

a)

Yes

b)

No

c)

Don't Know

30.

Is this table in second normal form?

a)

Yes

b)

No

c)

Don't Know

31.

Is this table in third normal form?

a)

Yes

b)

No

c)

Don't Know

32.

Select the things which are true for a database in 1NF:

a)

Each entity has a unique identifier

b)

Each attribute is atomic (divided as small as possible)

c)

Each attribute has a single value

d)

There is no repetition

e)

There are no transitive relationships

33.

Select the things which are true for a database in 2NF:

a)

The database is in 1NF

b)

All attributes depend on the primary key

c)

There is no dependence

d)

There is no repetition

e)

There are no transitive relationships

34.

Select the things which are true for a database in 3NF:

a)

The database is in 2NF

b)

There are at least 4 tables in the database

c)

There is no dependence

d)

All attributes have a separate table

e)

There are no transitive relationships

35.

What normal form is this table in?

a)

1NF

b)

2NF

c)

3NF

36.

What normal form is this table in?

a)

1NF

b)

2NF

c)

3NF

37.

What normal form is this table in?

a)

1NF

b)

2NF

c)

3NF

38.
“A set of rules that allow two devices to communicate.”
a)
Protocol
b)
Peer to Peer
c)
Client-Server
d)
Encryption
e)
Proxies
39.
“The most common general-purpose standard protocol that allows any networked computers (including those on The Internet) to communicate with each other whatever their equipment.”
a)
TCP/IP Stack
b)
Protocol
c)
Peer to Peer
d)
Client-Server
e)
Encryption
40.
“The Internet’s equivalent of a phone book. They maintain a directory of domain names and translate them to Internet Protocol (IP) addresses. This is necessary because, although domain names are easy for people to remember, computers or machines access websites based on IP addresses.”
a)
DNS
b)
TCP/IP Stack
c)
Protocol
d)
Peer to Peer
e)
Client-Server
41.
“The concept of a protocol not simply being a set of rules but those rules being built up into very specific layers and those rule layers behind built on top of each other in a deliberate order creating a layered protocol stack. This results in the rules of a protocol being executed in a specific sequence as you move through the protocol stack.”
a)
Protocol Layering
b)
DNS
c)
TCP/IP Stack
d)
Protocol
e)
Peer to Peer
42.
“A collection of computers / computing devices on the same network which are physically close together, for example, all located within one building or site e.g. a home or school network.”
a)
LAN
b)
Protocol Layering
c)
DNS
d)
TCP/IP Stack
e)
Protocol
43.
“A collection of computers / computing devices on the same network which are spread out over a geographically large area, for example a university across several campuses, or a multinational corporation with offices / sites in different cities or even different countries.”
a)
WAN
b)
LAN
c)
Protocol Layering
d)
DNS
e)
TCP/IP Stack
44.
“A method of sending data over a wide area network in which the message is broken into a number of parts which are sent independently, over whatever route is optimum for each packet, and reassembled at the destination.”
a)
Packet Switching
b)
WAN
c)
LAN
d)
Protocol Layering
e)
DNS
45.
“A method of sending data over a wide area network in which two network nodes establish a dedicated communications channel through the network before the nodes may communicate. All data then follows this same path for the duration of the data transfer.”
a)
Circuit Switching
b)
Packet Switching
c)
WAN
d)
LAN
e)
Protocol Layering
46.
“A computer application used in a network to prevent external users gaining unauthorised access to a computer system.”
a)
Firewall
b)
Circuit Switching
c)
Packet Switching
d)
WAN
e)
LAN
47.
“A computer application that accesses data on a different computer system or network. It controls the access of authorised users to data and allows the operation of the system to be isolated from control by external users.”
a)
Proxies
b)
Firewall
c)
Circuit Switching
d)
Packet Switching
e)
WAN
48.
“The process of making data in a computer system unintelligible.”
a)
Encryption
b)
Proxies
c)
Firewall
d)
Circuit Switching
e)
Packet Switching
49.
“A method of network organisation in which network stations make use of resources available at one or more servers.”
a)
Client-Server
b)
Encryption
c)
Proxies
d)
Firewall
e)
Circuit Switching
50.
“A method of network organisation in which network stations can share resources on other network stations, so one station can use a printer on another station or save data on another station’s local storage.”
a)
Peer to Peer
b)
Client-Server
c)
Encryption
d)
Proxies
e)
Firewall
51.
“A mark-up language developed for multimedia documents, such as World Wide Web Pages.”
a)
HTML
b)
Client Side Processing
c)
Sever Side Processing
d)
PageRank Algorithm
e)
Search Engine Indexing
52.
“A definition of the formatting and layout of elements of an HTML document. The stylesheet may be part of the HTML document, or stored as a separate file linked to the document. The use of different stylesheets linked to the same document allows appropriate layout of the same content on, for example, mobile devices, display screens.”
a)
CSS
b)
HTML
c)
Client Side Processing
d)
Sever Side Processing
e)
PageRank Algorithm
53.
“An object-oriented computer programming language commonly used to create interactive effects within web browsers.”
a)
JavaScript
b)
CSS
c)
HTML
d)
Client Side Processing
e)
Sever Side Processing
54.
“The method of collecting, parsing and storing data to facilitate fast and accurate information retrieval.”
a)
Search Engine Indexing
b)
JavaScript
c)
CSS
d)
HTML
e)
Client Side Processing
55.
“An algorithm used by Google Search to rank websites in their search engine results. It works by counting the number and quality of links to a page to determine a rough estimate of how important the website is. The underlying assumption is that more important websites are likely to receive more links from other websites.”
a)
PageRank Algorithm
b)
Search Engine Indexing
c)
JavaScript
d)
CSS
e)
HTML
56.
“Server-side processing refers to operations that are performed by the server in a client-server relationship in computer network. Typically, a server is a computer program, such as a web server, that runs on a remote server, reachable from a user’s local computer.”
a)
Sever Side Processing
b)
PageRank Algorithm
c)
Search Engine Indexing
d)
JavaScript
e)
CSS
57.
“Client-side processing refers to operations that are performed by the client in a client-server relationship in a computer network. Typically, a client is a computer application, such as a web browser, that runs on a user’s local computer and connects to a server as necessary.”
a)
Client Side Processing
b)
Sever Side Processing
c)
PageRank Algorithm
d)
Search Engine Indexing
e)
JavaScript

Similar Resources on Wayground

CIS Microsoft Excel (Review)

62 questions

CIS Microsoft Excel (Review)

quiz

Worksheet

•

9th Grade - Professio...

Safety and Security - Easy

57 questions

Safety and Security - Easy

quiz

Worksheet

•

7th Grade - University

Latihan Soal DKV 2024

59 questions

Latihan Soal DKV 2024

quiz

Worksheet

•

12th Grade

ÔN TẬP GIỮA KỲ 2 LỚP 12

60 questions

ÔN TẬP GIỮA KỲ 2 LỚP 12

quiz

Worksheet

•

12th Grade

E-BOOK

60 questions

E-BOOK

quiz

Worksheet

•

KG - University

Unit 2 Test Review - The Internet

61 questions

Unit 2 Test Review - The Internet

quiz

Worksheet

•

9th - 12th Grade

Finals in Empowerment Technologies

60 questions

Finals in Empowerment Technologies

quiz

Worksheet

•

11th - 12th Grade

Computer Servicing Ch 1-3 Review

53 questions

Computer Servicing Ch 1-3 Review

quiz

Worksheet

•

9th - 12th Grade