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 Tables in SQL

by Quiz Orbit Team

SQL tables are the backbone of any relational database, storing structured data in rows and columns. This quiz tests your knowledge of table creation, constraints, and management to help you design efficient and reliable databases.

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 SQL statement correctly creates a table?
- CREATE users TABLE (id INT, name VARCHAR(50));
- TABLE CREATE users (id INT, name VARCHAR(50));
- CREATE TABLE users (id INT, name VARCHAR(50));
- NEW TABLE users (id INT, name VARCHAR(50));
Correct
Incorrect
Question 2 of 15
2. Question
Which constraint ensures that a column cannot have duplicate values?
- NOT NULL
- UNIQUE
- PRIMARY KEY
- CHECK
Correct
Incorrect
Question 3 of 15
3. Question
What is the main function of a PRIMARY KEY?
- To create an index
- To uniquely identify each row
- To enforce a default value
- To store foreign references
Correct
Incorrect
Question 4 of 15
4. Question
Which command is used to delete all rows from a table but keep its structure?
- DROP
- REMOVE
- TRUNCATE
- DELETE TABLE
Correct
Incorrect
Question 5 of 15
5. Question
Which statement correctly adds a new column to an existing table?
- ADD COLUMN age INT TO users;
- ALTER TABLE users ADD age INT;
- INSERT COLUMN age INT TO users;
- MODIFY TABLE users ADD age INT;
Correct
Incorrect
Question 6 of 15
6. Question
What does a FOREIGN KEY constraint do?
- Prevents NULLs
- Ensures referential integrity between two tables
- Automatically creates indexes
- Stores backup copies
Correct
Incorrect
Question 7 of 15
7. Question
Which constraint ensures a column cannot have NULL values?
- PRIMARY KEY
- NOT NULL
- CHECK
- DEFAULT
Correct
Incorrect
Question 8 of 15
8. Question
Which is the correct way to remove a table completely?
- DELETE TABLE users;
- DROP TABLE users;
- REMOVE users;
- TRUNCATE users;
Correct
Incorrect
Question 9 of 15
9. Question
A composite key is:
- A key combining multiple columns
- A foreign key and primary key together
- A key with default values
- A temporary key
Correct
Incorrect
Question 10 of 15
10. Question
Which command changes a table name in most SQL databases?
- ALTER TABLE old_name RENAME TO new_name;
- UPDATE TABLE old_name SET NAME=new_name;
- MODIFY TABLE old_name NAME new_name;
- CHANGE old_name new_name;
Correct
Incorrect
Question 11 of 15
11. Question
What does a CHECK constraint do?
- Validates values based on a condition
- Ensures uniqueness
- Blocks NULL values
- Creates indexes
Correct
Incorrect
Question 12 of 15
12. Question
What happens when you try to insert a row that violates a PRIMARY KEY?
- The row is inserted with a warning
- The database rejects it with an error
- The existing row is replaced
- The value becomes NULL
Correct
Incorrect
Question 13 of 15
13. Question
Which statement creates a table with an auto-incrementing ID in MySQL?
- CREATE TABLE t (id INT AUTO_INCREMENT PRIMARY KEY);
- CREATE TABLE t (id SERIAL PRIMARY KEY);
- Both A and B
- None of the above
Correct
Incorrect
Question 14 of 15
14. Question
Which table type is automatically dropped after a session ends?
- Permanent table
- Global temporary table
- Local temporary table
- Indexed table
Correct
Incorrect
Question 15 of 15
15. Question
Which command modifies a column’s data type?
- ALTER TABLE users MODIFY COLUMN name VARCHAR(100);
- CHANGE TABLE users COLUMN name VARCHAR(100);
- ALTER users TYPE COLUMN name VARCHAR(100);
- UPDATE users name TYPE VARCHAR(100);
Correct
Incorrect

Summary

These SQL Tables MCQs strengthen your skills in creating, altering, and managing relational database tables. Mastering these fundamentals helps ensure data integrity, performance, and efficient database design.

Tags: quiz on sql table quiz on sql tables quiz on tables in sql SQL Quiz sql tables mcq sql tables 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 DDL – Data Definition Language in SQL
Previous story Quiz on Power BI Introduction

About Us
Contact Us
Privacy Policy
Disclaimer

Quiz Orbit © 2026. All Rights Reserved.