SQL Database Creation and Management Quiz

What is the primary purpose of the SQL CREATE TABLE statement?

• To define the structure of a new database table
• To delete existing database records
• To insert data into a table
• To modify existing table columns

In the example CREATE TABLE statement, which field is explicitly defined as a PRIMARY KEY?

• Price
• Currency
• ProductID
• Description

Which data type would be most appropriate for storing a product's price with decimal precision?

• CHAR
• INTEGER
• CURRENCY
• VARCHAR

What does the NOT NULL constraint indicate in a table definition?

• The field must have a unique value
• The field is optional
• The field cannot be left blank
• The field cannot contain zero

Which SQL statement is used to add a new column to an existing table?

• ADD COLUMN
• MODIFY TABLE
• ALTER TABLE
• INSERT COLUMN

In a relational database, what is the primary purpose of a FOREIGN KEY?

• To establish relationships between tables
• To validate user input
• To encrypt data
• To create a primary key

Which SQL statement is used to insert a new record into a table?

• ADD RECORD
• INSERT INTO
• CREATE ENTRY
• NEW RECORD

What technique prevents simultaneous conflicting updates in a multi-user database?

• Record locking
• Password protection
• Network segmentation
• Data encryption

Which data type is most suitable for storing a short text description?

• CHAR
• INTEGER
• VARCHAR
• CURRENCY

What is the purpose of the DELETE statement in SQL?

• To modify existing records
• To remove a specific record from a table
• To create a new table
• To add new columns