Basic Command 1
This command is used to create a new database. What is it?
A) CREATE TABLE
B) CREATE DATABASE
C) INSERT INTO
D) DROP DATABASE
B) CREATE DATABASE
This command is used to add a new record into a table. What is it?
A) INSERT INTO
B) UPDATE
C) SELECT
D) ADD
A) INSERT INTO
To retrieve data from a table, which command is used?
A) INSERT
B) DELETE
C) SELECT
D) UPDATE
C) SELECT
This command is used to modify the structure of an existing table. What is it?
A) CREATE TABLE
B) ALTER TABLE
C) UPDATE
D) RENAME TABLE
B) ALTER TABLE
This command deletes all rows from a table without removing the table structure. What is it?
A) DROP
B) TRUNCATE
C) DELETE
D) REMOVE
B) TRUNCATE
To remove a column from a table, which SQL command is used?
A) DROP COLUMN
B) ALTER TABLE
C) REMOVE COLUMN
D) DELETE COLUMN
B) ALTER TABLE
To modify data in a table, which SQL command is used?
A) INSERT
B) UPDATE
C) DELETE
D) SELECT
B) UPDATE
This command is used to add a new column to an existing table. What is it?
A) ADD COLUMN
B) ALTER TABLE
C) CREATE COLUMN
D) INSERT COLUMN
B) ALTER TABLE
This command is used to remove a table and all its data from the database. What is it?
A) DROP TABLE
B) DELETE
C) TRUNCATE TABLE
D) REMOVE
A) DROP TABLE
To change the name of an existing table, this command is used. What is it?
A) UPDATE TABLE
B) RENAME TABLE
C) ALTER TABLE
D) CHANGE TABLE
B) RENAME TABLE