Computers: Understanding Tech 5e 12.6
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
database administration | An important IT function that involves operating and maintaining the database system.
🗑
|
||||
database administrator (DBA) | The person who handles the daily database operations, including installing and upgrading the database, ensuring rapid response times, integrating security strategies, and completing regular data backups.
🗑
|
||||
downtime | Time in which a system is unavailable.
🗑
|
||||
data corruption | A serious failure that occurs when data is unreadable, incomplete, or damaged.
🗑
|
||||
backup and recovery plan | A plan developed by a database administrator to ensure frequent data backups. It enables the administrator to recover the data in the event of a data loss.
🗑
|
||||
database response time | The lag time between a user issuing a command and the database system taking action.
🗑
|
||||
record locking | A situation that occurs when multiple users attempt to edit an existing record, automatically preventing changes to be written to the database as a safety precaution. The DBMS only allows one user at a time to alter a record.
🗑
|
||||
data integrity | A term that describes the accuracy of the information provided to database users. Sometimes called data quality.
🗑
|
||||
redundancy | The duplication of one or more fields of data in multiple tables.
🗑
|
||||
normalization | The process of structuring a database to avoid redundancy (duplication of entries) and undesirable dependencies (relationships between entries).
🗑
|
||||
data contamination | A ripple effect caused by an error in the system. It involves the spread of incorrect information and can have serious consequences.
🗑
|
||||
data validation | Techniques that ensure that users enter correct and complete data into the system.
🗑
|
||||
referential integrity | Involves making sure that the records entered into tables remain consistent with the relationships between the tables.
🗑
|
||||
range check | A simple error-checking system usually performed on numeric data entries.
🗑
|
||||
alphanumeric check | A data validation check that allows only letters of the alphabet and digits to be entered.
🗑
|
||||
consistency check | A data validation check made against previously entered data that has already been validated.
🗑
|
||||
completeness check | A data validation check that ensures that every required field in a record contains an entry.
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
softcrylic
Popular Computers sets