SQL Test 1

Which SQL keyword is used to insert data into a table?

• SELECT
• INSERT
• UPDATE
• DELETE

Which SQL keyword is used to update data in a table?

• SELECT
• INSERT
• UPDATE
• DELETE

Which SQL keyword is used to delete data from a table?

• SELECT
• INSERT
• UPDATE
• DELETE

What is the correct syntax for creating a database?

• CREATE TABLE database_name;
• CREATE DATABASE database_name;
• CREATE SCHEMA database_name;
• CREATE db database_name;

What is the correct syntax for dropping a table?

• DROP TABLE table_name;
• DELETE TABLE table_name;
• REMOVE TABLE table_name;
• TRUNCATE TABLE table_name;

What is the correct syntax for dropping a database?

• DROP DB database_name;
• DELETE DATABASE database_name;
• DROP DATABASE database_name;
• REMOVE DATABASE database_name;

What is the correct syntax for altering a table to add a new column?

• ALTER TABLE table_name ADD column_name data_type;
• ALTER TABLE table_name MODIFY column_name data_type;
• ALTER TABLE table_name RENAME column_name TO new_column_name;
• ALTER TABLE table_name DROP column_name;

What is the correct syntax for altering a table to modify an existing column's data type?

• ALTER TABLE table_name ADD column_name data_type;
• ALTER TABLE table_name MODIFY column_name data_type;
• ALTER TABLE table_name RENAME column_name TO new_column_name;
• ALTER TABLE table_name DROP column_name;

What is the correct syntax for adding a NOT NULL constraint to an existing column?

• ALTER TABLE table_name ADD CONSTRAINT constraint_name UNIQUE (column_name);
• ALTER TABLE table_name ADD CONSTRAINT constraint_name CHECK (column_name IS
• ALTER TABLE table_name MODIFY column_name data_type NOT NULL;
• ALTER TABLE table_name DROP CONSTRAINT constraint_name;

What is the correct syntax for inserting a new row into a table?

• INSERT INTO table_name (column_name) VALUES (value);
• INSERT INTO table_name (column1_name, column2_name) VALUES (value1, value2)
• INSERT INTO table_name VALUES (value);
• INSERT INTO (column_name) VALUES (value);