CNA Interview Question

For technical: mainly about Java and SQL. 1-what is an abstract class? 2- how to select a specific column having a certain value with SQL 3- what does a given code do? what can you do to improve it? what is the complexity Home Visit: 1-implement Average, median and mode on a list of given numbers. 2- work in a team on case study to showcase how you present your solution Behavioral: How did you prepare for this interview?