NEW
Font size
S
M
L
XL
WorksheetsSQL QUIZ
Total questions: 25
Worksheet time: 4mins
Name
Class
Date
1.
Which SQL command is used to create a table?
a)
SELECT
b)
CREATE TABLE
c)
UPDATE TABLE
d)
MAKE TABLE
2.
Which of these is an example of data?
a)
Monthly profit percentage
b)
Customer names in a spreadsheet
c)
A chart of sales growth
d)
A business decision
3.
Which SQL command adds a new record?
a)
ADD
b)
INSERT INTO
c)
MAKE RECORD
d)
NEW ENTRY
4.
A main problem with file system data processing is:
a)
Limited formats
b)
Data redundancy and inconsistency
c)
Too much automation
d)
Large file sizes
5.
Which SQL clause is used to sort results?
a)
SORT
b)
ORDER BY
c)
GROUP BY
d)
ARRANGE
6.
In an ER diagram, a rectangle represents:
a)
Entity
b)
Attribute
c)
Relationship
d)
Primary Key
7.
Which SQL clause is used to filter groups after grouping?
a)
WHERE
b)
HAVING
c)
ORDER BY
d)
LIMIT
8.
Which of these is not a function of a DBMS?
a)
Store data
b)
Secure data
c)
Retrieve data
d)
Design websites
9.
Which aggregate function finds the largest value?
a)
MAX
b)
SUM
c)
COUNT
d)
AVG
10.
Which level of data abstraction deals with how data is stored physically?
a)
Physical level
b)
View level
c)
Logical level
d)
Conceptual level
11.
Which SQL function combines two strings?
a)
CONCAT()
b)
MERGE()
c)
ADD()
d)
UNION()
12.
Which data model is used for conceptual design?
a)
ER Model
b)
Network Model
c)
Relational Model
d)
Object-Oriented Model
13.
What does NULL mean in SQL?
a)
Zero
b)
No value assigned
c)
Negative value
d)
Error in data
14.
In an ER diagram, a diamond shape represents:
a)
Relationship
b)
Entity
c)
Attribute
d)
Foreign key
15.
Which SQL statement removes all rows but keeps the table structure?
a)
DELETE
b)
DROP
c)
TRUNCATE
d)
REMOVE
16.
Specialization in DB design means:
a)
Breaking a general entity into sub-entities
b)
Combining entities into one
c)
Adding attributes
d)
Creating indexes
17.
Which SQL clause is used to filter rows before grouping?
a)
WHERE
b)
HAVING
c)
ORDER BY
d)
LIMIT
18.
Generalization in ER modeling is used when:
a)
Two or more entities share common features and are combined
b)
A single entity has many attributes
c)
We split data into smaller parts
d)
We add new tables
19.
Which SQL function returns the current date?
a)
CURRENT_DATE
b)
GETDATE()
c)
TODAY()
d)
NOWDATE()
20.
Aggregation in ER modeling means:
a)
Treating a relationship as an entity
b)
Duplicate data storage
c)
Sorting attributes alphabetically
d)
Converting attributes to tables
21.
Which SQL keyword is used to group rows with the same values?
a)
GROUP BY
b)
ORDER BY
c)
CLUSTER BY
d)
SORT
22.
Which system was common before databases?
a)
File system
b)
Cloud storage
c)
Blockchain
d)
NoSQL
23.
Which numeric function returns the integer part of a number?
a)
FLOOR()
b)
ROUND()
c)
ABS()
d)
CEIL()
24.
Which is an advantage of DBMS over file systems?
a)
More data duplication
b)
Better concurrency control
c)
Slower performance
d)
No backup needed
25.
Which SQL clause is used to filter data from a table?
a)
WHERE
b)
ORDER BY
c)
GROUP BY
d)
HAVING
Reset
