COC Level 5: Web Development and
Database Administration
Based on Ethiopian Occupational Standards (EOS)
Section 1: Multiple Choice Questions (MCQ)
1. Which of the following is a valid HTML5 semantic element?
A. <div>
B. <header>
C. <span>
D. <section>
Answer: B and D
2. Which of the following best describes 'Normalization' in databases?
A. Data encryption process
B. Creating backups
C. Organizing data to reduce redundancy
D. Adding indexes
Answer: C
3. What is the primary function of CSS in web development?
A. Handle database queries
B. Structure page content
C. Style the visual layout
D. Write server logic
Answer: C
4. Which HTTP status code means 'Not Found'?
A. 200
B. 301
C. 404
D. 500
Answer: C
5. Which MySQL command is used to view all databases?
A. SHOW DATABASES;
B. SELECT * FROM database;
C. LIST DATABASES;
D. SHOW ALL;
Answer: A
Section 2: True / False
1. CSS stands for Cascading Style Sheets. ✅ True
2. MySQL is a NoSQL database system. ✅ False
3. The <script> tag is used to include JavaScript in HTML. ✅ True
4. SSL certificates are used to encrypt data during transfer. ✅ True
5. PHP is executed in the client browser. ✅ False
Section 3: Short Answer Questions
1. What is the difference between client-side and server-side scripting?
✅ Client-side scripting runs in the browser (e.g., JavaScript), while server-side scripting
runs on the server (e.g., PHP, Node.js).
2. List three types of database relationships.
✅ One-to-One, One-to-Many, Many-to-Many.
3. Why is responsive design important?
✅ It ensures the website looks and functions well on all devices, including desktops,
tablets, and mobile phones.
4. What is the purpose of version control systems like Git?
✅ To manage changes to source code, collaborate with teams, and track history of
code changes.
5. Mention two common web security vulnerabilities.
✅ SQL Injection and Cross-Site Scripting (XSS).
Section 4: Practical-Based Questions with Sample Answers
1. Create a PHP script to connect to a MySQL database.
<?php
$conn = new mysqli("localhost", "root", "", "student_db");
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>
2. Write a simple HTML form that submits user data to a PHP page.
<form action="submit.php" method="POST">
<input type="text" name="username" placeholder="Enter Username" required>
<input type="submit" value="Submit">
</form>
3. Using SQL, write a query to display names of students from a table where age > 18.
SELECT name FROM students WHERE age > 18;
4. Design a basic responsive layout using CSS.
.container {
display: flex;
flex-wrap: wrap;
}
.box {
flex: 1 1 300px;
margin: 10px;
padding: 20px;
background-color: #f2f2f2;
}
5. Demonstrate how to prevent SQL Injection in PHP.
$stmt = $conn->prepare("SELECT * FROM users WHERE username = ?");
$stmt->bind_param("s", $username);
$stmt->execute();
