LCA Web Server & Database Administration 3

Question 1

Which Apache directive sets the document root for a virtual host?

Accepted Answer

DocumentRoot

Answer

DocumentRoot specifies the directory from which Apache serves files for a given virtual host or global server context.

Question 2

What does the MySQL innodb_flush_log_at_trx_commit=1 setting guarantee?

Accepted Answer

Logs are flushed to disk on every transaction commit ensuring ACID compliance

Answer

Setting innodb_flush_log_at_trx_commit=1 ensures the redo log is flushed to disk at every commit, providing full ACID durability.

Question 3

In Nginx, how do you enable gzip compression for HTML and CSS responses?

Accepted Answer

gzip on; gzip_types text/html text/css;

Answer

The gzip on directive enables compression, and gzip_types specifies which MIME types should be compressed.

Question 4

Which command backs up a single PostgreSQL database to a file?

Accepted Answer

pg_dump dbname > file.sql

Answer

pg_dump is the PostgreSQL utility that creates a consistent backup of a single database in SQL or custom format.

Question 5

What is the effect of the Apache directive 'Options -Indexes' in a Directory block?

Accepted Answer

Prevents Apache from generating directory listings when no index file exists

Answer

Options -Indexes prevents Apache from generating a directory listing, returning a 403 Forbidden instead when no index file is found.

(LCA) Certified Linux Administrator Practice Test