Multiple Choice Questions – SQL

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

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

vibssingh

SQL Multiple Choice Questions – MCQ1

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 does SQL stand for?

Select the best answer

a) Structured Query Language
b) Strong Question Language
c) Structured Question Language
d) None

Answer

2. What command is used to create a new table in SQL?

Choose one option

a) CREATE TABLE
b) GENERATE TABLE
c) BUILD TABLE
d) NONE

Answer

3. Which SQL statement is used to extract data from a database?

Choose one option

a) SELECT
b) GET
c) OPEN
d) EXTRACT

Answer

4. In a database, what is a unique identifier for each record in a table called?

Choose one option

a) Primary key
b) Secondary key
c) Foreign key
d) Index key

Answer

5. What is the purpose of normalization in a database?

Choose one option

a) Increase data redundancy
b) Optimize query speed
c) Reduce data redundancy
d) Improve data security

Answer

6. What type of database model organizes data in tables with rows and columns?

a) Hierarchical
b) Network
c) Relational
d) Object-Oriented

Answer

7. What does the following statement in SQL do?

DROP TABLE Student;

a) Deletes a table called Student
b) Creates a table called Student
c) Check if there is a table called Student
d) None

Answer

8. Which SQL statement is used to update data in a database?

Choose one option

a) UPDATE
b) SAVE
c) MODIFY
d) SAVE AS

Answer

9. Which SQL statement is used to insert new data in a database?

Choose one option

a) INSERT INTO
b) ADD NEW
c) ADD RECORD
d) INSERT NEW

Answer

10. Which SQL statement is used to delete data from a database?

Choose one option

a) DELETE
b) REMOVE
c) COLLAPSE

Answer

11. Which statement(s) are mandatory in a simple SQL SELECT statement?

Choose one option

a) Select, From
b) Select, OrderBy
c) Select, Where
d) Select, GroupBy

Answer

12.  Which character is used to separate SQL statements in database systems?

Choose one option

a) :
b) %
c) _
d) ;

Answer

13. Which command should be used to change the datatype of a column in an SQL table?

Choose one option

a) CREATE
b) ALTER
c) DROP
d) TRUNCATE

Answer

14. What is the difference between the DROP and TRUNCATE commands in SQL?

Choose one option

a) DROP deletes the table, TRUNCATE deletes only the table data
b) TRUNCATE deletes the table, DROP deletes only the table data
c) No difference
d) Both commands modify table data

Answer

15. Which part of this statement is incorrect?

CREATE TABEL Students (ID int, Name varchar(50));

Choose one option

a) TABEL
b) Students
c) ID int
d) Name varchar(50)

Answer

16. With SQL, how do you select a column named “FirstName” from table named “Students”?

Choose one option

a) SELECT FirstName FROM Students
b) SELECT Students.FirstName
c) EXTRACT FirstName FROM Students
d) None

Answer

17. With SQL, how do you select all the columns from a table named “Students”?

Choose one option

a) SELECT * FROM Students
b) SELECT [all] FROM Students
c) SELECT *.Students
d) SELECT Students

Answer

18. With SQL, how do you select all the records from a table named “Students” where the value of the column “FirstName” is “Peter”?

Choose one option

a) SELECT * FROM Students WHERE FirstName='Peter'
b) SELECT * FROM Students WHERE FirstName<>'Peter'
c) SELECT [all] FROM Students WHERE FirstName LIKE 'Peter'
d) SELECT [all] FROM Students WHERE FirstName='Peter'

Answer

 19. With SQL, how do you select all the records from a table named “Students” where the value of the column “FirstName” starts with an “a”?

a) SELECT * FROM Students WHERE FirstName LIKE 'a%'
b) SELECT * FROM Students WHERE FirstName='%a%'
c) SELECT * FROM Students WHERE FirstName='a'
d) SELECT * FROM Students WHERE FirstName LIKE '%a'

Answer

20. How does a transaction ensure data integrity in SQL?

Choose one option

a) By locking the database
b) By allowing multiple users to modify data simultaneously
c) By ensuring all operations within the transaction are completed before committing
d) By automatically updating all related tables

Answer

21. Correct the syntax error in

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

