Instructor Created Flashcards

Question

What does risk value encompass?

Answer 1

Improved visibility into credit exposure and confidence in capital investments ## Footnote It also involves *maintaining auditable records*.

Answer 2

A centralized repository of information ## Footnote [📖](https://share.evernote.com/note/42449ea4-7e25-1fdd-e23b-3c69d5b5308d) It is essential for data analysis and reporting.

Answer 3

Around relevant subject areas important to the organization ## Footnote This organization supports targeted data analysis.

Answer 4

For analysis and not for transaction processing ## Footnote This distinction is critical for understanding its role in data management.

Answer 5

Nonvolatile ## Footnote Nonvolatility means that data remains stable and is not frequently changed.

Answer 6

A data warehouse ## Footnote It consolidates data from both internal and external sources.

Answer 7

[consumers] ## Footnote Consumers can be both human and automated.

Answer 8

A visual database design and management tool for MySQL databases.

Answer 9

Provides a user-friendly interface for: 1. database modeling 2. SQL development 3. server configuration 4. user administration 5. backupand data recovery

Answer 10

Managing MySQL databases graphically, *creating visual representations* of database schemas, and *managing complex SQL statements*.

Answer 11

A command-line interface for interacting with MySQL databases.

Answer 12

Allows users to execute SQL queries, manage databases, and perform administrative tasks directly through the terminal.

Answer 13

Users who prefer command-line operations or are working on servers without a graphical interface.

Answer 14

A management tool for Microsoft SQL Server databases.

Answer 15

Offers a **graphical interface** for SQL Server database: *development, management, and administration*, including querying and performance monitoring.

Answer 16

A web-based application to manage MySQL databases.

Answer 17

Offers a browser interface for executing SQL queries, managing tables, and handling database administration tasks.

Answer 18

1. MySQL Workbench and phpMyAdmin are specifically for MySQL databases 2. SQL Server Management Studio is exclusively for Microsoft SQL Server.

Answer 19

A unique identifier for each record in a table.

Answer 20

* Cannot contain null values * Must contain unique values

Answer 21

Establishes a one-to-one or one-to-many relationship with foreign keys in other tables.

Answer 22

A column or a set of columns in one table that references the primary key in another table.

Answer 23

* Can contain null values * Can have duplicate values

Answer 24

Establishes a many-to-one relationship with the table containing the primary key.

Answer 25

A combination of two or more columns in a table that together uniquely identify a record.

Answer 26

* May allow null values in some columns * Always consists of multiple columns

Answer 27

Establishes relationships where each part of the composite key must be *considered in conjunction* with others.

Answer 28

A column or set of columns that can qualify as a potential primary key for a table.

Answer 29

* Can contain null values * Must contain unique values

Answer 30

**Filters records** based on a specified condition.

Answer 31

Restricts the number of rows returned by the query.

Answer 32

Checks if a *column’s value* exists within a list of specified values.

Answer 33

Checks if a value falls within a specified inclusive range.

Answer 34

Evaluates whether _a subquery_ returns *any* rows.

Answer 35

Checks if all values in a subquery *meet a specific condition*.

Answer 36

``` UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; ``` `UPDATE` table_name `SET` ... is the core. However, always use `WHERE` condition to specify which rows to update

Answer 37

Saves all changes made in the current transaction to the database permanently.

Answer 38

Undoes all changes made in the current transaction.

Answer 39

Creates a savepoint within a transaction allowing for partial rollbacks.

Answer 40

Not a standard SQL command; behavior is generally covered by the ROLLBACK command.

Answer 41

Filters results within a specific range (inclusive).

Answer 42

Used for pattern matching in SQL.

Answer 43

The BETWEEN operator is used to filter results within a specific range (inclusive). ## Footnote It checks if a column’s value is within a specified lower and upper limit.

Answer 44

Numeric, date, or text values.

Answer 45

SELECT * FROM products WHERE price BETWEEN 50 AND 100;

Answer 46

The LIKE operator is used for pattern matching in SQL.

Answer 47

SELECT * FROM employees WHERE last_name LIKE 'Smi%';

Answer 48

The IN operator is used to specify multiple values in a WHERE clause.

Answer 49

Numeric, character, or date values.

Answer 50

SELECT * FROM customers WHERE country IN ('USA', 'Canada', 'Mexico');

Answer 51

The EXISTS operator is used to check for the existence of any records in a subquery.

Answer 52

Frequently used with subqueries to filter records based on conditions in related tables.

Answer 53

SELECT * FROM products p WHERE EXISTS (SELECT * FROM orders o WHERE o.product_id = p.product_id);

Answer 54

Filters data within a specified inclusive range.

Answer 55

>= and <= (Greater Than or Equal To, Less Than or Equal To)

Answer 56

SELECT * FROM employees WHERE salary >= 50000 AND salary <= 100000;

Answer 57

Similar to BETWEEN, but does not include the boundaries.

Answer 58

SELECT * FROM employees WHERE salary > 50000 AND salary < 100000;

Answer 59

When you want to specify a clear range with inclusive boundaries.

Answer 60

Used to group rows that have the same values in specified columns into aggregate data.

Answer 61

COUNT, SUM, AVG

Answer 62

SELECT department, COUNT(*) FROM employees GROUP BY department;

Answer 63

Used to sort the result set of a query by one or more columns.

Answer 64

Ascending (ASC) or descending (DESC) order.

Answer 65

SELECT name, salary FROM employees ORDER BY salary DESC;

Answer 66

Typically used in contexts involving window functions.

Answer 67

SELECT department, COUNT(*) FILTER (WHERE salary > 50000) FROM employees GROUP BY department;

Answer 68

GROUP BY aggregates data based on one or more columns, while ORDER BY sorts the results of the query.