Criado por João Vitor de Oliveira Carlos
quase 6 anos atrás
|
||
Questão | Responda |
What is the logical query processing order of the followings clauses: SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY | 1. FROM 2. WHERE 3. GROUP BY 4. HAVING 5. SELECT 6. ORDER BY |
What is a relation? Define the term! | A relation in the relational model is what SQL represents with a table. A relation has a heading and a body. The heading is a set of attributes (what SQL attempts to represent with columns), each of a given type. An attribute is identified by name and type name. The body is a set of tuples (what SQL attempts to represent with rows). Each tuple’s heading is the heading of the relation. Each value of each tuple’s attribute is of its respective type. |
Quer criar seus próprios Flashcards gratuitos com GoConqr? Saiba mais.