Database Systems Chapter 1 Flashcards

A spur-of-the-moment question.

A database located at a single site.

Raw facts that have not yet been processed to reveal their meaning.

<p>A data abnormality that exists when inconsistent changes to a database have been made.</p> Signup and view all the answers

<p>A data condition in which the data representation and manipulation are dependent on the physical data storage characteristics.</p> Signup and view all the answers

<p>A DBMS component that stores metadata about data.</p> Signup and view all the answers

<p>A condition in which different versions of the same data yield different results.</p> Signup and view all the answers

<p>A condition that exists when data access is unaffected by changes in the physical data storage characteristics.</p> Signup and view all the answers

<p>A condition in which the data in the database is in compliance with all entity and referential integrity constraints.</p> Signup and view all the answers

<p>A process that focuses on data collection, storage, and retrieval.</p> Signup and view all the answers

<p>A comprehensive approach to ensuring the accuracy, validity, and timeliness of data.</p> Signup and view all the answers

<p>A condition that exists when a data environment contains unnecessarily duplicated data.</p> Signup and view all the answers

<p>An integrated, subject-oriented, time-variant, nonvolatile collection of data that provides support for decision making.</p> Signup and view all the answers

<p>A shared, integrated computer structure that houses a collection of related data.</p> Signup and view all the answers

<p>The process that yields the description of the database structure.</p> Signup and view all the answers

<p>The collection of programs that manages the database structure and controls access to the data.</p> Signup and view all the answers

<p>An organization of components that defines and regulates the collection, storage, management, and use of data in a database environment.</p> Signup and view all the answers

<p>A single-user database that runs on a personal computer.</p> Signup and view all the answers

<p>A logically related database that is stored over two or more physically independent sites.</p> Signup and view all the answers

<p>The overall company data representation, which provides support for present and expected future needs.</p> Signup and view all the answers

<p>A metalanguage used to represent and manipulate data elements.</p> Signup and view all the answers

<p>A character or group of characters that defines a characteristic of a person, place, or thing.</p> Signup and view all the answers

<p>A named collection of related records.</p> Signup and view all the answers

<p>The result of processing raw data to reveal its meaning.</p> Signup and view all the answers

<p>Independent, often duplicated, and inconsistent data pools created and managed by different organizational departments.</p> Signup and view all the answers

<p>The body of information and facts about a specific subject.</p> Signup and view all the answers

<p>The way in which a human being views data.</p> Signup and view all the answers

<p>Data about data, concerning data characteristics and relationships.</p> Signup and view all the answers

<p>A database that supports multiple concurrent users.</p> Signup and view all the answers

<p>A database that is designed primarily to support a company's day-to-day operations.</p> Signup and view all the answers

<p>Activities that make a database perform more efficiently in terms of storage and access speed.</p> Signup and view all the answers

<p>The way in which a computer stores data.</p> Signup and view all the answers

<p>The main database designed to keep track of the day-to-day operations of a company.</p> Signup and view all the answers

<p>A question or task asked by an end user of a database in the form of SQL code.</p> Signup and view all the answers

<p>A nonprocedural language that is used by a DBMS to manipulate its data.</p> Signup and view all the answers

<p>The collection of data rows that are returned by a query.</p> Signup and view all the answers

<p>A collection of related fields.</p> Signup and view all the answers

<p>Data that have already been processed to some extent.</p> Signup and view all the answers

<p>A database that supports only one user at a time.</p> Signup and view all the answers

<p>A data characteristic that exists when a change in the database schema affects data access.</p> Signup and view all the answers

<p>A data characteristic that exists when changes in the database schema do not affect data access.</p> Signup and view all the answers

<p>Unstructured data that have been formatted to facilitate storage, use, and information generation.</p> Signup and view all the answers

<p>A powerful and flexible relational database language composed of commands.</p> Signup and view all the answers

<p>A database designed to keep track of the day-to-day transactions of an organization.</p> Signup and view all the answers

<p>Data that exist in their original state.</p> Signup and view all the answers

<p>A multiuser database that supports a relatively small number of users.</p> Signup and view all the answers

<p>A database system that stores and manages semistructured XML data.</p> Signup and view all the answers