Exam 15: Introduction to Database Concepts

A logical table can be created with information from no more than two physical tables .

An attribute or a set of attributes that could potentially be chosen as the table's key is a

Select all that apply . Which is(are) TRUE about a row in a table?

A database table may not contain multiple identical rows . Each row must be unique .

In relational databases, an attribute can be thought of as a column of a table, where the attribute names are the column headings and attribute values are the entries .

The ________ operation is used to remove rows from one table that are also listed in a second table .

The database ________ is a collection of table definitions that gives the name of the table, lists the attributes and their data types, and identifies the primary key .

XML is intuitive because it is a self-describing language .

What operation takes rows from one table to create a new table?

The logical database shows the user the view of the information he or she needs and wants .

Every relational database can be described by XML and, similarly, anything described by XML is a relational database .

A technique called Query By Example (QBE) is available in the Microsoft ________ system, whereby the user fills in a template and the software generates the SQL code .

What operation combines two tables based on matching fields?

Relationships connect rows of one table with rows of another table .

Assume that you use the Product operation on table A (5 attributes) x table B (3 attributes) . The resulting supertable will have

The rules for producing XML encodings of information produce hierarchical descriptions that can be thought of as trees .

Relationships in a database schema show how

The ________ operation builds a new table from the columns of an existing table .

The ________ defines the form of the information that can be stored in a field .

The Select operation on tables is often combined with the ________ operation to trim tables .