Notes

A collection of structured or unstructured data stored and accessed electronically is called a:
*
1/1
Database

To delete a table using MySQL Workbench, you should:
Right-click the table → Drop Table

VARCHAR is a fixed-length string data type.
False

Which option in Data Export saves all tables into a single SQL file?
*

Export to Self-Contained File

Which numeric data type can store whole numbers from –128 to 127?
*
TINYINT

Timestamps in MySQL represent date and time values starting from January 1, 1970.
1/1
True


Which data type stores date values in YYYY-MM-DD format?
*
DATE

MySQL is classified as what type of database system?
*
Relational DBMS

A compound key contains more than one column to uniquely identify a row.
1/1
True

Which of the following is NOT a feature of MySQL Workbench Community Edition?
GUI for MySQL Enterprise Backup

Which MySQL data type is best for storing long text such as articles?
*
1/1
TEXT

Which of the following enforces referential integrity between tables?
*
1/1
Foreign Key

What is the correct step to create a new database in MySQL Workbench?
*
1/1
Right-click on Schemas → Create Schema


The YEAR data type can store values only in the 4-digit format.
0/1
FALSE DAPAT

MySQL Workbench allows you to visually create and alter tables without manually writing SQL.
1/1
True



SET 2 SET SET 2

Which SQL clause limits the number of returned rows?
*
LIMIT


When exporting a database, which option produces one single SQL file?
Self-Contained File


A Stored Procedure is best described as:
Pre-written SQL code that can be reused

Which MySQL Workbench menu is used to begin creating a new table?
*
1/1
Schemas


Which SQL category includes the commands CREATE, ALTER, DROP?
*
DDL

Which function combines two or more text values?
*CONCAT()

Which SQL command category includes SELECT, INSERT, UPDATE, DELETE? .
DML

A stored procedure can accept parameters.
true


Which SQL command is used to add new rows to a table?
*
insert

Which type of SQL JOIN returns only records with matching values in both tables?
INNER JION


The SQL INSERT command can add multiple rows at once using a single statement.
*
1/1
True

The DISTINCT keyword removes duplicate values from query results.
*
1/1
True


TRUNCATE TABLE deletes the table structure and all its data.
*
1/1
False

Which attribute ensures a column does NOT accept NULL values?
*NN


The SQL UPDATE statement is used to modify existing data in a table.
*
1/1
True