SQL Basics

START LEARNING

#1. What does SQL stand for?

Standard Query Language

Structured Query Language

Simplified Query Language

Sequential Query Language

#2. Which SQL statement is used to retrieve data from a database?

RETRIEVE

FETCH

GET

SELECT

#3. Which keyword is used to sort the result set in SQL?

SORT BY

GROUP BY

ORDER BY

ARRANGE

#4. Which function is used to return the total number of rows in a table?

SUM()

COUNT()

ROWS()

TOTAL()

#5. What is the correct syntax to create a new table?

CREATE TABLE table_name;

CREATE NEW TABLE table_name;

NEW TABLE CREATE table_name;

CREATE table_name TABLE;

#6. Which SQL statement is used to delete data from a table?

REMOVE

DELETE ROW

DROP

DELETE

#7. How do you select all columns from a table named “users”?

SELECT ALL FROM users;

SELECT * FROM users;

SELECT users.* FROM users;

SELECT users.ALL FROM users;

#8. What is the purpose of the WHERE clause in SQL?

To join two tables

To group data

To filter rows based on a condition

To sort data

#9. Which operator is used to search for a specified pattern in SQL?

FIND

MATCH

PATTERN

#10. Which command is used to modify an existing table in SQL?

UPDATE

CHANGE

MODIFY

ALTER

#11. Which SQL clause is used to group rows with the same values?

ORDER BY

FILTER BY

GROUP BY

SORT BY

#12. What does the SQL INNER JOIN do?

None of the above

Returns only matching rows between tables

Returns non-matching rows

Combines all rows from two tables

#13. Which function is used to calculate the total of a numeric column?

TOTAL()

COUNT()

AVG()

SUM()

#14. What is the result of a LEFT JOIN in SQL?

All rows from the left table and matching rows from the right

Only rows from the right table

All rows from the right table and matching rows from the left

Rows from both tables

#15. Which command is used to delete all records from a table but keeps the structure?

TRUNCATE

REMOVE

DELETE

DROP

#16. How do you find records where a column matches a specific pattern?

MATCH

FIND

#17. What is the default sorting order in SQL?

Random

Ascending

None

Descending

#18. Which clause is used to filter grouped data?

FILTER

WHERE

GROUP BY

HAVING

#19. Which SQL statement adds new rows to a table?

UPDATE

APPEND

INSERT INTO

ADD ROW

#20. Which operator is used to combine multiple conditions in a WHERE clause?

A). AND

D). Both A and B

C). NOT

B). OR

#21. Which SQL statement is used to return unique values?

SELECT UNIQUE

SELECT DISTINCTIVE

SELECT DIFFERENT

SELECT DISTINCT

#22. Which SQL function returns the average value of a numeric column?

MID()

AVERAGE()

AVG()

MEAN()

#23. What does the SQL command ALTER TABLE do?

C). Changes the data type of a column

A). Deletes a table

B). Modifies a table structure

D). Both B and C

#24. Which operator is used to combine the result of multiple SELECT statements?

MERGE

UNION

CONNECT

JOIN

#25. How do you specify a condition for rows to be included in a result set?

WHERE

USING

WHEN

#26. What will the following query do? SELECT * FROM employees WHERE salary BETWEEN 5000 AND 10000;

Return salaries between 5000 and 10000 (inclusive)

Return salaries greater than 5000

Return salaries less than 10000

Return no rows

#27. Which clause is used to specify the number of rows to return in SQL?

A). LIMIT

B). TOP

C). ROWS

D). Both A and B

#28. What is the purpose of the SQL FOREIGN KEY?

A). To identify unique rows in a table

C). To enforce referential integrity

E). Both A and C

B). To link tables

F). Both A and B

D). Both B and C

#29. Which SQL keyword is used to check a condition after grouping?

FILTER

WHERE

HAVING

GROUP BY

#30. What will the DELETE FROM table_name command do without a WHERE clause?

Delete all rows in the table

Delete specific rows

Drop the table

Raise an error

#31. Which SQL statement retrieves rows where a column contains null values?

SELECT * WHERE column CONTAINS NULL;

SELECT * WHERE column NOT NULL;

SELECT * WHERE column IS NULL;

SELECT * WHERE column = NULL;

#32. What does the SQL LIMIT keyword do?

D). Both A and B

F). Both B and C

C). Limits the number of columns retrieved

