| 1/12 | 13 | 14 | 16 | ||||||||||||||||||||||
| 18 | |||||||||||||||||||||||||
| 2 | 17 | ||||||||||||||||||||||||
| 3 | |||||||||||||||||||||||||
| 15 | |||||||||||||||||||||||||
| 4 | |||||||||||||||||||||||||
| 5 | |||||||||||||||||||||||||
| 6 | |||||||||||||||||||||||||
| 8 | 7 | ||||||||||||||||||||||||
| 9 | |||||||||||||||||||||||||
| 10 | |||||||||||||||||||||||||
| 11 | |||||||||||||||||||||||||
1. A method used to retrieve specific information from a database by creating a virtual table that combines data from multiple tables.
2. A statement in SQL that allows you to perform different actions based on a set of conditions.
3. Individuals who may lack specialized knowledge in programming or database languages.
4. The property that ensures that committed transactions survive permanent system failures.
5. The process of planning and creating a database structure that meets the requirements of the organization, including determining tables, relationships, and constraints.
6. A DDL query used to change the name of an existing table.
7. The storage of the same data in multiple places within a database, which can lead to inconsistency and inefficiency.
8. A set of rules and symbols used for communication and expression.
9. A table that is not physically stored in the database but is created dynamically based on the result of a query.
10. A lightweight relational database management system (RDBMS) that uses its own storage engine and is contained in a single disk file without a separate server process.
11. The protection of electronic databases from unauthorized access, use, disclosure, disruption, modification, or destruction.
12. The structure that defines the organization of data, including the tables, fields, and relationships within a database.
13. A concurrency control technique in database systems where transactions are ordered based on their timestamp values.
14. The process of creating copies of data to ensure its availability in case of data loss or corruption.
15. Symbols used to represent parameter placeholders in a SQL statement.
16. The technique of creating data structures, called indexes, to improve the speed of data retrieval operations in a database.
17. A type of database optimized for storing and retrieving time-stamped or time-series data, such as sensor readings or financial market data.
18. A unique identifier for each record in a table.