DATABASE PROBLEMS

Database operations are so common in most programming roles, that you should expect a few questions if you indicate on your résumé that you have even the slightest experience.

Simple SQL

---

PROBLEM

Given a database with the table

Olympics( 
    city CHAR(16), 
    year INTEGER(4)
);

write a SQL statement to insert Montreal and 1976 into the database.

---

This is an extremely easy problem that an interviewer might use to determine whether you have ever used SQL before or whether you were padding your résumé when you mentioned it. If you know SQL, you’re all set. It’s a straightforward SQL INSERT statement; no tricks. If you don’t know SQL, you’re in trouble. The correct answer is:

INSERT INTO Olympics VALUES( 'Montreal', 1976 );

Company and Employee Database

---

PROBLEM

You are given a database with the following tables:

Company (
    companyName CHAR(30), 
    id          INTEGER(4) PRIMARY KEY
);
EmployeesHired...