HOME

Welcome to the SQL Quiz!

SQL Multiple Choice Questions – MCQ1

Answers

1) a) Structured Query Language

2) a) CREATE TABLE

CREATE TABLE Students (ID int PRIMARY KEY, Name varchar(50));

3) a) SELECT

SELECT column1, column2, ... FROM table_name;

4) a) Primary Key

5) c) Reduce data redundancy

6) c) Relational

7) a) Deletes a table called Student

8) a) UPDATE

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

9) a) INSERT INTO

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

10) a) DELETE

DELETE FROM table_name WHERE condition;

11) a) Select, From

12) d) ;

13) b) ALTER

ALTER TABLE table_name
ADD column_name datatype;

14) a) DROP deletes the table, TRUNCATE deletes only the table data

15) a) TABEL

16)

a) SELECT FirstName FROM Students

17)

a) SELECT * FROM Students

18)

a) SELECT * FROM Students WHERE FirstName='Peter'

19)

a) SELECT * FROM Students WHERE FirstName LIKE 'a%'

20) c) By ensuring all operations within the transaction are completed before committing

21) a) PRIMARY

It should be PRIMARY KEY instead of PRIMARY.

CREATE TABLE Students (ID int PRIMARY KEY, Name varchar(50));

22) d) All Correct

23) b) Modifies an existing record

24) c) Specifies which records to delete

25) a) All Correct