01 SQL Foundations Unlocked

Multiple Choice

Why is SQL considered a foundational skill in the tech industry, even decades after its creation?

• Because it is easy to learn

• Because it is used in almost every major tech system

• Because it was invented by IBM

• Because it is only used for small databases

Multiple Choice

Which DBMS is recommended for beginners but also powerful for professional scale?

• PostgreSQL

• SQLite

• MariaDB/MySQL

• Oracle

Multiple Select

Which features are available in phpMyAdmin's dashboard?

• Query SQL

• Database creation

• User account management

• Terminal emulation

Multiple Choice

What is the main purpose of a database in SQL, as described in the analogy of building a special room for your collection?

• To store data in an organized way

• To display data visually

• To create backups automatically

• To delete data permanently

Open Ended

Explain the importance of using a unique name when creating a database. What could happen if the name is not unique?

Multiple Select

Which commands are used to customize a database to support emojis and multiple languages? Select all that apply.

• CHARACTER SET

• COLLATE

• USE

• DROP

Multiple Choice

Which command will permanently delete a database and all its contents?

• DROP DATABASE

• DELETE DATABASE

• REMOVE DATABASE

• CLEAR DATABASE

Multiple Choice

What are the basic tasks you have learned to perform in phpMyAdmin after setting up XAMPP?

• Creating, selecting, and deleting databases

• Installing XAMPP only

• Configuring network settings

• Writing PHP scripts