B). Limits the number of rows returned

A). Restricts the size of a table

E). Both A and C

#33. Which SQL function returns the smallest value in a column?

MIN()

LOWER()

SMALLEST()

LEAST()

#34. What does the SQL ORDER BY column DESC do?

Sorts rows in ascending order

Orders rows randomly

Sorts rows without order

Sorts the result set in descending order

#35. Which SQL command removes a column from a table?

DROP COLUMN

ALTER COLUMN

REMOVE COLUMN

DELETE COLUMN

#36. Which SQL constraint ensures that all values in a column are unique?

FOREIGN KEY

NOT NULL

PRIMARY KEY

UNIQUE

#37. What does the SQL CREATE INDEX statement do?

Deletes an existing table

Creates a shortcut to speed up queries

Creates a new table

Modifies the table structure

#38. What is the purpose of the SQL DEFAULT constraint?

Adds a default table

Defines a primary key

Sets a default value for a column

Ensures a column is never empty

#39. Which statement is used to remove duplicate rows from a query result?

SELECT DISTINCT

FILTER UNIQUE

REMOVE DUPLICATES

SELECT UNIQUE

#40. Which clause in SQL is used to specify conditions on aggregated data?

WHERE

GROUP BY

HAVING

FILTER

Finish

Results

Congratulations !

Opps! Try Again

For More Information Visit : – India gk

Contact for website Design and development – Chaturbhuja Sons

Menus 📃

Indian Insights 📖

Important QA (महत्वपूर्ण प्र. उ. )

Lifestyle and Entertainment (जीवनशैली और मनोरंजन)

CodeQuest 📖

Web Design

JavaScript & Frameworks

Programming Languages

Database & SQL (Coming soon)

SOCIAL SHARING 🖐

Welcome to CodeQuest

HTML, CSS & Bootstrap

JavaScript & Frameworks

Programming Languages

Database & SQL (Coming soon)

SQL Basics

There are Multiple Choice Questions

Correct answers color: Green

Wrong answers color: Red

#1. What does SQL stand for?

#2. Which SQL statement is used to retrieve data from a database?

#3. Which keyword is used to sort the result set in SQL?

#4. Which function is used to return the total number of rows in a table?

#5. What is the correct syntax to create a new table?

#6. Which SQL statement is used to delete data from a table?

#7. How do you select all columns from a table named “users”?

#8. What is the purpose of the WHERE clause in SQL?

#9. Which operator is used to search for a specified pattern in SQL?

#10. Which command is used to modify an existing table in SQL?

#11. Which SQL clause is used to group rows with the same values?

#12. What does the SQL INNER JOIN do?

#13. Which function is used to calculate the total of a numeric column?

#14. What is the result of a LEFT JOIN in SQL?

#15. Which command is used to delete all records from a table but keeps the structure?

#16. How do you find records where a column matches a specific pattern?

#17. What is the default sorting order in SQL?

#18. Which clause is used to filter grouped data?

#19. Which SQL statement adds new rows to a table?

#20. Which operator is used to combine multiple conditions in a WHERE clause?

#21. Which SQL statement is used to return unique values?

#22. Which SQL function returns the average value of a numeric column?

#23. What does the SQL command ALTER TABLE do?

#24. Which operator is used to combine the result of multiple SELECT statements?

#25. How do you specify a condition for rows to be included in a result set?

#26. What will the following query do? SELECT * FROM employees WHERE salary BETWEEN 5000 AND 10000;

#27. Which clause is used to specify the number of rows to return in SQL?

#28. What is the purpose of the SQL FOREIGN KEY?

#29. Which SQL keyword is used to check a condition after grouping?

#30. What will the DELETE FROM table_name command do without a WHERE clause?

#31. Which SQL statement retrieves rows where a column contains null values?

#32. What does the SQL LIMIT keyword do?

#33. Which SQL function returns the smallest value in a column?

#34. What does the SQL ORDER BY column DESC do?

#35. Which SQL command removes a column from a table?

#36. Which SQL constraint ensures that all values in a column are unique?

#37. What does the SQL CREATE INDEX statement do?

#38. What is the purpose of the SQL DEFAULT constraint?

#39. Which statement is used to remove duplicate rows from a query result?

#40. Which clause in SQL is used to specify conditions on aggregated data?

Results

Leave a Reply Cancel reply

Social Sharing