NEW
Font size
WorksheetsWEB-SYSTEM AND TECHNOLOGY 2 Preliminary Examination
Total questions: 40
Worksheet time: 40mins
A static website is mainly built using:
PHP only
HTML & CSS only
PHP and MySQL
JavaScript frameworks
A dynamic website changes content based on:
Browser version
User interaction or data
Internet speed
Operating system
PHP stands for:
Personal Home Page
Pre Hyper Program
Hypertext Preprocessor
PHP Hyper Program
PHP is a __________ scripting language.
Client-side
Server-side
Hybrid
Local-only
MySQL is a type of:
Programming language
Operating system
Relational database management system
Web browser
Which example is a dynamic website?
Printed PDF
Resume website
A JPEG image
PHP is usually embedded inside:
SQL
HTML
CSS
Java
MySQL stores data using:
XML files
SQL queries
JavaScript
HTML tags
Which part of the web architecture runs PHP code?
Browser
Server
CSS engine
URL parser
WordPress is an example of:
Static page generator
CMS using PHP
Photo editor
Desktop application
The combination to create dynamic websites is:
HTML + CSS
PHP + JavaScript
HTML + CSS + PHP + MySQL
HTML + CSS + SQL
The browser receives output from PHP as:
JSON only
Raw SQL
HTML
PHP code
XAMPP includes MySQL and:
Safari
Photoshop
Apache
Firefox
The default directory for XAMPP projects is:
C:\xampp\server\
C:\xampp\htdocs\
C:\xampp\public\
C:\xampp\php\
A requirement to run PHP locally is:
Internet connection
Web server + PHP + MySQL
Microsoft Office
Android Studio
An example of stored data in MySQL:
Images only
Blog posts
CSS styles
Browser settings
The purpose of a local server is to:
Host on the internet
Execute PHP scripts
Store cookies
Load CSS faster
XAMPP works on:
Windows only
Linux only
macOS only
Windows, Linux, macOS
Docker is used for:
Editing images
Running containerized environments
Writing CSS
Uploading videos
To open your local server in the browser, you type:
http://home
http://server
http://localhost
http://phpserver
PHP is mainly used for:
Styling pages
Making interactive CSS
Server-side logic
Creating fonts
MySQL is described as:
Closed-source
Open-source
Paid subscription
Only for Linux
To create your first PHP script, you must:
Start Apache and MySQL
Install MS Word
Open Photoshop
Install a GPU
A user visits profile.php. What happens first?
MySQL sends data directly to the browser
The server sends the request to the PHP engine
The HTML file runs automatically
The browser connects to MySQL
You want to store product catalogs. Which technology handles this?
CSS
HTML
MySQL
PHP alone
You need to process form input and store it in a database. Which pair is needed?
PHP + CSS
PHP + MySQL
HTML + CSS
HTML + JavaScript
You created a folder named mywebsite for Docker. What will you run to start the server?
docker build php
docker compose up –d
docker run apache localhost
php install –run
A student wants to build an eCommerce system with user accounts. What should they use?
Pure HTML
HTML + CSS
PHP + MySQL
Illustrator
You want to test a PHP file locally. The correct URL is:
http://localhost/filename.php
file://filename.php
https://php.com
http://server.local
To display “Hello World” using PHP in xampp, you must place the file in:
C:\xampp\data\
C:\xampp\htdocs\
C:\xampp\mysql\
C:\xampp\public_html\
You must stop and start services manually in:
Docker Desktop
Windows Command Prompt
XAMPP Control Panel
MySQL Workbench
A PHP script needs to read stored user accounts. What does it need to send?
An image request
A CSS selector
A SQL query
A Java class
You develop a CMS. Which combination is essential?
PHP + MySQL
JavaFX + HTML
XML + CSS
Python + C
Your dynamic website must show personalized dashboards based on user login data. Which best explains how PHP and MySQL work together?
PHP styles the page; MySQL sends images
PHP queries MySQL, processes results, and outputs personalized HTML
MySQL loads HTML templates
PHP rewrites the database directly into CSS
You are designing a multi-user system. What workflow ensures dynamic and updated data on every request?
Store data in HTML tables
Let MySQL store data and let PHP fetch data upon user request
Use only static CSS files
You want to migrate your development from XAMPP to Docker for better consistency. What is the most accurate reasoning?
Docker websites load faster
Docker containers ensure consistent environments across machines
Docker removes the need for Apache
Docker writes PHP code automatically
A web developer wants to scale a PHP application to many users and ensure portability. What setup helps achieve this?
Run everything manually in XAMPP
Use Docker containers for PHP, MySQL, and the web server
Store everything in one PHP file
Use only HTML and CSS files
You are tasked to create a dynamic website with login, content management, and user-specific dashboards. Which architecture blueprint best fits the requirements?
HTML-only pages
HTML + CSS + PHP + MySQL, running on Apache/NGINX
JavaScript + Photoshop
Local files with no database
Which file extension is used for PHP scripts?
.js
.html
.php
.css
What is the primary function of MySQL in a web application?
Designing web pages
Storing and managing data
Rendering images
Styling content
