iwantcoding
.com
Tutorials
▾
Web Frontend
HTML
CSS
HTML5
CSS3
JavaScript
TypeScript
Sass
React
Vue
Svelte
Tailwind
Backend
Python
PHP
Node.js
Java
Go
Rust
Ruby
C#
Databases
SQL
MySQL
PostgreSQL
MongoDB
Firebase
GraphQL
Redis
Mobile
React Native
Flutter
Swift
Kotlin
Ionic
Cloud & DevOps
AWS
Docker
Kubernetes
CI/CD
Linux/Bash
AI & Data
NumPy/Pandas
Machine Learning
TensorFlow
PyTorch
LangChain
RAG
Cybersecurity
XSS
SQL Injection
CSRF
OWASP Top 10
Cryptography
Ethical Hacking
Tools
Git
DSA
Design Patterns
RegEx
VS Code
Specialty
Game Dev
WordPress
Web3/Solidity
Three.js
Capstone
Enterprise Architecture
HTML
CSS
JAVASCRIPT
SQL
PYTHON
PHP
TYPESCRIPT
REACT
NODEJS
MONGODB
DOCKER
GIT
TAILWIND
GRAPHQL
LINUX-BASH
AWS
KUBERNETES
VUE
SVELTE
SASS
THREEJS
GO
RUST
JAVA
RUBY
CSHARP
WORDPRESS
POSTGRESQL
MYSQL
REDIS
FIREBASE
REACT-NATIVE
FLUTTER
SWIFT
KOTLIN
IONIC
CICD
NUMPY-PANDAS
ML
TENSORFLOW
PYTORCH
LANGCHAIN
XSS
SQLI
CSRF
OWASP
CRYPTO
DSA
DESIGN-PATTERNS
REGEX
VSCODE
GAMEDEV
WEB3
ENTERPRISE
CAPSTONE
ETHICAL-HACKING
🔥 Daily
👥 Rooms
🏆 Top
Log in
Sign up
AI ✨
MySQL Tutorial
BOSS QUIZ
10 questions · 5 minutes · pass at 70% to clear the track.
05:00
Start
Q1.
Default storage engine since 5.5 is…
from Intro
MyISAM
InnoDB
MEMORY
CSV
Q2.
Crash recovery uses…
from InnoDB Internals
mysqldump
The redo log (ib_logfile)
Triggers
Binlog only
Q3.
Auto-commit per statement is…
from Transactions / Isolation
Off
On by default
Per session only
Per DB only
Q4.
Physical backup tool is…
from mysqldump / Restore
xtrabackup / mariabackup
mysqldump
gtar
mongoexport
Q5.
See indexes on a table with…
from Indexes
SHOW INDEX FROM t
LIST INDEXES t
DESC INDEXES
SELECT INDEXES(t)
Q6.
The community fork is…
from Intro
PostgreSQL
MariaDB
CockroachDB
TiDB
Q7.
PRIMARY KEY also creates…
from Indexes
No index
A clustered unique index
A FULLTEXT index
A spatial index
Q8.
For point-in-time recovery, enable…
from mysqldump / Restore
general log
binary log
slow log
error log
Q9.
InnoDB supports…
from InnoDB Internals
Foreign keys, MVCC, row locking
Table-level locking only
Schema-less docs
Distributed SQL
Q10.
MySQL is currently owned by…
from Intro
Microsoft
Oracle
Apple
IBM
Submit
Back to MySQL Tutorial
🏆
Achievement unlocked!