SQL and Networks Knowledge Quiz

Which layer of the TCP/IP model is responsible for the physical transmission of data across a network medium?

• Application Layer

• Transport Layer

• Network Access Layer

• Internet Layer

What does SQL stand for?

• Structured Query Language

• Simple Question Language

• Sequential Query Logic

• Structured Question Logic

Which protocol is used to assign IP addresses automatically to devices on a network?

• FTP

• SMTP

• DHCP

• HTTP

In database normalisation, what is the term for a column (or set of columns) that uniquely identifies each row in a table?

• Foreign Key

• Primary Key

• Candidate Key

• Index Key

Which SQL keyword is used to retrieve data from a database table?

• INSERT

• UPDATE

• SELECT

• DELETE

How many layers are in the TCP/IP model?

• 7

• 3

• 5

• 4

Which of the following protocols operates at the Application Layer of the TCP/IP model?

• IP

• TCP

• HTTP

• Ethernet

In First Normal Form (1NF), which of the following conditions must be satisfied?

• All partial dependencies must be removed

• All transitive dependencies must be removed

• All attributes must contain only atomic (indivisible) values

• Every table must have a foreign key

A network engineer is designing a system where data packets must travel from a computer in London to a server in Edinburgh. Considering the TCP/IP model, which layer is responsible for determining the best route for the packets to travel across multiple networks, and which protocol performs this function?

• Transport Layer; TCP determines the best route using port numbers

• Internet Layer; IP determines the best route using IP addresses

• Network Access Layer; Ethernet determines the best route using MAC addresses

• Application Layer; HTTP determines the best route using domain names

Consider the following SQL query: ``` SELECT StudentName, Grade FROM Results WHERE Grade > 70 ORDER BY Grade DESC; ``` A teacher wants to modify this query so that it only returns results where the subject is 'Mathematics' **and** the grade is greater than 70. Which of the following correctly modified queries achieves this?

• `SELECT StudentName, Grade FROM Results WHERE Grade > 70 OR Subject = 'Mathematics' ORDER BY Grade DESC;`

• `SELECT StudentName, Grade FROM Results WHERE Grade > 70 AND Subject = 'Mathematics' ORDER BY Grade DESC;`

• `SELECT StudentName, Grade FROM Results WHERE Grade > 70 AND Subject = 'Mathematics';`

• `SELECT StudentName, Grade, Subject FROM Results WHERE Grade > 70 AND Subject = 'Mathematics' ORDER BY Grade DESC;`