WorksheetsExploring SQL and MySQL Fundamentals
Total questions: 20
Worksheet time: 10mins
What is one advantage of using SQL?
It guarantees data security and privacy.
It automatically generates reports and analytics.
It simplifies complex data structures.
It enables efficient data retrieval and manipulation.
Which of the following is a Data Type in MySQL?
CHAR
FLOAT
BOOLEAN
INT
What command is used to create a new database in MySQL?
CREATE DATABASE database_name;
NEW DATABASE database_name;
ADD DATABASE database_name;
INIT DATABASE database_name;
What is the purpose of the CREATE TABLE statement?
To update records in a database table.
To retrieve data from a database table.
To delete an existing table from a database.
To define a new table in a database.
Which language is used to manipulate data in a database?
HTML
Java
SQL
Python
What does DDL stand for in the context of SQL?
Data Design Language
Data Delivery Logic
Data Definition Language
Data Distribution Layer
Name a common data type used for storing text in MySQL.
TEXT
CHAR
STRING
VARCHAR
What command would you use to add a new record to a table?
INSERT INTO table_name (column1, column2) VALUES (value1, value2);
UPDATE table_name SET column1 = value1 WHERE condition;
DELETE FROM table_name WHERE condition;
SELECT * FROM table_name WHERE condition;
What is the purpose of the Data Query Language?
The purpose of the Data Query Language is to retrieve data from a database.
The purpose of the Data Query Language is to delete data from a database.
The purpose of the Data Query Language is to create new databases.
The purpose of the Data Query Language is to update data in a database.
Which command is used to delete a database in MySQL?
DELETE DATABASE database_name;
DROP DATABASE database_name;
REMOVE DATABASE database_name;
CLEAR DATABASE database_name;
What is the syntax to create a table in MySQL?
CREATE TABLE table_name (column1_name column1_datatype, column2_name column2_datatype, ...);
TABLE table_name (column1_name column1_datatype);
INSERT INTO table_name (column1_name, column2_name);
CREATE NEW table_name (column1, column2);
What data type would you use for storing whole numbers?
float
string
integer
boolean
How do you retrieve data from a table using SQL?
GET data FROM table_name WHERE condition;
SELECT column1, column2 FROM table_name WHERE condition ORDER BY column_name LIMIT number;
FETCH column1, column2 FROM table_name;
RETRIEVE column1, column2 IN table_name WHERE condition;
What is the difference between DML and DQL?
DML is for data manipulation (INSERT, UPDATE, DELETE), while DQL is for data querying (SELECT).
DML handles data storage (SAVE), whereas DQL manages data visualization (DISPLAY).
DML is for data querying (SELECT), while DQL is for data manipulation (INSERT, UPDATE, DELETE).
DML is used for data definition (CREATE, ALTER), while DQL is for data retrieval (FETCH).
Which command is used to modify existing records in a table?
INSERT
SELECT
DELETE
UPDATE
What is the purpose of the PRIMARY KEY in a table?
To define the data type of each column in a table.
To uniquely identify each record in a table.
To enforce data integrity across multiple tables.
To group related records in a table.
What data type is used for storing decimal numbers in MySQL?
DECIMAL or NUMERIC
CHAR or VARCHAR
INTEGER or BIGINT
FLOAT or REAL
What command would you use to view the structure of a table?
SELECT * FROM table_name;
DESCRIBE table_name; or SHOW COLUMNS FROM table_name;
SHOW TABLES;
CREATE TABLE table_name;
What is the significance of using indexes in a database?
Indexes are only useful for large databases with millions of records.
Indexes significantly enhance query performance and data retrieval speed in a database.
Indexes are primarily used for data backup and recovery processes.
Indexes slow down data updates and modifications in a database.
How can you ensure that a column in a table cannot be null?
Set the column to auto-increment.
Allow NULL values in the column definition.
Use the DEFAULT constraint on the column.
Use the NOT NULL constraint on the column.