a) PRIMARY
b) ID int
c) Name varchar(50)
d) CREATE TABLE

Answer

22. What is missing for this statement to be correct?

ALTER TABLE Students ADD COLUMN Email varchar(50);

a) ADD COLUMN
b) Email
c) varchar(50)
d) All Correct

Answer

23. What does the UPDATE command in SQL do?

a) Deletes a record
b) Modifies an existing record
c) Adds a new record
d) Retrieves data

Answer

24. In SQL, what is the purpose of the WHERE clause in a DELETE statement?

a) Specifies which database to use
b) Specifies which table to delete from
c) Specifies which records to delete
d) Specifies how to order the records

Answer

25. What needs to be corrected in the below query?

SELECT Name FROM Employees WHERE Age > 30 AND Department = 'HR';

a) All Correct
b) SELECT keyword
c) WHERE clause
d) AND operator

Answer

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

Additional MCQ for SQL

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

vibssingh

Multiple Choice Questions

Last Updated On

HOME

Table Of Contents

  1. Programming Languages
    1. Java
  2. Test Automation Frameworks
    1. Selenium
    2. Advance Selenium
    3. Robot Framework
    4. JUnit4
    5. TestNG
  3. API Testing
    1. Rest API
    2. Pytest Framework
  4. DevOps & Continuous Integration/Continuous Deployment (CI/CD)
    1. DevOps
    2. Jenkins
  5. Version Control Systems
    1. Git
    2. GitHub
  6. Containerization
    1. Docker
  7. Database
    1. SQL
  8. Types of Testing
    1. Security Testing
    2. Performance Testing
    3. ETL Testing

Programming Languages

Java

Java – Multiple Choice Questions and Answers – Basic Java – NEW
Java – Multiple Choice Questions and Answers – Method, Overloading, Overriding – NEW
Java – Multiple Choice Questions and Answers – Exception Handling – NEW
Java – Multiple Choice Questions and Answers – Strings – NEW
Java – Multiple Choice Questions and Answers – Arrays – Coming Soon
Java – Multiple Choice Questions and Answers – Inheritance & Polymorphism – NEW

Test Automation Frameworks

Selenium

Selenium Multiple Choice Questions – MCQ1
Selenium Multiple Choice Questions – MCQ2
Selenium Multiple Choice Questions – MCQ3

Advance Selenium

Advance Selenium Multiple Choice Questions – MCQ1
Advance Selenium Multiple Choice Questions – MCQ2

Robot Framework

Robot Framework Multiple Choice Questions – MCQ1
Robot Framework Multiple Choice Questions – MCQ2

JUnit4

JUnit Multiple Choice Questions – MCQ1

TestNG

TestNG Multiple Choice Questions – MCQ1

API Testing

Rest API

Rest API Multiple Choice Questions – MCQ1
Rest API Multiple Choice Questions – MCQ2

Pytest Framework

Pytest Multiple Choice Questions – MCQ1
Pytest Multiple Choice Questions – MCQ2

DevOps & Continuous Integration/Continuous Deployment (CI/CD)

DevOps

DevOps Multiple Choice Questions – MCQ1
DevOps Multiple Choice Questions – MCQ2

Jenkins

Jenkins Multiple Choice Questions – MCQ1
Jenkins Multiple Choice Questions – MCQ2

Version Control Systems

Git

Git Multiple Choice Questions – MCQ1
Git Multiple Choice Questions – MCQ2

GitHub

GitHub Multiple Choice Questions – MCQ1

Containerization

Docker

Docker – Basic Level – Multiple Choice Questions and Answers – MCQ1
Docker – Advance Level – Multiple Choice Questions and Answers – MCQ1

Database

SQL

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

Types of Testing

Security Testing

Multiple Choice Questions for Security Testing on API Testing
Multiple Choice Questions for Security Testing on Web Application

Performance Testing

Performance Testing – Multiple Choice Questions and Answers – MCQ1 – NEW
JMeter Multiple Choice Questions – MCQ1
JMeter Multiple Choice Questions – MCQ2

ETL Testing

ETL Testing – Multiple Choice Questions and Answers – MCQ1 – NEW
ETL Testing – Multiple Choice Questions and Answers – MCQ2 – NEW