DDL COMMANDS
You are creating a brand-new database for a library system called LibraryDB.
What SQL command should you use?
CREATE DATABASE LibraryDB;
You want to add a new book into the Books table.
Which SQL command will you use?
INSERT
"I create a new database."
Who am I?
CREATE DATABASE
TRUNCATE TABLE removes the table structure.
FALSE
Arrange these commands in the correct order when creating a database.
USE
CREATE DATABASE
CREATE TABLE
INSERT
SELECT
CREATE DATABASE
USE
CREATE TABLE
INSERT
SELECT
You have already created LibraryDB, but MySQL doesn't know which database you want to use.
What command should you execute?
USE LibraryDB;
Your teacher asks you to display every book stored inside the Books table.
Which SQL command will you use?
SELECT
"I remove every record but keep the table."
Who am I?
TRUNCATE TABLE
DROP TABLE removes the structure and all data.
TRUE
Which command should be used first?
INSERT INTO Students...
OR
CREATE TABLE Students...
✅ CREATE TABLE
Inside LibraryDB, you need to create a table called Books.
Which command starts the process?
CREATE TABLE
The price of a book changed from ₱500 to ₱450.
Which SQL command updates the record?
UPDATE
"I permanently delete the entire table."
Who am I?
DROP TABLE
UPDATE changes existing data.
TRUE
Which SQL group does CREATE TABLE belong to?
A. DML
B. DDL
C. DCL
D. TCL
B. DDL
Your Books table is missing a new column called Author.
Which SQL command allows you to modify the table?
ALTER TABLE
One book has been discontinued.
You want to remove only that record.
Which SQL command should you use?
DELETE
"I retrieve information from a table."
Who am I?
SELECT
DELETE always removes every record in a table.
FALSE
It only removes every record if you omit the WHERE clause.
Which SQL group does INSERT belong to?
A. DDL
B. DML
C. DCL
D. TCL
B. DML
You no longer need the Books table.
You want to permanently remove both the table and all its records.
Which command should you use?
DROP TABLE
You accidentally forgot the WHERE clause when running an UPDATE statement.
What happens?
A. Only one record changes
B. The database crashes
C. Every row is updated
D. Nothing happens
C.
Every row is updated
"I add a new row into a table."
Who am I?
INSERT
CREATE TABLE is a DML command.
FALSE
(It belongs to DDL.)
You are creating a Student Information System from scratch.
Place these SQL commands in the correct order: