Database Domain 1

2. A data type that allows for values to be either true or false.
3. A database object with organized rows and columns as data. Also known as a table.
5. An index based on the primary key of an entity.
6. A limitation on what can be entered in a data field within an entity.
7. Information that is organized, entered into files, and then retrievable as needed.
9. A primary key consisting of two or more fields. Also known as a composite key.
12. A data type that holds dates and times.
13. A SQL keyword used to remove a database object.
14. A SQL keyword used to show the number of records within a query.
15. A backup of data that has changed since the last full backup.
17. Adding a row of data to an entity.
18. A SQL keyword used to add an object to a database or add an entire database to an instance of SQL Server.
19. A file that stores data and allows people to search and create reports from the data.
20. A primary key consisting of two or more fields. Also known as a compound key.

1. A combining of two unrelated tables within a query.
4. A SQL keyword used to remove data from an entity.
7. A setting that defines what kind of data can be entered in a field, such as a number, date, or text string.
8. A unit of measurement used to determine how much memory a piece of data will take.
10. A keyword used to return records without duplicate values among fields specified in a query.
11. A symbol used to define a filter within a query, for example, the greater than or equal to symbol (>=).
16. A property that defines data in an entity. Also known as a field.