Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Nächste Überarbeitung
Vorhergehende Überarbeitung
modul:m290:learningunits:lu02:aufgaben:a02_control_questions [2024/08/13 17:33] – angelegt vdemirmodul:m290:learningunits:lu02:aufgaben:a02_control_questions [2024/10/02 15:11] (aktuell) vdemir
Zeile 1: Zeile 1:
-====== LU02.A02 - Control questions: CRUD and SQL ======+====== LU03.A02 - Control questions: CRUD and SQL ======
  
 ===== Requirements  ===== ===== Requirements  =====
Zeile 5: Zeile 5:
   * Means of aid: only teaching materials, no websearch, no use of ai.   * Means of aid: only teaching materials, no websearch, no use of ai.
   * Timeframe: 10 Minutes   * Timeframe: 10 Minutes
-  * Expected result: Word/PDF file with the answers of the control questions+  * Expected result: Word/PDF file with the answers of the control questions.
  
-===== Introduction  ===== 
-... 
  
 ===== Control questions ===== ===== Control questions =====
-Answer the following questions respectively state the correct solution.+After the terms SQL, CRUD and the connection between the two acronyms have been explained to you, you can answer the following control questions or correct wrong statements.
  
-  - ... +1. Explain what is behind the so-called CRUD operations and add an example. 
-  - ... + 
-  - What is the purpose of the DBMS? Give an example+2What does the acronym SQL stands for? Choose the correct answer
-  - What is store in the DB? How it is stored+  - Structured Query Language 
 +  - Standard Query Language 
 +  - Simple Quarrel Language 
 + 
 +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. 
 +  - CRUD is realised in databases by SQL statements, e.g. SELECT, CREATE, UPDATE and DELETE. 
 +  - The CRUD approach groups SQL-operations logically. 
 +  - CRUD is an alternative to SQL and has to be applied, if we want to build stable web pages. 
 + 
 +4. Which of the following SQL subtypes does **not** existExplain the meaning of the other terms. 
 +  - DCL 
 +  - DML 
 +  - DXL 
 +  - DDL 
 +  - DQL
  
 ===== Solution ===== ===== Solution =====
-[[modul:m290:learningunits:lu02:loesungen:l01|Lösung]]+[[modul:m290:learningunits:lu02:loesungen:l02|Lösung]]
  
  
 ===== Vocabulary ===== ===== Vocabulary =====
 ^ English ^ German ^  ^ English ^ German ^ 
-... ... |+prerequisite  Voraussetzung | 
 +| query | abfrage | 
 +| approach | Ansatz, Herangehensweise | 
 +| to apply | anwenden |
  
  
 ---- ----
 [[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir [[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir
  • modul/m290/learningunits/lu02/aufgaben/a02_control_questions.1723563197.txt.gz
  • Zuletzt geändert: 2024/08/13 17:33
  • von vdemir