LU03.A02 - Control questions: CRUD and SQL

Requirements

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.

  1. Structured Query Language
  2. Standard Query Language
  3. Simple Quarrel Language

3. Which of the following statements about CRUD and SQL is not correct?

  1. The CRUD approach is a prerequisite for all types of dynamic web applications.
  2. CRUD is realised in databases by SQL statements, e.g. SELECT, CREATE, UPDATE and DELETE.
  3. The CRUD approach groups SQL-operations logically.
  4. 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.

  1. DCL
  2. DML
  3. DXL
  4. DDL
  5. DQL

Solution

Lösung

Vocabulary

English German
prerequisite Voraussetzung
query abfrage
approach Ansatz, Herangehensweise
to apply anwenden

Volkan Demir