Databse

vibssingh

SQL Multiple Choice Questions – MCQ3

Last Updated On

HOME

Welcome to the SQL Quiz! This blog post features 25 multiple-choice questions that explore essential concepts of SQL.

1. Which of the following statement is true about views in SQL?

Select the best answer

a) We can delete but not insert rows in a view
b) We cannot insert and delete rows in a view
c) We can insert but not delete rows in a view
d) We can insert and delete rows in a view

Answer

2. Which SQL keyword is used to sort the data returned by a SELECT statement?

Choose one option

a) Group
b) Order
c) Group By
d) Order By

Answer

3. NULL value is different from a zero value.

Choose one option

a) True
b) False

Answer

4. WHERE clause cannot be used with _

Choose one option

a) Select
b) Delete
c) Drop
d) Update

Answer

5. Which operator in the where clause signifies “Not Equal”?

a) <>
b)
c) <_>
d) <->

Answer

6. Which clause is used in SQL to fetch limited number of records from a table?

Choose one option

a) Select
b) Select limit
c) Select top
d) Top

Answer

7. Mysql supports which of the following clause to select a limited number of rows from a table?

a) Select
b) Select top
c) Top
d) Limit

Answer

8. What is missing in

ALTER TABLE Employees ADD CHECK (Age >= 18);

Choose one option

a) ALTER TABLE
b) ADD CHECK
c) (Age >= 18)
d) All Correct

Answer

9. In SQL, what does the logical operator AND do when used in a WHERE clause?

Choose one option

a) Selects a record if either condition is true
b) Selects a record if both conditions are true
c) Negates a condition
d) None of the above

Answer

10. In SQL, how does the compound operator ‘+=’ function?

Choose one option

a) Adds two values
b) Adds a value to a column’s existing value
c) Subtracts one value from another
d) Concatenates strings

Answer

11. The NOT NULL constraint enforces a) column to not accept NULL values.

Choose one option

a) True
b) False

Answer

12.  Correct the syntax error in

UPDATE Products SET Price = Price * 1.1 WHERE Price < 100 OR Price > 200;

Choose one option

a) * 1.1
b) WHERE
c) OR
d) No syntax error

Answer

13. Identify the error

SELECT Name FROM Employees WHERE NOT (Age < 30 AND Department = 'Sales');

Choose one option

a) NOT operator
b) < 30
c) AND
d) No error

Answer

14. Identify the mistake in

SELECT * FROM Employees WHERE Department = 'HR' XOR Department = 'Finance';

Choose one option

a) XOR operator
b) = ‘HR’
c) = ‘Finance’
d) No mistake, the statement is correct

Answer

15. What needs to be changed in

UPDATE Employees SET Salary *= 2 WHERE YearsOfExperience > 5;

Choose one option

a) *= 2
b) WHERE
c) YearsOfExperience > 5
d) All Correct

Answer

16. In an SQL query, what role does HAVING play without a GROUP BY clause?

Choose one option

a) It functions as a WHERE clause
b) It has no effect
c) It causes an error
d) It filters aggregated results

Answer

17. What happens if you use a column in the SELECT statement that is not in the GROUP BY clause?

Choose one option

a) The query fails
b) The query succeeds, and the column shows arbitrary values
c) The query is automatically corrected
d) The column is ignored

Answer

18. Identify the error in

SELECT Department, COUNT(*) FROM Employees GROUP BY Salary;

Choose one option

a) SELECT Department
b) COUNT(*)
c) GROUP BY Salary
d) No error

Answer

 19. What needs to be corrected in

SELECT AVG(Salary) AS AverageSalary FROM Employees HAVING AverageSalary > 50000;

Choose one option

a) SELECT AVG(Salary)
b) AS AverageSalary
c) FROM Employees
d) HAVING AverageSalary > 50000

Answer

20. Correct the syntax error in

SELECT Name, Department, COUNT(*) FROM Employees WHERE Department = 'Sales' GROUP BY Department;

Choose one option

