Challenge Your IT Skills with 14 Quiz Questions on Databases, Linux, and Python

1. Which database operation benefits most from an index?

Answer: A – SELECT

A SELECT

B INSERT INTO … VALUES …

C UPDATE

D DELETE

2. Which locking method provides the best parallel access performance?

Answer: D – Row lock

A Column lock

B Table lock

C Block lock

D Row lock

3. What happens if a DELETE statement omits the WHERE clause?

Answer: B – All records in the table are deleted

A DELETE fails because there are no records to delete

B DELETE removes all records from the table

C DELETE prompts the user for deletion criteria

D DELETE fails due to syntax error

4. Which network‑layer protocol does traceroute typically use?

Answer: D – ICMP

A VRRP

B UDP

C ARP

D ICMP

5. In OSPF, which LSA type is confined to a single area?

Answer: A – Type 2

A 2

B 3

C 5

D 7

6. Which Linux signal cannot be caught?

Answer: B – SIGKILL

A SIGHUP

B SIGKILL

C SIGQUIT

D SIGUSR1

7. How can you view which process is using a specific port on Linux?

Answer: B – netstat -tnlp | grep

A netstat -an|grep port

B netstat -tnlp | grep port

C iostat -an | grep port

D iostat -dxt | grep port

8. How to remove duplicate elements from a Python list?

Answer: B – Convert the list to a set (which removes duplicates) and then back to a list

A List cannot be deduplicated

B Convert list to a deduplicated set, then back to list

C Convert list to a deduplicated tuple, then back to list

D Lists never contain duplicates

9. What is the difference between Python lists and tuples?

Answer: A – Lists are mutable, tuples are immutable

A Lists are mutable, tuples are immutable

B No difference

C Different size limits

D Lists are iterable, tuples are not

10. Which statement about Python class inheritance is correct?

Answer: C – A class can have multiple parent classes

A Python classes cannot inherit

B Inheritance is possible but parent constructors cannot be called

C Multiple inheritance is allowed

D Only single inheritance is allowed

11. Which of the following statements about ports are correct?

Answer: All (A, B, C, D)

A FTP uses TCP port 20

B FTP uses TCP port 21

C DNS uses TCP port 53

D DNS uses UDP port 53

12. Which statements about HTTP GET and POST are incorrect?

Answer: A and C

A Both can be bookmarked and cached

B GET parameters are placed in the URL

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

D GET should not handle sensitive data

13. As a technical manager, how would you improve the availability of a simple website consisting of a web server, a backend server, and a MySQL database?

Possible improvements include adding redundancy (load balancers, multiple instances), implementing health checks, using clustering or replication for the database, separating concerns with micro‑services, monitoring and alerting, automated failover, and ensuring network reliability.

14. How do you evaluate a hash function and what are some common hash functions?

Evaluation criteria: high efficiency (low CPU), low collision rate, small output size for storage efficiency, uniform distribution across nodes, and minimal re‑hash impact. Common hash functions include MD5, SHA‑1, CRC16, CRC32, etc.