wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Quiz sur UML, OOP, PHP et SQL

Total questions: 25

Worksheet time: 1hrs 13mins

Name
Class
Date
1.

What is the main purpose of a use case diagram?

4 lines
2.

In use case diagrams, what does an "actor" represent?

4 lines
3.

Which symbol represents inheritance in UML class diagrams?

4 lines
4.

What does a filled diamond represent in class diagrams?

4 lines
5.

In UML, which symbol represents inheritance?

a)

Solid line with triangular arrow

b)

Dotted line with arrow

c)

Solid line with diamond

d)

Dotted line with open arrow

6.

What are the four main principles of OOP?

4 lines
7.

Explain encapsulation with a concrete example.

4 lines
8.

What is the difference between composition and aggregation?

4 lines
9.

Explain the Open/Closed principle.

4 lines
10.

What is the difference between self:: and static:: in PHP?

4 lines
11.

What are PHP traits and when would you use them?

4 lines
12.

How can you prevent a class from being inherited in PHP?

4 lines
13.

What is the purpose of the magic method __toString()?

4 lines
14.

Which feature of PHP 8 allows type declarations for class properties?

4 lines
15.

What does PDO mean and why is it preferred over mysql_* functions?

4 lines
16.

How do prepared statements prevent SQL injections?

4 lines
17.

Write a PDO connection with proper error handling.

4 lines
18.

How to manage transactions with PDO?

4 lines
19.

What is the difference between INNER JOIN and LEFT JOIN?

4 lines
20.

What are database indexes and when should you create them?

4 lines
21.

What is the difference between COUNT(*) and COUNT(column)?

4 lines
22.

What is the difference between git fetch and git pull?

4 lines
23.

How to undo the last commit without losing the changes?

4 lines
24.

Explain the difference between git merge and git rebase.

4 lines
25.

What is the purpose of the .gitignore file?

4 lines