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
A NoSQL database
2
An open-source relational database management system
3
A key-value store
4
A programming language
Question 3
Which of the following is the default storage engine in MySQL 8.0?
1
CSV
2
MyISAM
3
MEMORY
4
InnoDB
Question 4
Which MySQL storage engine is best suited for high-speed, read-heavy workloads but does not support transactions?
1
InnoDB
2
CSV
3
MEMORY
4
MyISAM
Question 5
Which MySQL storage engine is designed for in-memory operations and does not persist data to disk?
1
InnoDB
2
MyISAM
3
CSV
4
MEMORY
Question 6
Which MySQL storage engine is best for logging and large-scale data archiving with high compression?
1
BLACKHOLE
2
ARCHIVE
3
CSV
4
MyISAM
Question 7
Which MySQL storage engine does NOT store any data and acts as a data sink?
1
ARCHIVE
2
CSV
3
BLACKHOLE
4
InnoDB
Question 8
Which MySQL storage engine stores table data in a plain text file and is useful for data exchange?
1
CSV
2
InnoDB
3
ARCHIVE
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 store data persistently
4
To increase storage space
Question 11
Which of the following helps optimize MySQL queries?
1
Using multiple OR conditions
2
Using SELECT *
3
Adding appropriate indexes
4
Storing duplicate data
Question 12
Which SQL command is used to start a transaction in MySQL?
1
EXECUTE TRANSACTION
2
OPEN TRANSACTION
3
BEGIN QUERY
4
START TRANSACTION
Question 13
Which of the following ACID properties ensures that a transaction is executed completely or not at all?
1
Isolation
2
Atomicity
3
Durability
4
Consistency
Question 14
Which command is used to create a new MySQL user?
1
ADD USER
2
CREATE USER
3
CREATE NEW USER
4
NEW USER
Question 15
Which MySQL privilege allows a user to modify the database structure?
1
INSERT
2
SELECT
3
ALTER
4
UPDATE
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
Running queries without WHERE
2
Disabling indexes
3
Using composite indexes
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
ALTER
2
DROP
3
TRUNCATE
4
DELETE