Computer Science – 8.3 Data Definition Language (DDL) and Data Manipulation Language (DML) | e-Consult
8.3 Data Definition Language (DDL) and Data Manipulation Language (DML) (1 questions)
Login to see all questions.
Click on a question to view the answer
Model Answer
The following SQL DDL statement creates the Employees table:
CREATE TABLE Employees (
EmployeeID INT PRIMARY KEY AUTO_INCREMENT,
FirstName VARCHAR(50),
LastName VARCHAR(50),
DepartmentID INT,
Salary DECIMAL(10, 2)
);