Font size
WorksheetsDBMS Part-1
Total questions: 10
Worksheet time: 10mins
CREATE (a) Mywork;
CREATE TABLE Person (
id INT AUTO_INCREMENT PRIMARY KEY,
name _____(20),
email ______(30)
);
(a)
_____ _____ User (name, email) VALUES ('Jhon', 'abc@gmail.com');
(a)
command to print all selected data :
____ * ____ users;
(a)
CREATE TABLE Employees (
EmployeeID INT _____KEY,
EmployeeName VARCHAR(100) NOT NULL,
Age INT ____ (Age >= 18),
DepartmentID INT,
CONSTRAINT fk_dept ______ KEY (DepartmentID) REFERENCES Departments(DepartmentID)
(a)
Which of the following INSERT statements is valid for the Employees table with these constraints:
EmployeeID is PRIMARY KEY (no duplicates, no NULLs)
Age must be 18 or older
A)
INSERT INTO Employees (EmployeeID, EmployeeName, Age) VALUES (4, 'Diana', 17);
B)
INSERT INTO Employees (EmployeeID, EmployeeName, Age) VALUES (1, 'Ethan', 22);
C)
INSERT INTO Employees (EmployeeID, EmployeeName, Age) VALUES (NULL, 'Frank', 28);
D)
INSERT INTO Employees (EmployeeID, EmployeeName, Age) VALUES (3, 'Charlie', 18);
Update Alice’s age in Employees table:
UPDATE Employees
(a) Age = 31
WHERE EmployeeName = 'Alice Johnson';
Viewing All Tables in a Database:
____ ____;
(a)
Delete a record of employee named "jhon":
DELETE FROM Employees
____ EmployeeName = _____;
(a)
write command to add new column 'email' to table Employees.
_____ ___ ____ ____ ___ ____
VARCHAR(100);
(a)