a) SELECT Name
b) Department
c) COUNT(*)
d) WHERE Department = ‘Sales’

Answer

21. Identify the error

SELECT Department, SUM(Salary) FROM Employees GROUP BY Department HAVING COUNT(*) > 5;

Choose one option

a) SELECT Department
b) SUM(Salary)
c) GROUP BY Department
d) No Error

Answer

22. What is incorrect in

SELECT * FROM Employees ORDER BY 3;

Choose one option

a) SELECT *
b) FROM Employees
c) ORDER BY 3
d) All Correct

Answer

23. Identify the mistake in

SELECT Department, MAX(Salary) FROM Employees WHERE MAX(Salary) > 50000 GROUP BY Department;

Choose one option

a) SELECT Department
b) MAX(Salary)
c) HERE MAX(Salary) > 50000
d) GROUP BY Department

Answer

24. What needs correction?

SELECT Department, COUNT(EmployeeID) FROM Employees GROUP BY Department HAVING COUNT(EmployeeID) > ALL (SELECT COUNT(EmployeeID) FROM Employees GROUP BY Department);

Choose one option

a) ALL operator
b) COUNT(EmployeeID)
c) No error
d) subquery

Answer

25. What is wrong in

SELECT Department, COUNT(*) AS TotalEmployees FROM Employees GROUP BY Department HAVING TotalEmployees > 5 ORDER BY TotalEmployees;

Choose one option

a) SELECT Department
b) COUNT(*) AS TotalEmployees
c) HAVING clause misuse
d) ORDER BY TotalEmployees

Answer

====================================================================

Additional MCQ for SQL

SQL Multiple Choice Questions – MCQ2
SQL Multiple Choice Questions – MCQ3 

vibssingh

SQL Multiple Choice Questions – MCQ2

Last Updated On

HOME

Welcome to the SQL Quiz! This blog post features 25 multiple-choice questions that explore essential concepts of SQL.

1. What is a database?

Select the best answer

a) Organized collection of information that cannot be accessed, updated, and managed
b) Collection of data or information without organizing
c) Organized collection of data or information that can be accessed, updated, and managed
d) Organized collection of data that cannot be updated

Answer

2. In which of the following formats data is stored in the database management system?

Choose one option

a) Image
b) Text
c) Table
d) Graph

Answer

3. What needs correction in

SELECT * FROM Employees WHERE Salary = 5000 AND Department = 'HR';"

Choose one option

a) All Correct
b) = in Salary
c) AND
d) = in Department

Answer

4. Identify the error in

UPDATE Employees SET Salary = Salary * 1.05 WHERE;

Choose one option

a) UPDATE keyword
b) SET keyword
c) WHERE clause
d) No error

Answer

5. The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

a) True
b) False

Answer

6. With SQL, how do you select all the records from a table named “Employees” where the “FirstName” is “Peter” and the “LastName” is “Jackson”?

Choose one option

a) SELECT * FROM Employees WHERE FirstName='Peter' AND LastName='Jackson'

b) SELECT FirstName='Peter', LastName='Jackson' FROM Employees

c) SELECT * FROM Employees WHERE FirstName<>'Peter' AND LastName<>'Jackson'

d)  SELECT * FROM Employees WHERE FirstName='Jackson' AND LastName='Peter'

Answer

7. What is missing in the following statement?

INSERT INTO Employees (Name, Department) VALUES ('John', 'Sales');

a) All Correct
b) Employee ID
c) a) WHERE clause
d) Additional column names

Answer

8. Identify the error in

SELECT * FROM Orders WHERE OrderDate >= '2023-01-01' OR >= '2023-06-01';

Choose one option

a) OR operator
b) >= ‘2023-06-01’
c) No error
d) The date format

Answer

9. Correct the syntax error in

DELETE FROM Employees HAVING Age < 25;

Choose one option

a) DELETE keyword
b) FROM keyword
c) HAVING keyword
d) No syntax error

Answer

10. Identify the error

UPDATE Employees SET Age = Age + 1 WHERE Department IN ('Sales', 'HR') AND Age >= 30;

