| Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung |
| modul:m290:learningunits:lu02:loesungen:l01 [2024/08/20 15:11] – vdemir | modul:m290:learningunits:lu02:loesungen:l01 [2024/10/02 15:11] (aktuell) – vdemir |
|---|
| ====== LU02.L01 - Answers: DBS, DBMS and DB ====== | ====== LU03.S01 - Answers: DBS, DBMS and DB ====== |
| |
| 1. TRUE or FASLE: DBMS = DBS and DB? | 1. TRUE or FASLE: DBMS = DBS and DB? |
| * <color #ed1c24>A database system such as Oralce or MySQL consists of the data, stored in tables, and the database management system, that manages the data. </color> | * <color #ed1c24>A database system such as Oralce or MySQL consists of the data, stored in tables, and the database management system, that manages the data. </color> |
| |
| 3. What is the purpose of the DBMS? Give an example.</color> | 3. What is the purpose of the DBMS? Give an example. |
| * <color #ed1c24>The DBMS is a piece of software that manages the data. </color> | * <color #ed1c24>The DBMS is a piece of software that manages the data. </color> |
| * <color #ed1c24>It consists of pre-preogrammed functions, that help managing the data.</color> | * <color #ed1c24>It consists of pre-preogrammed functions, that help managing the data.</color> |
| * <color #ed1c24>This is done to avoid unintentional redundancies within the database.</color> | * <color #ed1c24>This is done to avoid unintentional redundancies within the database.</color> |
| * <color #ed1c24>Each table (entity type: e.g. persons) is composed of columns (attributes: e.g. name, birthdate) and rows (entities: e.g. Max Müller, 12.11.1989)</color> | * <color #ed1c24>Each table (entity type: e.g. persons) is composed of columns (attributes: e.g. name, birthdate) and rows (entities: e.g. Max Müller, 12.11.1989)</color> |
| |
| 5. Which of the following SQL subtypes does **not** exist? Explain the meaning of the other terms. | |
| - DCL = <color #ed1c24>Data Control Language</color> | |
| - DML = <color #ed1c24>Data Manipulation Language</color> | |
| - <color #ed1c24>DXL</color> | |
| - DDL = <color #ed1c24>Data Definition Language</color> | |
| - DQL = <color #ed1c24>Data Query Language</color> | |
| |
| ===== Vocabulary ===== | ===== Vocabulary ===== |