Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
| Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
| modul:m290:learningunits:lu02:aufgaben:a02_control_questions [2024/08/14 09:03] – vdemir | modul:m290:learningunits:lu02:aufgaben:a02_control_questions [2024/10/02 15:11] (aktuell) – vdemir | ||
|---|---|---|---|
| Zeile 1: | Zeile 1: | ||
| - | ====== | + | ====== |
| ===== 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. |
| ===== Control questions ===== | ===== Control questions ===== | ||
| - | 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 | + | 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 |
| 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. | ||
| - | 2. What does the acronym SQL stand for? | + | 2. What does the acronym SQL stands |
| - Structured Query Language | - Structured Query Language | ||
| - Standard Query Language | - Standard Query Language | ||
| - | - Simple | + | - Simple |
| - | 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. |
| - | - CRUD has to be applied, if we want to build stable web pages. | + | - 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** exist? Explain the meaning of the other terms. | ||
| + | - DCL | ||
| + | - DML | ||
| + | - DXL | ||
| + | - DDL | ||
| + | - DQL | ||
| ===== Solution ===== | ===== Solution ===== | ||
| - | [[modul: | + | [[modul: |
| ===== Vocabulary ===== | ===== Vocabulary ===== | ||
| ^ English ^ German ^ | ^ English ^ German ^ | ||
| - | | ... | ... | | + | | prerequisite |
| + | | query | abfrage | | ||
| + | | approach | Ansatz, Herangehensweise | | ||
| + | | to apply | anwenden | ||
| ---- | ---- | ||
| [[https:// | [[https:// | ||