Question 1

The relational model's creator,E.F.Codd,used the term relation as a synonym for ____.

Accepted Answer

A)  index 
B)  key 
C)  table 
D)  relationship 
A)  index 
B)  key 
C)  table 
D)  relationship C

Question 2

Describe the use of the UNION operator.

Accepted Answer

UNION combines all rows from two tables,excluding duplicate rows.The tables must have the same attribute characteristics (the columns and domains must be compatible)to be used in the UNION.When two or more tables share the same number of columns,when their corresponding columns share the same (or compatible)domains,they are said to be union-compatible.

Question 3

A(n)____________________ is an orderly arrangement used to logically access rows in a table.

Accepted Answer

index

Question 4

____ yields a vertical subset of a table.

Accepted Answer

A)  PROJECT 
B)  SELECT 
C)  UNION 
D)  DIFFERENCE 
A)  PROJECT 
B)  SELECT 
C)  UNION 
D)  DIFFERENCE

Question 5

Date attributes contain calendar dates stored in a special format known as the ____ date format.

Accepted Answer

A)  Epoch 
B)  Calendar 
C)  Julian 
D)  logical 
A)  Epoch 
B)  Calendar 
C)  Julian 
D)  logical

Question 6

Since it is used to link the tables that originally were related in a M:N relationship,the composite entity structure includes-as foreign keys-at least the ____ keys of the tables that are to be linked.

Accepted Answer

A)  composite 
B)  super 
C)  primary 
D)  unique 
A)  composite 
B)  super 
C)  primary 
D)  unique

Question 7

In an outer join,the matched pairs would be retained and any unmatched values in the other table would be left ____.

Accepted Answer

A)  in another table 
B)  null 
C)  out of the results 
D)  with matching values from the original table 
A)  in another table 
B)  null 
C)  out of the results 
D)  with matching values from the original table

Question 8

Numeric data are data on which you can perform meaningful arithmetic procedures.

Accepted Answer

A) True 
 B)False

Question 9

The SELECT operator yields a vertical subset of a table.

Accepted Answer

A) True 
 B)False

Question 10

____________________ is the real power behind the relational database,allowing the use of independent tables linked by common attributes.

Accepted Answer

The answer of ____________________ is the real power behind the...

Question 11

A(n)____ join links tables by selecting only the rows with common values in their common attribute(s).

Accepted Answer

A)  equal 
B)  unique 
C)  foreign 
D)  natural 
A)  equal 
B)  unique 
C)  foreign 
D)  natural

Question 12

A(n)____ is perceived as a two-dimensional structure composed of rows and columns.

Accepted Answer

A)  table 
B)  rowset 
C)  attribute 
D)  intersection 
A)  table 
B)  rowset 
C)  attribute 
D)  intersection

Question 13

The relational operators have the property of ____________________; that is,the use of relational algebra operators on existing relations (tables)produces new relations.

Accepted Answer

The answer of The relational operators have the property of...

Question 14

In a relational table,each column has a specific range of values known as the ____________________ domain.

Accepted Answer

The answer of In a relational table,each column has a...

Question 15

Depending on the sophistication of the application development software,nulls can create problems when functions such as COUNT,AVERAGE,and SUM are used.

Accepted Answer

A) True 
 B)False

Question 16

Proper data ____________________ design requires carefully defined and controlled data redundancies to function properly.

Accepted Answer

The answer of Proper data ____________________ design requires carefully defined...

Question 17

A ____ is a textual representation of the database tables where each table is listed by its name followed by the list of its attributes in parentheses.

Accepted Answer

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

Question 18

Current relational database software generally provides only a system catalog (and not a data dictionary).

Accepted Answer

A) True 
 B)False

Question 19

There is never a good reason to use null values in a database.

Accepted Answer

A) True 
 B)False

Question 20

____ data can have only a true or false (yes or no)values.

Accepted Answer

A)  Logical 
B)  Character 
C)  Date 
D)  Numeric 
A)  Logical 
B)  Character 
C)  Date 
D)  Numeric

The relational model's creator,E.F.Codd,used the term relation as a synonym for ____.

Describe the use of the UNION operator.

A(n)____________________ is an orderly arrangement used to logically access rows in a table.

____ yields a vertical subset of a table.

Date attributes contain calendar dates stored in a special format known as the ____ date format.

Since it is used to link the tables that originally were related in a M:N relationship,the composite entity structure includes-as foreign keys-at least the ____ keys of the tables that are to be linked.

In an outer join,the matched pairs would be retained and any unmatched values in the other table would be left ____.

Numeric data are data on which you can perform meaningful arithmetic procedures.

The SELECT operator yields a vertical subset of a table.

____________________ is the real power behind the relational database,allowing the use of independent tables linked by common attributes.

A(n)____ join links tables by selecting only the rows with common values in their common attribute(s).

A(n)____ is perceived as a two-dimensional structure composed of rows and columns.

The relational operators have the property of ____________________; that is,the use of relational algebra operators on existing relations (tables)produces new relations.

In a relational table,each column has a specific range of values known as the ____________________ domain.

Depending on the sophistication of the application development software,nulls can create problems when functions such as COUNT,AVERAGE,and SUM are used.

Proper data ____________________ design requires carefully defined and controlled data redundancies to function properly.

A ____ is a textual representation of the database tables where each table is listed by its name followed by the list of its attributes in parentheses.

Current relational database software generally provides only a system catalog (and not a data dictionary).

There is never a good reason to use null values in a database.

____ data can have only a true or false (yes or no)values.

Database Systems

Data Models

Entity Relationship (ER)Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 3: The Relational Database Model

The relational model's creator,E.F.Codd,used the term relation as a synonym for ____.

Describe the use of the UNION operator.

A(n)____________________ is an orderly arrangement used to logically access rows in a table.

____ yields a vertical subset of a table.

Date attributes contain calendar dates stored in a special format known as the ____ date format.

Since it is used to link the tables that originally were related in a M:N relationship,the composite entity structure includes-as foreign keys-at least the ____ keys of the tables that are to be linked.

In an outer join,the matched pairs would be retained and any unmatched values in the other table would be left ____.

Numeric data are data on which you can perform meaningful arithmetic procedures.

The SELECT operator yields a vertical subset of a table.

____________________ is the real power behind the relational database,allowing the use of independent tables linked by common attributes.

A(n)____ join links tables by selecting only the rows with common values in their common attribute(s).

A(n)____ is perceived as a two-dimensional structure composed of rows and columns.

The relational operators have the property of ____________________; that is,the use of relational algebra operators on existing relations (tables)produces new relations.

In a relational table,each column has a specific range of values known as the ____________________ domain.

Depending on the sophistication of the application development software,nulls can create problems when functions such as COUNT,AVERAGE,and SUM are used.

Proper data ____________________ design requires carefully defined and controlled data redundancies to function properly.

A ____ is a textual representation of the database tables where each table is listed by its name followed by the list of its attributes in parentheses.

Current relational database software generally provides only a system catalog (and not a data dictionary).

There is never a good reason to use null values in a database.

____ data can have only a true or false (yes or no)values.

Database Systems

Data Models

Entity Relationship (ER)Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters