Test Your IT Fundamentals: 14 Quiz Questions on Databases, Linux, and Networking

1. Which database operation benefits most from an index? Correct answer: A Options:

SELECT

INSERT INTO … VALUES …

UPDATE

DELETE

2. Which locking method provides the best parallel access performance? Correct answer: D Options:

Row lock

Table lock

Block lock

Column lock

3. What happens if a DELETE statement omits the WHERE clause? Correct answer: B Options:

The DELETE fails because there are no records to delete

All records in the table are removed

The statement prompts the user for deletion criteria

The statement fails due to syntax error

4. Which network‑layer protocol does traceroute typically use? Correct answer: D Options:

VRRP

UDP

ARP

ICMP

5. In OSPF, which LSA type is confined to its own area? Correct answer: A Options:

Type 2

Type 3

Type 5

Type 7

6. Which Linux signal cannot be caught? Correct answer: B Options:

SIGHUP

SIGKILL

SIGQUIT

SIGUSR1

7. How to view which process is using a specific port on Linux? Correct answer: B Options:

netstat -an | grep port

netstat -tnlp | grep port

iostat -an | grep port

iostat -dxt | grep port

8. How to remove duplicate elements from a Python list? Correct answer: B Options:

Lists cannot be deduplicated

Convert the list to a set (which removes duplicates) and then back to a list

Convert the list to a tuple, deduplicate, then back to a list

Lists never contain duplicates

9. What is the difference between Python lists and tuples? Correct answer: A Options:

Lists are mutable, tuples are immutable

There is no difference

They have different size limits

Lists are iterable, tuples are not

10. Which statement about Python class inheritance is correct? Correct answer: C Options:

Python classes cannot inherit

Inheritance is possible but the parent constructor cannot be called

A class can have multiple parent classes

A class can have only one parent class

11. Which of the following statements about ports are correct? Correct answer: A, B, C, D Options:

FTP uses TCP port 20

FTP uses TCP port 21

DNS uses TCP port 53

DNS uses UDP port 53

12. Which statements about HTTP GET and POST are incorrect? Correct answer: A, C Options:

Both can be bookmarked and cached

GET parameters are placed in the URL

GET is only for query requests and cannot be used to request data

GET should not handle sensitive data

13. As a technical manager, how would you improve the reliability of a simple website composed of a web server, a backend server, and a MySQL database? Possible improvements include implementing load balancing, health checks, automated failover, database replication, connection pooling, circuit breakers, monitoring and alerting, graceful degradation, redundancy in network paths, regular backups, and performance tuning of each component.

14. How do you evaluate the quality of a hash function and what are common examples? Evaluation criteria: high computational efficiency, low collision probability, small output size for storage efficiency, uniform distribution across nodes, and minimal re‑hash impact. Common hash functions: MD5, SHA‑1, CRC16, CRC32, etc.