====== LU03.A02 - Control questions: CRUD and SQL ====== ===== Requirements ===== * Work type: individual * Means of aid: only teaching materials, no websearch, no use of ai. * Timeframe: 10 Minutes * Expected result: Word/PDF file with the answers of the 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 wrong statements. 1. Explain what is behind the so-called CRUD operations and add an example. 2. What does the acronym SQL stands for? Choose the correct answer. - 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** exist? Explain the meaning of the other terms. - DCL - DML - DXL - DDL - DQL ===== Solution ===== [[modul:m290:learningunits:lu02:loesungen:l02|Lösung]] ===== Vocabulary ===== ^ 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