Was asked to read a relational DB from language like C++/Java containing a column containing Yes/No and send columns containing Yes in an email to the team (from the code editor)
Sigiloso
Answer: said JDBC to establish driver and DB connection, perform a normal SQL query to get relevant rows using WHERE clause in a PreparedStatement returned into a ResultSet and use SMTP protocol, specify hostname, portname, message body, etc. Interviewer was satisfied