One of my interview assignments:

Solved with Java 8, Spring Boot, Spring Data JPA, Hibernate, Mockito, H2.

Added queryDSL example

XML validation can be turned on/off in properties file

XSD/DTD XML validation

SAX/DOM XML parsers

TASK:

Simple command line application with database access

Main functionality:

1. provide help/usage info
2. read a server "specification" from a file on local disk (e.g. see server_1.xml) and persist it to the SERVER database table
3. count the number of servers currently persisted in the database
4. list persisted servers
5. delete a persisted server (id of server to delete to be passed in as a command line arg)
6. edit name of persisted server (takes command line args to identify id of server and new name)