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.
What are Column Constraints?
Rules that data in a column must follow.
What does the Backtick (`) do?
Delimits identifiers in SQL statements.
What is the Table Data Export Wizard?
Tool for exporting table data to file.
What is the Table Data Import Wizard?
Tool for importing data into a table.
What is a JSON File?
JavaScript Object Notation file for data storage.
What is a CSV File?
Comma-separated values file for data storage.
What is Data Export?
Feature to export database to SQL file.
What is the Schemas Tab?
Navigator section displaying database schemas.
What is a Self-Contained File?
Single file containing all database data.
What is the Data Import/Restore feature?
MySQL Workbench feature for importing databases.
What does INSERT INTO do?
SQL command to add data to a table.
What is the Department Table?
Table storing department records in database.
What is the Employee Table?
Table storing employee records in database.
What is the CREATE TABLE command used for?
SQL command to define a new table structure.
What does the DROP TABLE command do?
SQL command to delete a table.
What is the purpose of the CREATE DATABASE command?
SQL command to create a new database.
What is an SQL File?
File containing SQL statements for database operations.
What does ‘Import Database’ mean?
Load SQL file to create a database.
What is MySQL Workbench?
Tool for managing MySQL databases.