Web Server & Database Administration Flashcards

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

Answer: DocumentRoot

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

What does the MySQL innodb_flush_log_at_trx_commit=1 setting guarantee?

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

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

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

Answer: gzip on; gzip_types text/html text/css;

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

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

Answer: pg_dump dbname > file.sql

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

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

Answer: Prevents Apache from generating directory listings when no index file exists

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

Which MySQL statement creates a user and sets a password in one step?

Answer: CREATE USER 'user'@'host' IDENTIFIED BY 'password'

CREATE USER 'user'@'host' IDENTIFIED BY 'password' is the standard SQL statement to create a MySQL user account with authentication.

In Nginx, what does the try_files directive do?

Answer: Checks for the existence of files in order and serves the first match

try_files checks for each specified file or directory in order and serves the first one found, falling back to the final argument (often a named location or error code).