Web Server & Database Administration Flashcards

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

Answer: MaxRequestWorkers

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

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

Answer: upstream

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

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

Answer: SHOW REPLICA STATUS

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

What is the purpose of the Apache mod_status module?

Answer: Provide a real-time server activity page

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

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

Answer: GRANT ALL ON DATABASE dbname TO user

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

In Apache, which module must be enabled to use .htaccess files for per-directory configuration?

Answer: mod_rewrite

While AllowOverride controls whether .htaccess is read, mod_rewrite is the most commonly required module activated via .htaccess; however, AllowOverride must be set to allow .htaccess to function at all.

Which command checks the syntax of an Nginx configuration file without restarting the service?

Answer: nginx -t

nginx -t tests the configuration file for syntax errors and reports the result without affecting the running process.