Chapter 4 - SQL Basics Quiz

What is the primary purpose of SQL?

• To design user interfaces

• To store multimedia files

• To query and manage relational databases

• To write JavaScript programs

Which SQL data type is best suited for storing large text data?

• INT

• VARCHAR

• TEXT

• BOOLEAN

Which SQL data type is used to store a date without a time component?

• DATETIME

• TIMESTAMP

• DATE

• TIME

Which type of SQL statement is used to modify the structure of a table?

• DDL

• DML

• DCL

• TCL

Which SQL statement category is used for managing user access and permissions?

• DDL

• DML

• DCL

• TCL

Which of the following is NOT a type of SQL statement?

• Data Definition Language (DDL)

• Data Query Language (DQL)

• Transaction Control Language (TCL)

• HTML Control Language (HCL)

Which SQL command is used to create a new database?

• CREATE

• USE

• ALTER

• DROP

What happens when the DROP TABLE command is executed?

• The table structure remains but all records are deleted

• The table and its structure are permanently removed

• The table is hidden but still exists in the database

• The table is renamed

Which SQL command is used to change an existing table’s structure?

• CREATE

• ALTER

• DROP

• UPDATE

Which of the following is NOT a valid SQL constraint?

• PRIMARY KEY

• UNIQUE

• CHANGE COLUMN

• CHECK