Choose one option

a) The IN operator
b) The AND operator
c) No error
d) The SET keyword

Answer

11. With SQL, how do you select all the records from a table named “Employees” where the “LastName” is alphabetically between (and including) “Hansen” and “Pettersen”?

Choose one option

a) SELECT * FROM Employees WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

b) SELECT * FROM Employees WHERE LastName>'Hansen' AND LastName<'Pettersen'

c) SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Employees

d) None

Answer

12.  Which SQL statement is used to return only different values?

Choose one option

a) SELECT DISTINCT
b) SELECT DIFFERENT
c) SELECT UNIQUE
d) SELECT TOP

Answer

13. Which SQL keyword is used to sort the result-set?

Choose one option

a) ORDER BY
b) ORDER
c) SORT
d) SORT BY

Answer

14. With SQL, how can you return all the records from a) table named “Employees” sorted descending by “FirstName”?

Choose one option

a) SELECT * FROM Employees ORDER BY FirstName DESC

b) SELECT * FROM Employees SORT 'FirstName' DESC

c) SELECT * FROM Employees SORT BY 'FirstName' DESC

d) SELECT * FROM Employees ORDER FirstName DESC

Answer

15. With SQL, how can you insert a new record into the “Employees” table?

Choose one option

a) INSERT INTO Employees VALUES ('Jimmy', 'Jackson')

b) INSERT VALUES ('Jimmy', 'Jackson') INTO Employees

c) INSERT ('Jimmy', 'Jackson') INTO Employees

d) INSERT INTO Table Employees VALUES ('Jimmy', 'Jackson')

Answer

16. With SQL, how can you insert “Olsen” as the “LastName” in the “Persons” table?

Choose one option

a) INSERT INTO Persons (LastName) VALUES ('Olsen')

b) INSERT ('Olsen') INTO Persons (LastName)

c) INSERT INTO Persons ('Olsen') INTO LastName

d) All incorrect

Answer

17. What is the primary purpose of the GRANT command in SQL?

Choose one option

a) To create a new table
b) To delete data from a table
c) To give users access privileges
d) To update table data

Answer

18. What does the REVOKE command do in SQL?

Choose one option

a) Adds new user accounts
b) Removes specific access privileges from users
c) Deletes tables
d) Inserts data

Answer

 19. Which part of this statement is incorrect?

GRANT SELECT ON Employees TO user123;

Choose one option

a) GRANT
b) SELECT ON
c) Employees
d) All Correct

Answer

20. Which part of this statement is incorrect?

REVOKE INSERT, UPDATE ON Database FROM user123;

Choose one option

a) REVOKE
b) INSERT, UPDATE
c) ON Database
d) FROM user123

Answer

21. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Employees table?

Choose one option

a) UPDATE Employees SET LastName='Nilsen' WHERE LastName='Hansen'

b) MODIFY Employees SET LastName='Nilsen' WHERE LastName='Hansen'

c) UPDATE Employees SET LastName='Hansen' INTO LastName='Nilsen'

d) MODIFY Employees SET LastName='Hansen' INTO LastName='Nilsen

Answer

22. With SQL, how can you delete the records where the “FirstName” is “Peter” in the Employees Table?

Choose one option

a) DELETE FROM Employees WHERE FirstName = 'Peter'

b) DELETE FirstName='Peter' FROM Employees

c) DELETE ROW FirstName='Peter' FROM Employees

d) All are incorrect

Answer

23. With SQL, how can you return the number of records in the “Employees” table?

Choose one option

a) SELECT COUNT(*) FROM Employees

b) SELECT COLUMNS(*) FROM Employees

c) SELECT LEN(*) FROM Employees

d) SELECT NO(*) FROM Employees

Answer

24. What is the most common type of join?

Choose one option

a) JOINED
b) JOINED TABLE
c) INSIDE JOIN
d) INNER JOIN

Answer

25. Which operator is used to select values within a range?

Choose one option

a) BETWEEN
b) WITHIN
c) RANGE

Answer

====================================================================