Busy. Please wait.
or

show password
Forgot Password?

Don't have an account?  Sign up 
or

Username is available taken
show password

why


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.
We do not share your email address with others. It is only used to allow you to reset your password. For details read our Privacy Policy and Terms of Service.


Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.

Remove ads

DSST Computers #9

Quiz yourself by thinking what should be in each of the black spaces below before clicking on it to display the answer.
        Help  

Question
Answer
Alphabetic Check   Validity check that ensures users enter only alphabetic data in a field.  
Attribute   Each data element in an object. Also called a property.  
Backup   Duplicate or copy of a file, program, or disk that can be used if the original is lost, damaged, or destroyed.  
Character   A number, letter, punctuation mark, or other symbol that is represented by a single byte in the ASCII and EBCDIC coding schemes.  
Check Digit   Validity check consisting of a number(s) or character(s) that is appended to or inserted in a primary key value.  
Collaborative Databases   Web database where users store and share photos, videos, recordings, and other personal media with other registered users.  
Column   Term used by users of relational databases for field.  
Completeness Check   Validity check that verifies that a required field contains data.  
Composite Key   Primary key that consists of multiple fields.  
Consistency Check   Validity check that tests the data in two or more associated field to ensure that the relationship is logical and their data is in the correct format.  
Continuous Backup   Backup plan in which all data is backed up whenever a change is made.  
Data   Collection of unprocessed items, which can include text, numbers, images, audio, and video.  
Data Dictionary   A DBMS element that contains data about each file in a database and each field in those files. Also called a repository.  
Data File   Collection of related records stored on a storage medium such as a hard disk or optical disc.  
Data Model   Rules and standards that define how a database organizes data.  
Data Type   Specifies the kind of data a field in a database can contain and how the field can be used.  
Data Warehouse   Huge database that stores and manages the data required to analyze historical and current transactions.  
Database   Collection of data organized in a manner that allows access retrieval, and use of that data.  
Database administrator (DBA)   Person who creates and maintains the data dictionary, manages security of a database, monitors the performance of a database, and checks backup and recovery procedures.  
Database analyst (DA)   Person who focuses on the meaning and usage of data, including proper placement of fields, defining the relationships among data, and identifying users' access privileges. Also called a data modeler.  
Database approach   System used to store and manage data in which many programs and users share the data in a database.  
Database Management System (DBMS)   Program that allows user to create a computerized database; add, change, and delete data in the database, sort and retrieve data from the database; and create forms and reports from the data in the database. Also called database management software.  
Database Software   Application software used to create, access, and manage a database; add, change, and delete data in the database; sort and retrieve data from the database; and create forms and reports using the data in the database.  
Field   A combination of one or more related characters or bytes, a field is the smallest unit of data a user accesses.  
Field Name   Name that uniquely identifies each field in a database.  
Field Size   Defines the maximum number of characters a field can contain.  
File Maintenance   Procedures that keep data current.  
File Processing System   System used to store and manage data in which each department or area within an organization has its own set of files.  
Form   Window on the screen that provides areas for entering or modifying data in a database. Also called data entry form.  
Garbage In, Garbage Out (GIGO)   Computing phrase that points out the accuracy of a computer's output depends on the accuracy of the input. See also GIGO.  
Information   Processed data that conveys meaning and is useful to people.  
Log   Listing of activities that change the contents of a database.  
Multidimensional Base   Database that stores data in dimensions.  
Numeric Check   Validity check that ensures users enter only numeric data in a field  
Object   Database item that contains data, as well as the actions that read or process the data.  
Object-Oriented Database (OODB)   Database that stores data in objects.  
Primary   Key Field in a database that uniquely identifies each record in a file. Also called key field.  
Principle of Least Privilege   Policy adopted by some organizations, where users' access privileges are limited to the lowest level necessary to perform required tasks.  
Query   Request for specific data from a database.  
Query by Example (QBE)   DBMS feature that has a graphical user interface to assist users with retrieving data.  
Query Language   Language used with databases that consists of simple, English-like statements that allows users to specify the data to display, print, or store.  
Range Check   Validity check that determines whether a number is within a specified range.  
Record   Group of related fields in a database.  
Recovery Utility   DBMS feature that uses logs and/or backups to restore a database when it becomes damaged or destroyed.  
Relation   Term used by developers of relational databases for file.  
Relational Database   Database that stores data in tables that consist of rows and columns, with each row having a primary key and each column having a unique name.  
Relationship   Link within data in a database.  
Report Generator   DBMS feature that allows users to design a report on the screen, retrieve data into the report design, and then display or print the report. Also called a report writer.  
Row   Term used by users of relational databases for record.  
Structured Query Language (SQL)   Query language used with databases that allows users to manage, update, and retrieve data.  
Table   Term used by users of relational databases for file.  
Tuple   Term used by developers of relational databases for record.  
Validation   Process of comparing data with a set of rules or values to find out if the data is correct.  


   






 
share
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
Created by: pinetreeacademy