Question 1
Which index type does MySQL use by default for primary keys?
1
Full-Text Index
2
Hash Index
3
B-Tree Index
4
Bitmap Index
Question 2
Which of the following best describes MySQL?
1
An open-source relational database management system
2
A NoSQL database
3
A programming language
4
A key-value store
Question 3
Which of the following is the default storage engine in MySQL 8.0?
1
MEMORY
2
InnoDB
3
MyISAM
4
CSV
Question 4
Which MySQL storage engine is best suited for high-speed, read-heavy workloads but does not support transactions?
1
MyISAM
2
InnoDB
3
MEMORY
4
CSV
Question 5
Which MySQL storage engine is designed for in-memory operations and does not persist data to disk?
1
MEMORY
2
InnoDB
3
CSV
4
MyISAM
Question 6
Which MySQL storage engine is best for logging and large-scale data archiving with high compression?
1
ARCHIVE
2
MyISAM
3
CSV
4
BLACKHOLE
Question 7
Which MySQL storage engine does NOT store any data and acts as a data sink?
1
CSV
2
InnoDB
3
BLACKHOLE
4
ARCHIVE
Question 8
Which MySQL storage engine stores table data in a plain text file and is useful for data exchange?
1
ARCHIVE
2
InnoDB
3
CSV
4
MyISAM
Question 9
Which data type is best suited for storing large text data in MySQL?
1
VARCHAR
2
INT
3
TEXT
4
ENUM
Question 10
What is the purpose of an index in MySQL?
1
To speed up query execution
2
To prevent data duplication
3
To increase storage space
4
To store data persistently
Question 11
Which of the following helps optimize MySQL queries?
1
Storing duplicate data
2
Adding appropriate indexes
3
Using multiple OR conditions
4
Using SELECT *
Question 12
Which SQL command is used to start a transaction in MySQL?
1
EXECUTE TRANSACTION
2
START TRANSACTION
3
OPEN TRANSACTION
4
BEGIN QUERY
Question 13
Which of the following ACID properties ensures that a transaction is executed completely or not at all?
1
Durability
2
Atomicity
3
Consistency
4
Isolation
Question 14
Which command is used to create a new MySQL user?
1
CREATE USER
2
NEW USER
3
CREATE NEW USER
4
ADD USER
Question 15
Which MySQL privilege allows a user to modify the database structure?
1
SELECT
2
UPDATE
3
ALTER
4
INSERT
Question 16
Which command is used to create a MySQL database backup?
1
mysqlbackup
2
backupdb
3
mysqldump
4
create_backup
Question 17
Which of the following improves MySQL query performance?
1
Using composite indexes
2
Disabling indexes
3
Running queries without WHERE
4
Avoiding normalization
Question 18
Which of the following SQL commands is used to remove all records from a table but keep its structure?
1
DROP
2
DELETE
3
ALTER
4
TRUNCATE