O'Reilly logo

CompTIA® Linux+ Certification, Powered by LPI, Student Manual by Axzo Press

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

1438 CompTIA Linux+ Certification, Powered by LPI
Unit summary: Web environment
Topic A In this topic, you learned that Linux supports a wide range of Web technologies,
including the Apache Web server, PHP programming, the MySQL database server,
and others. You installed Apache and configured its operations as well as its modules.
You installed PHP and tested its functionality.
Topic B In this topic, you learned how to install the MySQL database server and associated
utilities onto your Linux computer. You installed the PHP-to-MySQL connection
modules and the phpMyAdmin administration tool. You examined the MySQL
configuration files, tested your MySQL server, and managed its running state.
Topic C In this topic, you learned about SQL commands. You used CREATE to create a
database and tables. You used INSERT and UPDATE to input data to tables. You used
SELECT with various clauses, including WHERE, JOIN, ORDER BY, and GROUP
BY to retrieve data. Finally, you used DELETE, TRUNCATE TABLE, and DROP to
remove data and structures.
Review questions
1 Name the Java Server Pages module for Apache.
Tomcat
2 True or false? PHP is a Web browser-based scripting tool.
False. PHP scripts run on the Web server, not on a Web browser.
3 While it’s often referred to as “Apache,” what is the actual name for the Web server
software developed by the Apache Software Foundation?
HTTPD
4 What is MySQL?
MySQL is an open source database server published by Oracle Corp.
5 Name at least one benefit of using Squid.
Answers might include saving network bandwidth or speeding access to commonly requested
Web sites.
6 The default document for a new Apache installation is ___________.
index.html
7 True or false? The primary configuration file for an Apache 2 server is named
.htaccess.
False. The primary configuration file is apache2.conf.
8 What is the purpose of the ErrorLog directive in an Apache configuration file?
It specifies the name and location of the error log file.
9 What is a virtual host?
It is a Web site running on your Apache server. Your one server can support multiple sites, with
each being a separate virtual host.
10 What is the purpose of the DocumentRoot directive in an Apache configuration file?
It specifies the location of the Web page files for a virtual host.
Web environment 1439
11 True or false? You must set AllowOverride to something other than None to use a
.htaccess file to configure an Apache-based Web site.
True
12 True or false? To install an Apache module, you must recompile the Apache source
code.
False. You install modules by placing their files in the /etc/apache2/mods-enabled directory and
updating the Apache configuration files.
13 What is the purpose of the older apachectl and current apache commands?
You use either of them to start, stop, or restart the Apache daemon.
14 The default user account for a MySQL server is named ___________.
root
15 What is the name and location of the global MySQL configuration file?
/etc/mysql/my.cnf
16 What is the default port for MySQL communications?
3306
17 True or false? When setting up a database-driven Web site, you may install Apache
and MySQL on separate servers.
True
18 What is the name of the popular Web-based open source MySQL administration
tool?
phpMyAdmin
19 True or false? SQL commands are case-sensitive.
False. Table and field names can be case-sensitive. And by convention, command words are
written in uppercase. But commands can be written in either case.
20 What is the command or clause you use to retrieve data from multiple tables in a
single query?
JOIN
21 Which command or clause can be used only in conjunction with an aggregate
function?
A SELECT.
B WHERE.
C GROUP BY.
D ORDER BY.
22 Which command or clause do you use to empty a table?
A DELETE.
B DROP.
C EMPTY.
D TRUNCATE TABLE.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required