I'm still a bit confused on how we are going to test out SQL databases with sample data. It's mentioned that we must include DROP, INSERT and SELECT statements, so are we making up our own sample data to test out databases with? 'You also need to populate your database (INSERT INTO …) with some sample data and perform some simple queries to ensure it works correctly.' How in depth does the sample data need to be? And will we be questioned on it if we are called in for an interview? Also, is a solution going to be provided before the test is released, or are we going to assume our solution is correct and base our answers off of that? Thanks

Just 3-4 records for each table are sufficient. You will be questioned on your attempt and your understanding. Dummy data would not matter