Year 10 Online Quiz

What is a database?

• A database is a random collection of data stored on paper.
• A database is the base of the students' data.

• A database is a structured collection of data that is stored and accessed electronically.
• A database is a computer language.

Answer explanation

A database is an organized collection of structured information or data stored electronically in a computer system. It allows for efficient storage, retrieval, and manipulation of data.

A Database Management System (DBMS) is an application software.

• True
• False

Answer explanation

A DBMS (Database Management System) is the platform that holds the application software to manage the database such as adding, deleting, and updating of records held in the database.

A field that is used to link two records together in a relational database is called a _________

• primary key
• index
• foreign key
• table

Answer explanation

A foreign key is a field in a database table that establishes a relationship with a primary key or unique key in another table. It enforces referential integrity and helps maintain consistency between related tables.

A foreign key may contain null values.

• False
• True

Answer explanation

A null foreign key value signifies that the corresponding row in the "child" table doesn't currently have a relationship with a specific row in the "parent" table.

What field type would you suggest using for a person's identity card number?

• number

• boolean
• text

• date

What is the result of the below query?

SELECT *

FROM Employees

WHERE salary > 20000 AND salary < 30000;  

• The result of the query will be all the employees whose salary is smaller or equal than 30000.

• The result of the query will be all the employees whose salary is greater or equal than 20000 but smaller than 30000

• The result of the query will be all the employees whose salary is 25000.

• The result of the query will be all the employees whose salary is between 20000 and 30000.

You're sitting at a coffee shop catching up with friends on social media. What type of network (LAN, WAN, PAN) is your smartphone using?

• LAN

• WAN

• PAN

Answer explanation

Since the social media application is accessing the Internet, the network would be classified as a WAN (Wide Area Network).

An IPv6 is used to make the connecting device transmit data faster.

• False
• True

Answer explanation

IPv6 (Internet Protocol version 6) is primarily designed to address the limitations of IPv4, such as the exhaustion of available IP addresses and to enhance the efficiency and scalability of internet communication.

Which of the following best describes the primary function of a firewall?

• Encrypting data transmissions between devices on a network.

• Providing physical security for computer hardware.

• Filtering and controlling network traffic based on predetermined security rules.

• Optimizing network performance and bandwidth utilization.

Answer explanation

A firewall is a security system that monitors and controls incoming and outgoing network traffic based on predetermined security rules, protecting a network from unauthorized access and potential cyber threats.

Which network device is responsible for sending information between different networks based on IP addresses?

• Network Interface Card (NIC)

• Router

• Access Point

• Switch

Answer explanation

A router is a networking device that forwards data packets between computer networks. Its primary function is to determine the best path for data to travel from the source to the destination, ensuring efficient communication across different networks.