Database Management with XAMPP and VS Code

What is XAMPP primarily used for?

• Video editing

• Web server solution stack

• Graphic design

• Data analysis

Which database management system is included in XAMPP?

• PostgreSQL

• Oracle

• MySQL

• SQLite

What is the main difference between MySQL and MariaDB?

• MariaDB is a fork of MySQL with additional features

• MySQL is open-source, while MariaDB is proprietary

• MariaDB is only available on Windows

• MySQL supports more programming languages than MariaDB

What is the primary purpose of using Visual Studio Code (VS Code)?

• Image editing

• Video streaming

• Source code editing

• Database management

What is the default port number for MySQL?

• 80

• 3306

• 8080

• 5432

Which of the following is a command-line tool for managing MySQL databases?

• phpMyAdmin

• MySQL Workbench

• MySQL Shell

• HeidiSQL

What is the file extension for a SQL script file?

• .sql

• .db

• .txt

• .data

What is the command to start the Apache server in XAMPP?

• start-apache

• apachectl start

• xampp startapache

• service apache2 start

Which of the following is NOT a component of XAMPP?

• Apache

• PHP

• MongoDB

• Perl

What is the purpose of the 'htdocs' folder in XAMPP?

• To store configuration files

• To store web application files

• To store database backups

• To store log files