Exam 7: Database Systems

Open-source database management systems offer the same advantages as all open-source software: there is strong community support, they are completely customizable, and they are free.

Databases and spreadsheet software can read a .csv file, using the line breaks and commas to interpret the data as a table.

Fields are combined to make a ____.

Primary data is difficult to manage because any required change must be applied to all copies of the data, but a copy is often overlooked and becomes inaccurate. _________________________

Databases are best designed using small, logically interconnected tables to reduce data redundancy.

Two common data manipulations are selecting data and separating tables. _________________________

The high cost of cooling data centers has become a growing concern to environmentalists and business owners.

Identify the letter of the choice that best matches the phrase or definition. -A collection of related fields that describe some object or activity

Data consists of raw facts, like sales or weather statistics.

Sam is a database administrator for a hockey supply store. He is reviewing old data files and recording some basic information in a spreadsheet, including the type of database. -The last database that Sam opens is clearly labeled "Inventory saved in MySQL." Sam knows that MySQL is used when writing ____ database systems.

Identify the letter of the choice that best matches the phrase or definition. -A process that involves evaluating data to identify problems with the content of a database

Sara Lewis is a teacher at Lakeside Junior College. When she came to class late, for the second time in a row, her students suggest she get a PIM. Sara is not sure "what a PIM is" and is doing some research. -Sara discovers that a PIM is a personal information manager that can help you keep track of ____.

Multiple fields can never be combined as a primary key.

____________________ DBMSs make use of a unique manner of reading and writing data to allow users simultaneous access to a shared database.

One study found that the open-source DMBS MySQL is deployed ____ percent more frequently that Oracle, SQL Server, or DB2.

In the relational model, all data elements are placed in three-dimensional tables.

Databases for personal computers are most often designed for a single user.

The 1 and infinity symbols used on the relationship lines of a database indicate a special kind of relationship called a ____ relationship.

In building a database, careful consideration must be given to all of these questions EXCEPT: ____.

Providing a plan for how to bring systems back online after an emergency is known as ____.