Scenario: Your company has an opening for a junior database administrator. As a senior database administrator, your manager has developed the following questions to ask potential new hires and he wants you to provide the answers to the following questions so they can be forwarded to Human Resources:
- Explain Data Manipulation Language (DML).
- What is the difference between Data Definition Language (DDL) and Data Control Languages (DCL)?
- Provide an example of an SQL query that creates and executes four individual tables; Student, Class, InstructorID, and Room Number with not null and default constraints.