SQL Basics MCQs with Answers

Past Paper MCQ

NOT a SQL keyword:

• A.SELECT
• B.INSERT
• C.SUBMIT
• D.UPDATE

Past Paper MCQ

"SQL" stands for:

• A.Standard Query Language
• B.Simple Query Language
• C.Sequential Query Language
• D.Structured Query Language

Past Paper MCQ

When a table is created in a database, which statement is correct regarding its fields?

• A.Fields are fixed and cannot be modified once the table is created
• B.Fields can be added and deleted as needed
• C.Fields can only be added but never deleted
• D.Fields can only be deleted but never added

Past Paper MCQ

In SQL, which command is used to remove a table?

• A.DELETE TABLE
• B.DROP TABLE
• C.REMOVE TABLE
• D.ERASE TABLE

Past Paper MCQ

The SQL command used to retrieve data from a database table is?

• A.SELECT
• B.INSERT
• C.UPDATE
• D.DELETE

Past Paper MCQ

SQL stands for _?

• A.Sequential Query Language
• B.Simple Query Language
• C.Standard Query Language
• D.Structured Query Language

Past Paper MCQ

What does SQL stand for in database terminology?

• A.Standard Query Library
• B.Simple Query Logic
• C.Structured Query Language
• D.Sequential Query Language

Past Paper MCQ

Which of the following table constraints prevents the entry of duplicate rows?

• A.Primary Key
• B.Unique
• C.Foreign Key
• D.Check

Past Paper MCQ

A query can be used to select data from which of the following sources?

• A.Tables
• B.Queries
• C.Both A & B
• D.None of these

What is the strictest transaction isolation level available in SQL Server?

• A.Read Uncommitted
• B.Read Committed
• C.Serializable
• D.Repeatable Read