This Quiz contains totally 25 Questions each carry 1 point for you.
- What is a database?
A collection of unrelated data
A collection of structured and related data
A random collection of information
A file storage system
Correct!
Wrong!
2. Which type of database is used most commonly in large-scale projects?
Hierarchical database
Network database
Relational database
Object-oriented database
Correct!
Wrong!
3. In a database, what is a record?
A group of fields
A collection of tables
A single entry in a table
The total database file
Correct!
Wrong!
4. What does SQL stand for?
Structured Queried Language
Sequential Query Language
Structured Query Language
Sequential Quick Language
Correct!
Wrong!
5. What is a primary key in a relational database?
A unique identifier for a record in the table
A secondary identifier for a record in the table
A foreign key in another table
A non-unique identifier for a record
Correct!
Wrong!
6. In a relational database, what is a relationship?
A connection between two tables
A connection within a single table
The structure of the data within a table
The total number of tables in a database
Correct!
Wrong!
7. What does DBMS stand for?
Data Base Management System
Database Management Security
Data Base Managing System
Database Management System
Correct!
Wrong!
8. What is the role of a DBMS?
It only creates databases
It manages, controls, and organizes the database
It only deletes data in a database
It only updates data in a database
Correct!
Wrong!
9. Which of the following is a type of DBMS?
MySQL
PHP
JavaScript
HTML
Correct!
Wrong!
10. What type of database system is MySQL?
Relational Database Management System (RDBMS)
Hierarchical Database Management System
Network Database Management System
Object-Oriented Database Management System
Correct!
Wrong!
11. Which language does MySQL use to manipulate data?
Python
SQL
Java
C++
Correct!
Wrong!
12. What is a "schema" in MySQL?
A set of rules for the database
The overall structure of the database
A single row in a table
The user interface of the MySQL workbench
Correct!
Wrong!
13. Which one of these is NOT a characteristic of a database?
Persistence
Redundancy
Security
Randomness
Correct!
Wrong!
14. What is a "tuple" in a relational database?
A table
A column
A row
A relationship between tables
Correct!
Wrong!
15. In a relational database, what is a foreign key?
A key that is only used in the home table
A key that is a primary key in another table
A key that can be null
A key that is unique across all tables
Correct!
Wrong!
16. Which of the following is NOT a function of a Database Management System?
Data storage
Data redundancy
Data integrity
Data security
Correct!
Wrong!
17. Which type of DBMS is best for handling relationships between entities?
Hierarchical DBMS
Network DBMS
Relational DBMS
Object-oriented DBMS
Correct!
Wrong!
18. What MySQL command is used to retrieve data from a database?
GET
RETRIEVE
SELECT
PULL
Correct!
Wrong!
19. What MySQL command is used to remove a table from a database?
REMOVE TABLE
DELETE
DROP TABLE
DISCARD TABLE
Correct!
Wrong!
20. How would you change the value of a field in MySQL?
CHANGE
MODIFY
UPDATE
ALTER
Correct!
Wrong!
21. Which is the default port for MySQL server?
80
443
3306
8080
Correct!
Wrong!
22. Which command is used to create a database in MySQL?
MAKE DATABASE
ADD DATABASE
CREATE DATABASE
NEW DATABASE
Correct!
Wrong!
23. In MySQL, what is a NULL value?
0
Empty string
Undefined or unknown value
Space character
Correct!
Wrong!
24. What is the purpose of the "JOIN" command in SQL?
To combine rows from two or more tables, based on a related column between them
To exclude rows that meet certain criteria
To sort the result-set in ascending or descending order
To delete existing records in a table
Correct!
Wrong!
25. In SQL, what does the "GROUP BY" statement do?
It categorizes rows that have the same values in specified columns into aggregated data
It updates columns in table
It deletes groups of rows from the table
It generates a random grouping of data
Correct!
Wrong!
Share the quiz to show your results !
Subscribe to see your results
Ignore & go to results
MySQL Introduction – Quiz
You got %%score%% of %%total%% right
%%description%%
%%description%%
Loading...