1. What four components are needed to create a fully dynamic website page?
A web server (such as Apache)
A server-side scripting language such as PHP
A Database such as MySQL
A client-side scripting language such as JavaScript
2. What does HTML stands for?
Hypertext Markup Language: the web page itself including text and markup tags.
3. Why does the name MySQL contains the letter SQL?
My answer (Wiseman):
MySQL is the database management system while the SQL with stands for Structured
Query Language is a query language use to manipulate or modify, that is to insert,
select, delete, update etc… files stored in the database management system, MySQL.
Conclusively MySQL contains SQL since the SQL work hand in hand with MySQL to
handle queries by users.
Answer given by the book: MySQL accepts commands in Structured Query Langauge
(SQL). SQL is the way that every user (including the PHP program) interacts with
MySQL.
4. PHP and JavaScript are both programming languages that generate
dynamic results
for web pages. What is their main difference, and why would you use
both of them?
My answer (Wiseman)
PHP constructs and codes is a flexibly server-side language that can
easily be integrated into html documents to conduct dynamic control
on servers. For example, you can write PHP codes to fetch, select,
establish connections with server, import html files into your web files
among other. Basically, it gives you dynamic control on the server and
also contain several build in functions such as date etc…
On the other hand, JavaScript is also a scripting language that allows
users to interaction the web. For example JavaScript can be used in
checking email input validations on forms and also generate prompts
for users to respond to among other functions. JavaScript was originally
created to provide dynamic control over certain element of HTML
documents.
However, in terms of its security implementations, Javascript cannot
best implement security features to your web file since its not originally
designed to control server-side but PHP can best be used to implement
security features since it has functions that gain absolute control on
the server-side.
Answer according to the book author (marking scheme):
PHP runs on the server, whereas, whereas JavaScript runs on the client.
PHP can communicate with the database to store and retrieve data, but
it can’t alter the user’s web page quickly and dynamically. JavaScript
has the opposite benefits and drawbacks. That is JavaScript can alter
user’s web page quickly and dynamically.
5. What does CSS stand for?
Cascading Style Sheet: Styling and layouts applied to elements of the
HTML document.
6. List three major components introduced in HTLM5?
Canvas
Audio
Video
Others include: summary, article, footer etc…
7. If you encounter a bug (which is rare) in one of the open source tools, how do
you
think you could get it fixed?
My answer (Wiseman)
Open Source tools are usually created by a team of community
developers and thus they make available the original codes of the tools
which can easily be read and corrected by anyone with the knowhow to
read and interpret the functionalities of the codes.
Therefore, where bugs and security breaches are detected, it can be
recoded or those lines of codes edited to restore those breaches and
bugs.
Answer according to the book author (marking scheme):
Some of these technologies are controlled by companies that accept
bug reports and fix the errors like errors like any software company.
But open source software also depends on a community, so your bug
report may be handled by any user who understands the code well
enough. You may someday fix bugs in an open source tool yourself.
Prepared by Modesty Kwabena Azaloo,
Rep, Advance Website design
