LCA Web Server & Database Administration 2

Question 1

Which Apache directive controls the maximum number of simultaneous client connections?

Accepted Answer

MaxRequestWorkers

Answer

MaxRequestWorkers (formerly MaxClients in Apache 2.2) sets the maximum number of simultaneous requests Apache will serve.

Question 2

In Nginx, which block directive defines a group of backend servers for load balancing?

Accepted Answer

upstream

Answer

The upstream block in Nginx defines a group of servers that can be referenced by proxy_pass for load balancing.

Question 3

Which MySQL command displays the current replication status on a replica server?

Accepted Answer

SHOW REPLICA STATUS

Answer

SHOW REPLICA STATUS (or SHOW SLAVE STATUS in older versions) displays the current state of the replica's connection to the source.

Question 4

What is the purpose of the Apache mod_status module?

Accepted Answer

Provide a real-time server activity page

Answer

mod_status exposes a /server-status endpoint showing real-time Apache performance metrics and active connections.

Question 5

Which PostgreSQL command grants all privileges on a database to a user?

Accepted Answer

GRANT ALL ON DATABASE dbname TO user

Answer

GRANT ALL ON DATABASE dbname TO user gives the specified user all privileges (CREATE, CONNECT, TEMP) on that database.

(LCA) Certified Linux Administrator Practice Test