Testout IT Fundamentals Databases

A structured set of data held in a computer, usually in a way that is accessible by multiple concurrent users is called a _____________?

• Database

• SQL

• Query

• Report

A method of asking questions about the data stored in a database.

• Database

• SQL

• Query

• Report

A graphical interface that allows users to query a database by filling in information on the form.

• Database

• SQL

• Form

• Report

A field in a table that uniquely identifies a record.

• Record

• Primary Key

• Foreign Key

• Report

A field that corresponds to the primary key field in another table.

• Record

• Primary Key

• Foreign Key

• Report

Software that allows users to define, manipulate, retrieve, and manage data stored in a database. Examples are Microsoft SQL Server, Oracle Database, MySQL, and Microsoft Access.

• Data Modeling

• Operational Data

• Analytical Data

• Database Management System (DBMS)

A design technique that organizes data in a database in an optimal way. This results in it being easier to add, remove, and update data without introducing errors.

• Report

• Normalization

• Form

• Query

A method of accessing a database using forms that allow users to interact with the database.

• User Interface Access

• Programmatic Access

• Query Builder

• Direct Access

A method of accessing a database directly using the database management system itself.

• User Interface Access

• Programmatic Access

• Query Builder

• Direct Access

A method of accessing a database using custom computer programs.

• User Interface Access

• Programmatic Access

• Query Builder

• Direct Access