Chapter 8 MySQL Workbench Flashcards
What do the terms CRUD operations refer to?
Create, Read, Update, and Delete
These operations are fundamental actions performed in DML.
Fill in the blank: DCL focuses on controlling _______ and permissions.
access
DCL is crucial for maintaining data integrity and security.
What is the relationship between DQL and DML?
DQL is often considered a subset of DML
DQL focuses specifically on data retrieval.
True or False: DTL is focused on manipulating data.
False
DTL focuses on managing transactions, not directly on manipulating data.
List common DDL commands.
- CREATE
- ALTER
- DROP
These commands are used to create, modify, or delete database objects.
What is the function of Data Definition Language (DDL)?
Defines the structure of the database
DDL commands organize and structure the database.
Name a key command in DCL.
- GRANT
- REVOKE
These commands are used to give or take away permissions from users.
What does Data Control Language (DCL) manage?
User access and permissions to the database
DCL focuses on the security aspects of data management.
What is the primary command of DQL?
SELECT
Used to fetch specific data based on various criteria.
What is Data Query Language (DQL) primarily focused on?
Retrieving data from the database
DQL is often considered a subset of DML.
List the key DML commands.
- INSERT
- SELECT
- UPDATE
- DELETE
These operations are collectively referred to as CRUD—Create, Read, Update, and Delete.
What is the purpose of Data Manipulation Language (DML)?
Used for manipulating actual data within the database tables
DML commands work directly with data records.
Name a key command in DTL.
- COMMIT
- ROLLBACK
- SAVEPOINT
These commands manage changes within a transaction.
What does Data Transaction Language (DTL) handle?
Handles the beginning and ending of transactions
A transaction is a sequence of SQL statements treated as a single unit of work, ensuring data consistency.
What is a File Path?
Location where exported data is saved.
What does the Refresh Button do?
Updates the displayed list of schemas.
What does Export to Self-Contained File mean?
Option to save exported database data.
What is the Error Message Log?
Displays errors during procedure or function creation.
What is the Apply Button?
Confirms changes in MySQL Workbench.
What is the Management Section?
Part of MySQL Workbench for database management.
What does CREATE FUNCTION do?
SQL command to define a function.
What is a Function in SQL?
Reusable SQL code that returns a value.
What does CREATE PROCEDURE do?
SQL command to define a stored procedure.
stored procedure, which is a pre-compiled collection of SQL statements that can be executed as a single unit.
What is a Stored Procedure?
Predefined SQL code stored for reuse.
