Databases

Edit Answers
123456789101112
Across
  1. 2. Used to filter records by setting conditions
  2. 3. A function used to calculate the total of a numeric column.
  3. 6. Sorts the result of a query in ascending (ASC) or descending (DESC) order.
  4. 8. A datatype used to store text (letters, words, or sentences).
  5. 9. Columns in a table; each field represents a specific type of data (e.g., Name, Age).
  6. 11. Raw facts or information stored in a database (e.g., names, numbers, dates).
  7. 12. A temporary name given to a table or column to make results more readable.
Down
  1. 1. Specifies the table where the data will be taken from.
  2. 3. A command used to choose which columns (fields) you want to display from a database table.
  3. 4. A function used to count the number of records or values in a column.
  4. 5. Rows in a table; each record contains a complete set of related data
  5. 7. A datatype that stores only two values: TRUE or FALSE.
  6. 10. Define the kind of data a column can hold (e.g., text, numbers, dates).