Skip to content

Search for:

GK Quiz
Sports Quiz
Space Quiz
Festivals Quiz

Python Quiz
GK Quiz
Space Quiz
Sports Quiz

Search for:

Test Your Knowledge

SQL Quiz
0

Quiz on DDL – Data Definition Language in SQL

by Quiz Orbit Team

Data Definition Language (DDL) in SQL consists of commands used to define and manage the structure of database objects like tables, schemas, indexes, and views. This quiz helps learners understand core DDL concepts including CREATE, ALTER, DROP, and TRUNCATE.

Time limit: 0

Quiz Summary

0 of 15 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 15 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

Current
Review / Skip
Answered
Correct
Incorrect

Question 1 of 15
1. Question
Which of the following is not a DDL command?
- CREATE
- INSERT
- DROP
- ALTER
Correct
Incorrect
Question 2 of 15
2. Question
What does the CREATE command do in SQL?
- Creates a new database object
- Updates existing records
- Deletes data from table
- Modifies stored procedures
Correct
Incorrect
Question 3 of 15
3. Question
Which command is used to remove a table structure permanently from a database?
- DELETE
- ERASE
- TRUNCATE
- DROP
Correct
Incorrect
Question 4 of 15
4. Question
Which DDL command is used to modify an existing table’s structure?
- UPDATE
- ALTER
- MODIFY
- CHANGE
Correct
Incorrect
Question 5 of 15
5. Question
What happens when you run TRUNCATE TABLE employees;?
- Deletes table structure
- Deletes all rows permanently
- Deletes selected rows
- Deletes all rows and cannot be rolled back
Correct
Incorrect
Question 6 of 15
6. Question
Can the ALTER command be used to rename a table?
- Yes
- No
- Only in MySQL
- Only with DELETE
Correct
Incorrect
Question 7 of 15
7. Question
Which DDL command is used to create a database?
- NEW DATABASE
- MAKE DATABASE
- CREATE DATABASE
- INIT DATABASE
Correct
Incorrect
Question 8 of 15
8. Question
What does the DROP TABLE students; command do?
- Deletes data only
- Deletes table structure and data
- Renames the table
- Archives the table
Correct
Incorrect
Question 9 of 15
9. Question
Which command removes all rows from a table but keeps the structure intact?
- DELETE
- REMOVE
- TRUNCATE
- DROP
Correct
Incorrect
Question 10 of 15
10. Question
Which DDL command is used to change the data type of a column?
- MODIFY
- CHANGE
- ALTER
- UPDATE
Correct
Incorrect
Question 11 of 15
11. Question
What does CREATE INDEX do?
- Inserts new rows
- Removes rows
- Improves data retrieval speed
- Updates existing records
Correct
Incorrect
Question 12 of 15
12. Question
What happens if you try to DROP a table that doesn’t exist?
- It ignores the command
- It throws an error
- It deletes some columns
- It renames the table
Correct
Incorrect
Question 13 of 15
13. Question
Which of the following statements about TRUNCATE is true?
- It logs each row deletion
- It activates ON DELETE triggers
- It activates ON DELETE triggers
- It keeps the old data in buffer
Correct
Incorrect
Question 14 of 15
14. Question
Can we use ALTER to add a new constraint to an existing table?
- No, only CREATE can do that
- Only for primary key
- Yes
- Only for foreign key
Correct
Incorrect
Question 15 of 15
15. Question
Which DDL command allows renaming a column?
- UPDATE
- ALTER TABLE
- CHANGE COLUMN
- Both B and C
Correct
Incorrect

Summary

This quiz on SQL DDL (Data Definition Language) equips learners with practical knowledge of key schema-level commands such as CREATE, ALTER, DROP, and TRUNCATE. Essential for database architects, developers, and interview candidates.

Tags: data definition language quiz with answers ddl commands in sql ddl quiz quiz on data definition language quiz on ddl in sql SQL Quiz

Quiz Orbit Team

At QuizOrbit, our team specializes in fun, informative quizzes across topics like general knowledge, technology, and entertainment. Boost your knowledge with our expert-designed quizzes.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Δ

Next story Quiz on Components of Power BI
Previous story Quiz on Tables in SQL

About Us
Contact Us
Privacy Policy
Disclaimer

Quiz Orbit © 2026. All Rights Reserved.