Chapter 8 MySQL Workbench Flashcards

1
Q

What do the terms CRUD operations refer to?

A

Create, Read, Update, and Delete

These operations are fundamental actions performed in DML.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Fill in the blank: DCL focuses on controlling _______ and permissions.

A

access

DCL is crucial for maintaining data integrity and security.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the relationship between DQL and DML?

A

DQL is often considered a subset of DML

DQL focuses specifically on data retrieval.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

True or False: DTL is focused on manipulating data.

A

False

DTL focuses on managing transactions, not directly on manipulating data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

List common DDL commands.

A
  • CREATE
  • ALTER
  • DROP

These commands are used to create, modify, or delete database objects.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the function of Data Definition Language (DDL)?

A

Defines the structure of the database

DDL commands organize and structure the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Name a key command in DCL.

A
  • GRANT
  • REVOKE

These commands are used to give or take away permissions from users.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What does Data Control Language (DCL) manage?

A

User access and permissions to the database

DCL focuses on the security aspects of data management.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is the primary command of DQL?

A

SELECT

Used to fetch specific data based on various criteria.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is Data Query Language (DQL) primarily focused on?

A

Retrieving data from the database

DQL is often considered a subset of DML.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

List the key DML commands.

A
  • INSERT
  • SELECT
  • UPDATE
  • DELETE

These operations are collectively referred to as CRUD—Create, Read, Update, and Delete.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the purpose of Data Manipulation Language (DML)?

A

Used for manipulating actual data within the database tables

DML commands work directly with data records.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Name a key command in DTL.

A
  • COMMIT
  • ROLLBACK
  • SAVEPOINT

These commands manage changes within a transaction.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What does Data Transaction Language (DTL) handle?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is a File Path?

A

Location where exported data is saved.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What does the Refresh Button do?

A

Updates the displayed list of schemas.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What does Export to Self-Contained File mean?

A

Option to save exported database data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is the Error Message Log?

A

Displays errors during procedure or function creation.

19
Q

What is the Apply Button?

A

Confirms changes in MySQL Workbench.

20
Q

What is the Management Section?

A

Part of MySQL Workbench for database management.

21
Q

What does CREATE FUNCTION do?

A

SQL command to define a function.

22
Q

What is a Function in SQL?

A

Reusable SQL code that returns a value.

23
Q

What does CREATE PROCEDURE do?

A

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.

24
Q

What is a Stored Procedure?

A

Predefined SQL code stored for reuse.

25
Q

What are Column Constraints?

A

Rules that data in a column must follow.

26
Q

What does the Backtick (`) do?

A

Delimits identifiers in SQL statements.

27
Q

What is the Table Data Export Wizard?

A

Tool for exporting table data to file.

28
Q

What is the Table Data Import Wizard?

A

Tool for importing data into a table.

29
Q

What is a JSON File?

A

JavaScript Object Notation file for data storage.

30
Q

What is a CSV File?

A

Comma-separated values file for data storage.

31
Q

What is Data Export?

A

Feature to export database to SQL file.

32
Q

What is the Schemas Tab?

A

Navigator section displaying database schemas.

33
Q

What is a Self-Contained File?

A

Single file containing all database data.

34
Q

What is the Data Import/Restore feature?

A

MySQL Workbench feature for importing databases.

35
Q

What does INSERT INTO do?

A

SQL command to add data to a table.

36
Q

What is the Department Table?

A

Table storing department records in database.

37
Q

What is the Employee Table?

A

Table storing employee records in database.

38
Q

What is the CREATE TABLE command used for?

A

SQL command to define a new table structure.

39
Q

What does the DROP TABLE command do?

A

SQL command to delete a table.

40
Q

What is the purpose of the CREATE DATABASE command?

A

SQL command to create a new database.

41
Q

What is an SQL File?

A

File containing SQL statements for database operations.

42
Q

What does ‘Import Database’ mean?

A

Load SQL file to create a database.

43
Q

What is MySQL Workbench?

A

Tool for managing MySQL databases.