1. What does SQL stand for?<\/h3>\n
A) Structured Question Language A) GET A) ORDER BY A) ADD A) GROUP BY A) MODIFY A) REMOVE A) ORDER BY A) WHERE A) SUM() A) MAX() A) MIN() A) AVG() A) ADD() A) MATCH A) _ A) _ A) IN A) BETWEEN A) UNIQUE A) LIMIT A) ALL A) CREATE TABLE A) DELETE TABLE A) MODIFY TABLE A) INNER JOIN A) INNER JOIN A) RIGHT JOIN A) LEFT JOIN A) AS A) JOIN A) JOIN A) UNION A) = NULL A) NOT NULL A) A query inside another query A) IN A) ALL A) ANY A) PRIMARY A) Duplicate A) PRIMARY KEY A) UNIQUE A) CHECK A) PRIMARY KEY A) CREATE VIEW A) A physical table A) DELETE VIEW A) SAVE A) ROLLBACK A) SAVE A) WHEN A) STOP A) ADD INDEX A) Delete records A) DELETE INDEX A) UPPER() A) LOWER() A) SIZE() A) CUT() A) + A) NOW() A) CURRENT_TIMESTAMP A) SELECT A) DOWN A) ASC A) LIMIT A) && A) || A) NO A) ADD COLUMN A) DELETE COLUMN A) UNIQUE A) UNIQUE A) HAVING A) WHERE A) DELETE A) DELETE A) WHERE A) RENAME A) ISNULL() A) LIMIT A) INNER JOIN A) DISTINCT A) CREATE FUNCTION A) RUN A) View A) CREATE TRIGGER A) MODIFY A) IF A) DROP A) START TRANSACTION A) EXISTS A) SELECT A) WHERE A) ALTER A) GROUP BY A) DELETE CONSTRAINT A) ROUND() A) SELECT ALL FROM table_name;
B) Simple Query Language
C) Structured Query Language
D) System Query Language
Answer: C<\/strong><\/p>\n
\n2. Which SQL statement is used to retrieve data from a database?<\/h3>\n
B) SELECT
C) FETCH
D) RETRIEVE
Answer: B<\/strong><\/p>\n
\n3. Which clause is used to filter records?<\/h3>\n
B) GROUP BY
C) WHERE
D) HAVING
Answer: C<\/strong><\/p>\n
\n4. Which statement is used to insert new data?<\/h3>\n
B) INSERT INTO
C) UPDATE
D) CREATE
Answer: B<\/strong><\/p>\n
\n5. Which SQL clause is used to sort the result set?<\/h3>\n
B) ORDER BY
C) SORT BY
D) ARRANGE BY
Answer: B<\/strong><\/p>\n
\n6. Which command is used to update existing records?<\/h3>\n
B) CHANGE
C) UPDATE
D) EDIT
Answer: C<\/strong><\/p>\n
\n7. Which command is used to delete records?<\/h3>\n
B) DELETE
C) DROP
D) ERASE
Answer: B<\/strong><\/p>\n
\n8. Which clause groups rows sharing a property?<\/h3>\n
B) WHERE
C) GROUP BY
D) SORT
Answer: C<\/strong><\/p>\n
\n9. Which clause is used with aggregate functions to filter groups?<\/h3>\n
B) HAVING
C) GROUP BY
D) ORDER BY
Answer: B<\/strong><\/p>\n
\n10. Which function returns the number of rows?<\/h3>\n
B) COUNT()
C) TOTAL()
D) NUMBER()
Answer: B<\/strong><\/p>\n
\n11. Which function returns the maximum value?<\/h3>\n
B) HIGH()
C) TOP()
D) LARGE()
Answer: A<\/strong><\/p>\n
\n12. Which function returns the minimum value?<\/h3>\n
B) LOW()
C) SMALL()
D) BOTTOM()
Answer: A<\/strong><\/p>\n
\n13. Which function calculates the average?<\/h3>\n
B) AVERAGE()
C) MEAN()
D) CALC()
Answer: A<\/strong><\/p>\n
\n14. Which function calculates the total sum?<\/h3>\n
B) TOTAL()
C) SUM()
D) PLUS()
Answer: C<\/strong><\/p>\n
\n15. Which operator is used for pattern matching?<\/h3>\n
B) LIKE
C) IN
D) BETWEEN
Answer: B<\/strong><\/p>\n
\n16. Which wildcard represents multiple characters?<\/h3>\n
B) *
C) %
D) ?
Answer: C<\/strong><\/p>\n
\n17. Which wildcard represents a single character?<\/h3>\n
B) %
C) *
D) #
Answer: A<\/strong><\/p>\n
\n18. Which operator checks for a range of values?<\/h3>\n
B) RANGE
C) BETWEEN
D) LIMIT
Answer: C<\/strong><\/p>\n
\n19. Which operator checks for multiple possible values?<\/h3>\n
B) IN
C) LIKE
D) EXISTS
Answer: B<\/strong><\/p>\n
\n20. Which SQL keyword is used to remove duplicate values?<\/h3>\n
B) DISTINCT
C) DIFFERENT
D) REMOVE
Answer: B<\/strong><\/p>\n
\n21. Which clause limits the number of returned rows (MySQL)?<\/h3>\n
B) TOP
C) FETCH
D) ROWNUM
Answer: A<\/strong><\/p>\n
\n22. Which keyword selects all columns?<\/h3>\n
B) *
C) FULL
D) COLUMN
Answer: B<\/strong><\/p>\n
\n23. Which statement creates a new table?<\/h3>\n
B) NEW TABLE
C) ADD TABLE
D) MAKE TABLE
Answer: A<\/strong><\/p>\n
\n24. Which statement deletes a table permanently?<\/h3>\n
B) REMOVE TABLE
C) DROP TABLE
D) ERASE TABLE
Answer: C<\/strong><\/p>\n
\n25. Which statement modifies an existing table?<\/h3>\n
B) ALTER TABLE
C) UPDATE TABLE
D) CHANGE TABLE
Answer: B<\/strong><\/p>\n
\n26. Which JOIN returns all records from both tables?<\/h3>\n
B) LEFT JOIN
C) RIGHT JOIN
D) FULL JOIN
Answer: D<\/strong><\/p>\n
\n27. Which JOIN returns matching records only?<\/h3>\n
B) FULL JOIN
C) LEFT JOIN
D) RIGHT JOIN
Answer: A<\/strong><\/p>\n
\n28. Which JOIN returns all records from left table and matched from right?<\/h3>\n
B) LEFT JOIN
C) INNER JOIN
D) FULL JOIN
Answer: B<\/strong><\/p>\n
\n29. Which JOIN returns all records from the right table and matches from left?<\/h3>\n
B) INNER JOIN
C) RIGHT JOIN
D) FULL JOIN
Answer: C<\/strong><\/p>\n
\n30. Which clause is used to rename a column?<\/h3>\n
B) RENAME
C) ALIAS
D) NAME
Answer: A<\/strong><\/p>\n31. Which statement is used to combine the result sets of two SELECT statements?<\/h3>\n
B) UNION
C) MERGE
D) COMBINE
Answer: B<\/strong><\/p>\n
\n32. Which operator removes duplicate records in combined results?<\/h3>\n
B) DISTINCT
C) UNION
D) UNION ALL
Answer: C<\/strong><\/p>\n
\n33. Which operator keeps duplicate records when combining results?<\/h3>\n
B) DISTINCT
C) UNION ALL
D) MERGE ALL
Answer: C<\/strong><\/p>\n
\n34. Which clause is used to check for NULL values?<\/h3>\n
B) IS NULL
C) NULL =
D) EQUAL NULL
Answer: B<\/strong><\/p>\n
\n35. Which clause is used to check for NOT NULL values?<\/h3>\n
B) IS NOT NULL
C) != NULL
D) NULL <>
Answer: B<\/strong><\/p>\n
\n36. What is a subquery?<\/h3>\n
B) A backup query
C) A delete query
D) A grouped query
Answer: A<\/strong><\/p>\n
\n37. Which keyword is used to test for the existence of records in a subquery?<\/h3>\n
B) EXISTS
C) CHECK
D) FOUND
Answer: B<\/strong><\/p>\n
\n38. Which operator is used to compare a value to any value in a subquery?<\/h3>\n
B) ANY
C) EXISTS
D) IN
Answer: B<\/strong><\/p>\n
\n39. Which operator compares a value to all values in a subquery?<\/h3>\n
B) ALL
C) IN
D) EXISTS
Answer: B<\/strong><\/p>\n
\n40. Which clause defines a primary key?<\/h3>\n
B) PRIMARY KEY
C) MAIN KEY
D) UNIQUE KEY
Answer: B<\/strong><\/p>\n
\n41. A primary key must be:<\/h3>\n
B) NULL
C) Unique and NOT NULL
D) Optional
Answer: C<\/strong><\/p>\n
\n42. Which constraint ensures unique values in a column?<\/h3>\n
B) UNIQUE
C) NOT NULL
D) CHECK
Answer: B<\/strong><\/p>\n
\n43. Which constraint prevents NULL values?<\/h3>\n
B) CHECK
C) NOT NULL
D) DEFAULT
Answer: C<\/strong><\/p>\n
\n44. Which constraint provides a default value?<\/h3>\n
B) DEFAULT
C) UNIQUE
D) AUTO
Answer: B<\/strong><\/p>\n
\n45. Which constraint ensures referential integrity?<\/h3>\n
B) UNIQUE
C) FOREIGN KEY
D) CHECK
Answer: C<\/strong><\/p>\n
\n46. Which statement is used to create a view?<\/h3>\n
B) MAKE VIEW
C) NEW VIEW
D) ADD VIEW
Answer: A<\/strong><\/p>\n
\n47. A view is:<\/h3>\n
B) A virtual table
C) A stored procedure
D) An index
Answer: B<\/strong><\/p>\n
\n48. Which statement removes a view?<\/h3>\n
B) DROP VIEW
C) REMOVE VIEW
D) ERASE VIEW
Answer: B<\/strong><\/p>\n
\n49. Which command saves changes permanently?<\/h3>\n
B) COMMIT
C) STORE
D) APPLY
Answer: B<\/strong><\/p>\n
\n50. Which command undoes changes?<\/h3>\n
B) CANCEL
C) UNDO
D) REMOVE
Answer: A<\/strong><\/p>\n
\n![\"Internet](\"https:\/\/murreeroad.org\/wp-content\/uploads\/2026\/01\/Internet-and-Web-Basics-MCQs-1024x577.png\")
<\/a><\/p>\n
\n51. Which command sets a savepoint in a transaction?<\/h3>\n
B) SAVEPOINT
C) CHECKPOINT
D) MARK
Answer: B<\/strong><\/p>\n
\n52. Which clause is used in CASE statements?<\/h3>\n
B) IF
C) SWITCH
D) SELECT
Answer: A<\/strong><\/p>\n
\n53. Which keyword ends a CASE statement?<\/h3>\n
B) END
C) FINISH
D) CLOSE
Answer: B<\/strong><\/p>\n
\n54. Which command creates an index?<\/h3>\n
B) CREATE INDEX
C) MAKE INDEX
D) NEW INDEX
Answer: B<\/strong><\/p>\n
\n55. What is the purpose of an index?<\/h3>\n
B) Speed up queries
C) Sort data permanently
D) Group records
Answer: B<\/strong><\/p>\n
\n56. Which statement removes an index?<\/h3>\n
B) DROP INDEX
C) REMOVE INDEX
D) ERASE INDEX
Answer: B<\/strong><\/p>\n
\n57. Which function converts text to uppercase?<\/h3>\n
B) CAPITAL()
C) LARGE()
D) BIG()
Answer: A<\/strong><\/p>\n
\n58. Which function converts text to lowercase?<\/h3>\n
B) SMALL()
C) MIN()
D) DOWN()
Answer: A<\/strong><\/p>\n
\n59. Which function returns the length of a string?<\/h3>\n
B) COUNT()
C) LENGTH()
D) CHARCOUNT()
Answer: C<\/strong><\/p>\n
\n60. Which function extracts part of a string?<\/h3>\n
B) SUBSTRING()
C) EXTRACT()
D) PART()
Answer: B<\/strong><\/p>\n
\n61. Which operator concatenates strings?<\/h3>\n
B) &
C) ||
D) CONCAT
Answer: C<\/strong><\/p>\n
\n62. Which function returns current date?<\/h3>\n
B) TODAY()
C) CURRENT_DATE
D) DATE()
Answer: C<\/strong><\/p>\n
\n63. Which function returns current date and time?<\/h3>\n
B) TODAY()
C) DATE()
D) TIME()
Answer: A<\/strong><\/p>\n
\n64. Which clause is evaluated first?<\/h3>\n
B) WHERE
C) FROM
D) ORDER BY
Answer: C<\/strong><\/p>\n
\n65. Which keyword is used to sort in descending order?<\/h3>\n
B) DESC
C) DECREASE
D) LOWER
Answer: B<\/strong><\/p>\n
\n66. Which keyword sorts in ascending order?<\/h3>\n
B) UP
C) INCREASE
D) RISE
Answer: A<\/strong><\/p>\n
\n67. Which clause limits rows in SQL Server?<\/h3>\n
B) TOP
C) FETCH
D) ROWNUM
Answer: B<\/strong><\/p>\n
\n68. Which operator is used for logical AND?<\/h3>\n
B) AND
C) &
D) BOTH
Answer: B<\/strong><\/p>\n
\n69. Which operator is used for logical OR?<\/h3>\n
B) OR
C) EITHER
D) AND
Answer: B<\/strong><\/p>\n
\n70. Which operator negates a condition?<\/h3>\n
B) NOT
C) NONE
D) STOP
Answer: B<\/strong><\/p>\n
\n71. Which command adds a new column?<\/h3>\n
B) INSERT COLUMN
C) ALTER TABLE ADD
D) CREATE COLUMN
Answer: C<\/strong><\/p>\n
\n72. Which command removes a column?<\/h3>\n
B) DROP COLUMN
C) REMOVE COLUMN
D) ERASE COLUMN
Answer: B<\/strong><\/p>\n
\n73. Which constraint checks the condition before inserting data?<\/h3>\n
B) CHECK
C) DEFAULT
D) PRIMARY
Answer: B<\/strong><\/p>\n
\n74. Which keyword retrieves unique records?<\/h3>\n
B) DISTINCT
C) SINGLE
D) ONE
Answer: B<\/strong><\/p>\n
\n75. Which clause filters before grouping?<\/h3>\n
B) WHERE
C) ORDER BY
D) GROUP BY
Answer: B<\/strong><\/p>\n
\n76. Which clause filters after grouping?<\/h3>\n
B) GROUP BY
C) HAVING
D) SELECT
Answer: C<\/strong><\/p>\n
\n77. Which command removes all records but keeps the table structure?<\/h3>\n
B) DROP
C) TRUNCATE
D) REMOVE
Answer: C<\/strong><\/p>\n
\n78. Which command removes table structure and data?<\/h3>\n
B) DROP
C) TRUNCATE
D) CLEAR
Answer: B<\/strong><\/p>\n
\n79. Which clause is mandatory in the SELECT statement?<\/h3>\n
B) ORDER BY
C) SELECT
D) GROUP BY
Answer: C<\/strong><\/p>\n
\n80. Which keyword renames a table?<\/h3>\n
B) ALTER TABLE RENAME
C) MODIFY
D) CHANGE
Answer: B<\/strong><\/p>\n
\n81. Which function replaces NULL with a value (MySQL)?<\/h3>\n
B) IFNULL()
C) NULLVALUE()
D) CHECKNULL()
Answer: B<\/strong><\/p>\n
\n82. Which clause selects the top rows in Oracle?<\/h3>\n
B) ROWNUM
C) TOP
D) FETCH
Answer: B<\/strong><\/p>\n
\n83. Which join creates the Cartesian product?<\/h3>\n
B) CROSS JOIN
C) LEFT JOIN
D) RIGHT JOIN
Answer: B<\/strong><\/p>\n
\n84. Which keyword removes duplicate rows in GROUP BY results?<\/h3>\n
B) UNIQUE
C) HAVING
D) ORDER
Answer: A<\/strong><\/p>\n
\n85. Which statement defines a stored procedure?<\/h3>\n
B) CREATE PROCEDURE
C) MAKE PROCEDURE
D) NEW PROCEDURE
Answer: B<\/strong><\/p>\n
\n86. Which statement executes a stored procedure?<\/h3>\n
B) EXEC
C) CALL
D) START
Answer: B<\/strong><\/p>\n
\n87. Which object automatically executes on table events?<\/h3>\n
B) Trigger
C) Index
D) Function
Answer: B<\/strong><\/p>\n
\n88. Which statement creates a trigger?<\/h3>\n
B) MAKE TRIGGER
C) ADD TRIGGER
D) NEW TRIGGER
Answer: A<\/strong><\/p>\n
\n89. Which command changes column data type?<\/h3>\n
B) ALTER TABLE MODIFY
C) UPDATE TYPE
D) CHANGE TYPE
Answer: B<\/strong><\/p>\n
\n90. Which keyword is used for conditional logic in SQL?<\/h3>\n
B) CASE
C) SWITCH
D) LOOP
Answer: B<\/strong><\/p>\n
\n91. Which statement deletes specific rows?<\/h3>\n
B) DELETE
C) TRUNCATE
D) CLEAR
Answer: B<\/strong><\/p>\n
\n92. Which command begins a transaction?<\/h3>\n
B) BEGIN
C) OPEN
D) INIT
Answer: A<\/strong><\/p>\n
\n93. Which keyword checks whether a value exists in a list?<\/h3>\n
B) IN
C) BETWEEN
D) ANY
Answer: B<\/strong><\/p>\n
\n94. Which SQL clause retrieves data from tables?<\/h3>\n
B) FROM
C) WHERE
D) GROUP BY
Answer: B<\/strong><\/p>\n
\n95. Which clause must come after SELECT?<\/h3>\n
B) GROUP BY
C) FROM
D) ORDER BY
Answer: C<\/strong><\/p>\n
\n96. Which statement changes existing data?<\/h3>\n
B) UPDATE
C) MODIFY
D) CHANGE
Answer: B<\/strong><\/p>\n
\n97. Which clause sorts multiple columns?<\/h3>\n
B) ORDER BY
C) SORT BY
D) ARRANGE
Answer: B<\/strong><\/p>\n
\n98. Which keyword removes specific constraints?<\/h3>\n
B) DROP CONSTRAINT
C) REMOVE CONSTRAINT
D) ERASE CONSTRAINT
Answer: B<\/strong><\/p>\n
\n99. Which function rounds numeric values?<\/h3>\n
B) FORMAT()
C) FIX()
D) CEIL()
Answer: A<\/strong><\/p>\n
\n100. Which SQL statement retrieves all data from a table?<\/h3>\n
B) SELECT * FROM table_name;
C) GET * FROM table_name;
D) FETCH ALL table_name;
Answer: B<\/strong><\/p>\n
\nAdvertisement:<\/pre>\n
![\"school-management-software\"](\"https:\/\/murreeroad.org\/wp-content\/uploads\/2025\/12\/school-management-software-300x300.png\")
<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"