modul:m290:learningunits:lu02:loesungen:l02

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
Nächste Überarbeitung		 Vorhergehende Überarbeitung
modul:m290:learningunits:lu02:loesungen:l02 [2024/08/23 13:41] – vdemirmodul:m290:learningunits:lu02:loesungen:l02 [2024/10/02 15:11] (aktuell) – vdemir
Zeile 1: Zeile 1:
-====== LU02.L02 - Answers: CRUD and SQL ======+====== LU03.S02 - Answers: CRUD and SQL ======
  
 1. Explain what is behind the so-called CRUD operations and add an example. 1. Explain what is behind the so-called CRUD operations and add an example.
Zeile 9: Zeile 9:
 2. What does the acronym SQL stand for? 2. What does the acronym SQL stand for?
   - <color #ed1c24>Structured Query Language</color>   - <color #ed1c24>Structured Query Language</color>
-  - Standard Query Language +  - Standard Query Language. It used to be that name bevor 2000, but changed in "Structured" 
-  - Simple Quarrel Language+  - Simple Quarrel Language. 
  
 ----- -----
  
-3. Which of the following statements about CRUD and SQL is **NOT** correct?+3. Which of the following statements about CRUD and SQL is **not** correct?
   - The CRUD approach is a prerequisite for all types of dynamic web applications.   - The CRUD approach is a prerequisite for all types of dynamic web applications.
   - CRUD is realised in databases by SQL -statements, e.g. SELECT, CREATE, UPDATE and DELETE.   - CRUD is realised in databases by SQL -statements, e.g. SELECT, CREATE, UPDATE and DELETE.
Zeile 23: Zeile 23:
  
 4. Which of the following SQL subtypes does **not** exist? Explain the meaning of the other terms. 4. Which of the following SQL subtypes does **not** exist? Explain the meaning of the other terms.
-  - DCL = <color #ed1c24>Data Control Language</color>  +  - DCL = <color #ed1c24>Data Control Language. Management of users and their permissions.</color>  
-  - DML = <color #ed1c24>Data Manipulation Language</color> +  - DML = <color #ed1c24>Data Manipulation Language. Management of the content. Insert, Update, Delete. </color> 
   - <color #ed1c24>DXL</color>   - <color #ed1c24>DXL</color>
-  - DDL = <color #ed1c24>Data Definition Language</color>  +  - DDL = <color #ed1c24>Data Definition Language. Manamegement of the tables and their structure.</color>  
-  - DQL = <color #ed1c24>Data Query Language</color> +  - DQL = <color #ed1c24>Data Query Language. Structured reading and fetching of content.</color> 
  
 ---- ----
  • modul/m290/learningunits/lu02/loesungen/l02.1724413264.txt.gz
  • Zuletzt geändert: 2024/08/23 13:41
  • von vdemir