1. What is SQL?
A) Programming language only
B) Structured Query Language
C) Operating System
D) Web Browser
Answer: B
2. SQL is mainly used for:
A) Creating games
B) Managing databases
C) Designing websites only
D) Operating systems
Answer: B
3. SQL stands for:
A) Simple Query Language
B) Structured Query Language
C) Standard Question Language
D) Sequential Query Language
Answer: B
4. Which is a database management system?
A) MySQL
B) HTML
C) CSS
D) JavaScript
Answer: A
5. SQL works with:
A) Databases
B) Images only
C) Videos
D) Operating systems
Answer: A
6. A database is:
A) Collection of organized data
B) A programming language
C) A browser
D) A file only
Answer: A
7. A table contains:
A) Rows and columns
B) Pages only
C) Functions
D) Programs
Answer: A
8. A row in a table is called:
A) Field
B) Record
C) Column
D) Key
Answer: B
9. A column in a table is called:
A) Attribute/Field
B) Record
C) Row
D) Database
Answer: A
10. Which language is used to query databases?
A) HTML
B) SQL
C) CSS
D) XML
Answer: B
SQL Commands
11. Which command retrieves data?
A) SELECT
B) INSERT
C) UPDATE
D) DELETE
Answer: A
12. Which command adds new data?
A) ADD
B) INSERT
C) CREATE
D) UPDATE
Answer: B
13. Which command modifies existing data?
A) CHANGE
B) MODIFY
C) UPDATE
D) ALTER
Answer: C
14. Which command removes records?
A) REMOVE
B) DELETE
C) DROP
D) CLEAR
Answer: B
15. Which command creates a table?
A) MAKE TABLE
B) CREATE TABLE
C) NEW TABLE
D) ADD TABLE
Answer: B
16. Which command deletes a table?
A) REMOVE TABLE
B) DELETE TABLE
C) DROP TABLE
D) CLEAR TABLE
Answer: C
17. Which command changes table structure?
A) ALTER TABLE
B) UPDATE TABLE
C) CHANGE TABLE
D) MODIFY DATA
Answer: A
18. Which command creates a database?
A) CREATE DATABASE
B) NEW DATABASE
C) MAKE DATABASE
D) ADD DATABASE
Answer: A
19. Which command selects a database?
A) USE
B) SELECT
C) OPEN
D) START
Answer: A
20. Which command shows tables?
A) SHOW TABLES
B) DISPLAY TABLES
C) LIST TABLES
D) VIEW TABLES
Answer: A
SELECT Queries
21. Select all columns:
A) SELECT ALL
B) SELECT *
C) SELECT FULL
D) GET *
Answer: B
22. SELECT is used for:
A) Reading data
B) Deleting data
C) Creating users
D) Formatting disks
Answer: A
23. Which clause filters records?
A) WHERE
B) FILTER
C) CHECK
D) IF
Answer: A
24. WHERE is used with:
A) Conditions
B) Tables only
C) Databases only
D) Columns only
Answer: A
25. Which operator means equal?
A) =
B) ==
C) ===
D) :=
Answer: A
26. Not equal operator:
A) <>
B) !=
C) Both A and B
D) !== only
Answer: C
27. Greater than operator:
A) <
B) >
C) =
D) <>
Answer: B
28. Less than operator:
A) <
B) >
C) >=
D) <=
Answer: A
29. Sorting results uses:
A) SORT BY
B) ORDER BY
C) ARRANGE BY
D) GROUP BY
Answer: B
30. Default sorting order:
A) DESC
B) ASC
C) RANDOM
D) NONE
Answer: B
Functions
31. Counts rows:
A) COUNT()
B) SUM()
C) TOTAL()
D) NUMBER()
Answer: A
32. Calculates total:
A) COUNT()
B) SUM()
C) AVG()
D) TOTAL()
Answer: B
33. Calculates average:
A) AVG()
B) MEAN()
C) AVERAGE()
D) MID()
Answer: A
34. Finds maximum value:
A) MAX()
B) HIGH()
C) TOP()
D) BIG()
Answer: A
35. Finds minimum value:
A) LOW()
B) MIN()
C) SMALL()
D) BOTTOM()
Answer: B
Database Design
36. Primary key is:
A) Unique identifier
B) Duplicate value
C) Empty field
D) Random value
Answer: A
37. Primary key can contain:
A) Duplicate values
B) NULL values
C) Unique values only
D) Text only
Answer: C
38. Foreign key is used to:
A) Link tables
B) Delete tables
C) Create databases
D) Sort data
Answer: A
39. NULL means:
A) Zero
B) Empty/unknown value
C) False
D) Error
Answer: B
40. UNIQUE constraint prevents:
A) Duplicate values
B) All values
C) NULL values only
D) Tables
Answer: A
Data Types
41. Stores whole numbers:
A) INT
B) VARCHAR
C) DATE
D) BOOLEAN
Answer: A
42. Stores text:
A) VARCHAR
B) INT
C) FLOAT
D) DATE
Answer: A
43. Stores dates:
A) DATE
B) TIME
C) VARCHAR
D) INT
Answer: A
44. Stores decimal numbers:
A) FLOAT
B) CHAR
C) TEXT
D) DATE
Answer: A
45. CHAR stores:
A) Fixed length text
B) Numbers only
C) Dates only
D) Images
Answer: A
INSERT / UPDATE / DELETE
46. Insert syntax starts with:
A) ADD
B) INSERT INTO
C) CREATE
D) PUT
Answer: B
47. Update syntax starts with:
A) UPDATE
B) CHANGE
C) MODIFY
D) EDIT
Answer: A
48. Delete syntax starts with:
A) REMOVE
B) DELETE FROM
C) DROP
D) CLEAR
Answer: B
49. Without WHERE, UPDATE affects:
A) All rows
B) One row only
C) No rows
D) Error always
Answer: A
50. Without WHERE, DELETE removes:
A) All rows
B) One row
C) Database
D) Table
Answer: A
Joins
51. JOIN is used to:
A) Combine tables
B) Delete tables
C) Create databases
D) Rename columns
Answer: A
52. INNER JOIN returns:
A) Matching rows
B) All rows
C) Empty rows
D) Duplicate tables
Answer: A
53. LEFT JOIN returns:
A) Left table + matches
B) Right table only
C) Matches only
D) No data
Answer: A
54. RIGHT JOIN returns:
A) Right table + matches
B) Left table only
C) All databases
D) Errors
Answer: A
55. CROSS JOIN creates:
A) Cartesian product
B) Primary key
C) Index
D) View
Answer: A
Grouping
56. GROUP BY is used to:
A) Group records
B) Delete records
C) Create tables
D) Rename tables
Answer: A
57. HAVING filters:
A) Groups
B) Tables
C) Databases
D) Columns only
Answer: A
58. WHERE filters before:
A) GROUP BY
B) SELECT
C) FROM
D) JOIN
Answer: A
59. HAVING is used with:
A) Aggregate functions
B) Variables
C) HTML
D) CSS
Answer: A
60. GROUP BY commonly works with:
A) COUNT(), SUM()
B) INSERT
C) DELETE
D) DROP
Answer: A
Advanced Basics
61. Index improves:
A) Query speed
B) Data deletion
C) Table size
D) Passwords
Answer: A
62. View is:
A) Virtual table
B) Physical disk
C) Database server
D) Program
Answer: A
63. CREATE VIEW creates:
A) View
B) Table
C) Database
D) Index
Answer: A
64. Stored procedure is:
A) Saved SQL code
B) Table
C) Column
D) Key
Answer: A
65. Transaction ensures:
A) Reliable operations
B) Faster internet
C) More tables
D) More columns
Answer: A
66. Transaction command:
A) COMMIT
B) SAVEFILE
C) STORE
D) ACCEPT
Answer: A
67. Undo transaction:
A) ROLLBACK
B) CANCEL
C) UNDO SQL
D) RESET
Answer: A
68. ACID relates to:
A) Transactions
B) HTML
C) CSS
D) Networks
Answer: A
69. Atomicity means:
A) All or nothing
B) Fast execution
C) Duplicate data
D) Sorting
Answer: A
70. Consistency means:
A) Valid data state
B) More records
C) Bigger database
D) More tables
Answer: A
SQL General
71. MySQL is:
A) DBMS
B) Programming language
C) Browser
D) OS
Answer: A
72. Oracle Database uses:
A) SQL
B) HTML
C) CSS
D) PHP only
Answer: A
73. SQL keywords are usually:
A) Case insensitive
B) Case sensitive
C) Numbers only
D) Symbols only
Answer: A
74. Database administrator is:
A) DBA
B) DBO
C) DBM
D) SQLA
Answer: A
75. DBA manages:
A) Databases
B) Websites only
C) Images
D) Computers only
Answer: A
76. Normalization reduces:
A) Data redundancy
B) Security
C) Speed always
D) Tables
Answer: A
77. First normal form requires:
A) Atomic values
B) Duplicate data
C) Empty tables
D) No keys
Answer: A
78. SQL injection attacks:
A) Database queries
B) CSS
C) Images
D) Hardware
Answer: A
79. Prepared statements prevent:
A) SQL injection
B) Tables
C) Queries
D) Databases
Answer: A
80. Backup stores:
A) Database copy
B) Password only
C) HTML
D) Browser cache
Answer: A
More Practice
81. Rename column uses:
A) AS
B) RENAME
C) CHANGE ONLY
D) LABEL
Answer: A
82. Alias is created using:
A) AS
B) ALIAS
C) NAME
D) SET
Answer: A
83. DISTINCT removes:
A) Duplicate results
B) Tables
C) Columns
D) Databases
Answer: A
84. DISTINCT keyword is used with:
A) SELECT
B) DELETE
C) UPDATE
D) DROP
Answer: A
85. LIKE is used for:
A) Pattern matching
B) Sorting
C) Joining
D) Deleting
Answer: A
86. Wildcard for many characters:
A) %
B) _
C) *
D) #
Answer: A
87. Wildcard for one character:
A) %
B) _
C) *
D) ?
Answer: B
88. BETWEEN checks:
A) Range
B) Text only
C) Tables
D) Keys
Answer: A
89. IN checks:
A) List of values
B) Database size
C) Column type
D) Index
Answer: A
90. LIMIT controls:
A) Number of returned rows
B) Columns
C) Databases
D) Keys
Answer: A
91. SQL is used by:
A) Websites
B) Applications
C) Both
D) Neither
Answer: C
92. Database server example:
A) MySQL
B) Chrome
C) Windows
D) Photoshop
Answer: A
93. Table name is specified after:
A) FROM
B) WHERE
C) SELECT
D) INTO
Answer: A
94. INSERT adds:
A) New records
B) New databases only
C) Columns only
D) Keys only
Answer: A
95. ALTER can:
A) Modify tables
B) Query data only
C) Delete database only
D) Backup only
Answer: A
96. DROP removes:
A) Database objects
B) Rows only
C) Values only
D) Users only
Answer: A
97. SQL is a:
A) Declarative language
B) Markup language
C) Styling language
D) Hardware language
Answer: A
98. Database relationships use:
A) Keys
B) Images
C) CSS
D) HTML
Answer: A
99. SQL databases are usually:
A) Relational databases
B) Image databases only
C) Text editors
D) Operating systems
Answer: A
100. SQL is mainly used to:
A) Store and manipulate data
B) Create animations
C) Design pages only
D) Build hardware
Answer: A