WorksheetsSQL Basics Worksheet
Total questions: 8
Worksheet time: 4mins
How do you insert a new table in SQL?
INSERT INTO table_name VALUES (column1, column2, ...)
CREATE TABLE table_name (column1 datatype, column2 datatype, ...)
ADD TABLE table_name (column1, column2, ...)
INSERT INTO TABLE table_name VALUES (column1, column2, ...)
Which query deletes a table in SQL?
DELETE TABLE table_name
DROP TABLE table_name
REMOVE TABLE table_name
CLEAR TABLE table_name
Which SQL query converts a string into uppercase?
UPPERCASE(string_column)
TOUPPER(string_column)
UPPER(string_column)
CONVERT(string_column TO UPPER)
Which query would you use to add a new column to an existing table?
ALTER TABLE table_name ADD column_name datatype
ALTER TABLE table_name INSERT column_name datatype
ALTER TABLE table_name ADD COLUMN column_name datatype
MODIFY TABLE table_name ADD COLUMN column_name datatype
How can you update a value in a table?
UPDATE table_name SET column_name = new_value WHERE condition
MODIFY table_name SET column_name = new_value WHERE condition
UPDATE table_name WHERE condition SET column_name = new_value
CHANGE table_name SET column_name = new_value WHERE condition
How would you delete data in a table without removing the table itself?
REMOVE FROM table_name
DELETE FROM table_name
TRUNCATE table_name
DROP FROM table_name
Which query allows you to rename a table?
RENAME TABLE old_name TO new_name
CHANGE TABLE old_name TO new_name
ALTER TABLE old_name RENAME TO new_name
UPDATE TABLE old_name RENAME new_name
Which SQL command is used to modify an existing column's datatype?
ALTER TABLE table_name MODIFY column_name new_datatype
ALTER TABLE table_name CHANGE column_name new_column_name new_datatype
MODIFY TABLE table_name column_name new_datatype
ALTER TABLE table_name CHANGE column_name TO new_datatype
