Question 1

A ____ contains at least all of the attribute names and characteristics for each table in the system.

Accepted Answer

A)  data dictionary 
B)  relational schema 
C)  logical schema 
D)  join

Question 2

Codd's rule of ____ states:
Application programs and ad hoc facilities are logically unaffected when changes are made to the table structures that preserve the original table values (changing order of columns or inserting columns).

Accepted Answer

A)  Nonsubversion 
B)  Logical Data Independence 
C)  Comprehensive Data Sublanguage 
D)  Integrity Independence

Question 3

What is the system catalog?

Accepted Answer

The answer of What is the system catalog?...

Question 4

Controlled ____ makes a relational database work.

Accepted Answer

A)  relations 
B)  logic 
C)  chaos 
D)  redundancy

Question 5

____ logic,used extensively in mathematics,provides a framework in which an assertion (statement of fact)can be verified as either true or false.

Accepted Answer

A)  Predicate 
B)  Database 
C)  Relational 
D)  Index

Question 6

Codd's rule of ____________________ states that every value in a table is guaranteed to be accessible through a combination of table name,primary key value,and column name.

Accepted Answer

The answer of Codd's rule of ____________________ states that every...

Question 7

A data dictionary contains metadata-data about data.

Accepted Answer

A) True 
 B)False

Question 8

A data dictionary is sometimes described as "the database designer's database" because it records the design decisions about tables and their structures.

Accepted Answer

A) True 
 B)False

Question 9

Tables must have the same attribute characteristics (the columns and domains must be compatible)to be used in a UNION.

Accepted Answer

A) True 
 B)False

Question 10

Tables within a database share common attributes that enable the tables to be linked together.

Accepted Answer

A) True 
 B)False

Question 11

A ____ is any key that uniquely identifies each row.

Accepted Answer

A)  superkey 
B)  special 
C)  selective 
D)  candidate

Question 12

In a natural join,the column on which the join was made occurs twice in the new table.

Accepted Answer

A) True 
 B)False

Question 13

PRODUCT yields all possible pairs of rows from two tables-also known as the ____________________ product.

Accepted Answer

The answer of PRODUCT yields all possible pairs of rows...

Question 14

The ____________________ relationship is the relational database norm.

Accepted Answer

The answer of The ____________________ relationship is the relational database...

Question 15

In the relational model,____________________ are important because they are used to ensure that each row in a table is uniquely identifiable.

Accepted Answer

The answer of In the relational model,____________________ are important because...

Question 16

A foreign key must exist in both tables that have a relationship.

Accepted Answer

A) True 
 B)False

Question 17

When you define a table's primary key,the DBMS automatically creates a(n)____ index on the primary key column(s)you declared.

Accepted Answer

A)  key 
B)  incomplete 
C)  unique 
D)  primary

Question 18

In the context of a database table,the statement "A ____ B" indicates that if you know the value of attribute A,you can look up the value of attribute B.

Accepted Answer

A)  contains 
B)  is related to 
C)  owns 
D)  determines

Question 19

In the relational model,____ are important because they are used to ensure that each row in a table is uniquely identifiable

Accepted Answer

A)  relations 
B)  keys 
C)  indexes 
D)  logical structures

Question 20

The ____ is actually a system-created database whose tables store the user/designer-created database characteristics and contents.

Accepted Answer

A)  meta dictionary 
B)  schema 
C)  data dictionary 
D)  system catalog

Exam 3: The Relational Database Model

A ____ contains at least all of the attribute names and characteristics for each table in the system.

Codd's rule of ____ states: Application programs and ad hoc facilities are logically unaffected when changes are made to the table structures that preserve the original table values (changing order of columns or inserting columns) .

What is the system catalog?

Controlled ____ makes a relational database work.

____ logic,used extensively in mathematics,provides a framework in which an assertion (statement of fact) can be verified as either true or false.

Codd's rule of ____________________ states that every value in a table is guaranteed to be accessible through a combination of table name,primary key value,and column name.

A data dictionary contains metadata-data about data.

A data dictionary is sometimes described as "the database designer's database" because it records the design decisions about tables and their structures.

Tables must have the same attribute characteristics (the columns and domains must be compatible)to be used in a UNION.

Tables within a database share common attributes that enable the tables to be linked together.

A ____ is any key that uniquely identifies each row.

In a natural join,the column on which the join was made occurs twice in the new table.

PRODUCT yields all possible pairs of rows from two tables-also known as the ____________________ product.

The ____________________ relationship is the relational database norm.

In the relational model,____________________ are important because they are used to ensure that each row in a table is uniquely identifiable.

A foreign key must exist in both tables that have a relationship.

When you define a table's primary key,the DBMS automatically creates a(n) ____ index on the primary key column(s) you declared.

In the context of a database table,the statement "A ____ B" indicates that if you know the value of attribute A,you can look up the value of attribute B.

In the relational model,____ are important because they are used to ensure that each row in a table is uniquely identifiable

The ____ is actually a system-created database whose tables store the user/designer-created database characteristics and contents.