SQL Basics MCQs with Answers

Past Paper MCQ

Which SQL query would you use to find employees earning more than $5000 a month?

• A.SELECT * FROM employees WHERE salary = 5000;
• B.SELECT * FROM employees WHERE salary < 5000;
• C.SELECT * FROM employees WHERE salary > 5000;
• D.SELECT * FROM employees WHERE salary >= 5000;

What is the term for a virtual table in a database that is created from the result of a SQL query on other tables?

• A.Trigger
• B.Index
• C.Cursor
• D.View

In SQL, which type of join includes all records from the right table and the matched records from the left table?

• A.Left Outer Join
• B.Inner Join
• C.Right Outer Join
• D.Cross Join

Which language is specifically used for creating and managing databases by storing, retrieving, or updating data?

• A.Python
• B.Structured Query Language
• C.Java
• D.HTML

What is the SQL command used to fetch data from a database table?

• A.RETRIEVE
• B.FETCH
• C.SELECT
• D.GET

Which SQL command is used to remove a column from an existing table?

• A.ALTER TABLE TableName DROP COLUMN ColumnName
• B.DELETE COLUMN ColumnName FROM TableName
• C.REMOVE COLUMN ColumnName FROM TableName
• D.MODIFY TABLE TableName DROP ColumnName

What is the standard format for entering a date into a database when inserting data?

• A.DD-MM-YYYY
• B.YYYY-MM-DD
• C.MM-DD-YYYY
• D.DD/MM/YYYY

What term is used for a dynamic mathematical calculation that displays a single value for a specific field in databases?

• A.Trigger
• B.Scalar function
• C.Aggregate function
• D.Stored procedure

What is the purpose of the HAVING clause in SQL queries?

• A.Used to delete duplicate rows from the result set
• B.Used to sort the result set in ascending or descending order
• C.Used to join two or more tables based on a common column
• D.Acts like a WHERE clause but is used for groups rather than rows

Which operator is used to check for the absence of data in a database column?

• A.IS NULL
• B.IS EMPTY
• C.NOT EXISTS
• D.IS BLANK