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/14 09:18] – 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 6: Zeile 6:
   * <color #ed1c24>It outlines the basic operations for data management but doesn't specify how these operations are implemented. </color>   * <color #ed1c24>It outlines the basic operations for data management but doesn't specify how these operations are implemented. </color>
  
 +----
 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. 
-  - The CRUD approach groups SQL-operations logically+  - The CRUD approach groups SQL-operations logically.
   - <color #ed1c24>CRUD is an alternative to SQL and has to be applied, if we want to build stable web pages.</color>   - <color #ed1c24>CRUD is an alternative to SQL and has to be applied, if we want to build stable web pages.</color>
 +
 +----
 +
 +4. Which of the following SQL subtypes does **not** exist? Explain the meaning of the other terms.
 +  - DCL = <color #ed1c24>Data Control Language. Management of users and their permissions.</color> 
 +  - DML = <color #ed1c24>Data Manipulation Language. Management of the content. Insert, Update, Delete. </color> 
 +  - <color #ed1c24>DXL</color>
 +  - DDL = <color #ed1c24>Data Definition Language. Manamegement of the tables and their structure.</color> 
 +  - DQL = <color #ed1c24>Data Query Language. Structured reading and fetching of content.</color> 
 +
 +----
  
 ===== Vocabulary ===== ===== Vocabulary =====
  • modul/m290/learningunits/lu02/loesungen/l02.1723619930.txt.gz
  • Zuletzt geändert: 2024/08/14 09:18
  • von vdemir