Question 1

_____ returns only the attributes requested, in the order in which they are requested.

Accepted Answer

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

Question 2

A(n) ______ provides a detailed description of all tables found within the user/designer-created database.

Accepted Answer

data dictionary

Question 3

A _____ is any key that uniquely identifies each row.

Accepted Answer

A)  superkey 
B)  special key 
C)  foreign key 
D)  candidate key 
A)  superkey 
B)  special key 
C)  foreign key 
D)  candidate key A

Question 4

The idea of determination is unique to the database environment.

Accepted Answer

A) True 
 B)False

Question 5

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)  database 
A)  data dictionary 
B)  relational schema 
C)  logical schema 
D)  database

Question 6

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 7

According to Codd's _____ rule of relational databases, 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)  distribution independence 
B)  logical data independence 
C)  comprehensive data sublanguage 
D)  integrity independence 
A)  distribution independence 
B)  logical data independence 
C)  comprehensive data sublanguage 
D)  integrity independence

Question 8

_____ are especially useful when you are trying to determine what values in related tables cause referential integrity problems.

Accepted Answer

A)  Inner joins 
B)  Outer joins 
C)  Equijoins 
D)  Theta joins 
A)  Inner joins 
B)  Outer joins 
C)  Equijoins 
D)  Theta joins

Question 9

_____ 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 
A)  Predicate 
B)  Database 
C)  Relational 
D)  Index

Question 10

The _____ relationship is the relational database norm.

Accepted Answer

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

Question 11

A _____ key can be described as a minimal superkey, a superkey without any unnecessary attributes.

Accepted Answer

A)  secondary 
B)  candidate 
C)  primary 
D)  foreign 
A)  secondary 
B)  candidate 
C)  primary 
D)  foreign

Question 12

Each table _____ represents an attribute.

Accepted Answer

A)  column 
B)  row 
C)  dimension 
D)  value 
A)  column 
B)  row 
C)  dimension 
D)  value

Question 13

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 14

What is a key and how is it important in a relational model?

Accepted Answer

In a relational model, keys are importan

Question 15

The _____ relationship is the "relational model ideal."

Accepted Answer

A)  1:1 
B)  1:M 
C)  M:1 
D)  M:N 
A)  1:1 
B)  1:M 
C)  M:1 
D)  M:N

Question 16

A(n) _____ only returns matched records from the tables that are being joined.

Accepted Answer

A)  outer join 
B)  inner join 
C)  equijoin 
D)  theta join 
A)  outer join 
B)  inner join 
C)  equijoin 
D)  theta join

Question 17

Only a single attribute, not multiple attributes, can define functional dependence.

Accepted Answer

A) True 
 B)False

Question 18

If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that composite key, the attribute (B) is fully functionally dependent on (A).

Accepted Answer

A) True 
 B)False

Question 19

A primary key is a(n) _____ key chosen to be the primary means by which rows of a table are uniquely identified.

Accepted Answer

The answer of A primary key is a(n) _____ key...

Question 20

Describe the use of the INTERSECT operator.

Accepted Answer

INTERSECT yields only the rows that appe

_____ returns only the attributes requested, in the order in which they are requested.

A(n) ______ provides a detailed description of all tables found within the user/designer-created database.

A _____ is any key that uniquely identifies each row.

The idea of determination is unique to the database environment.

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

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

According to Codd's _____ rule of relational databases, 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).

_____ are especially useful when you are trying to determine what values in related tables cause referential integrity problems.

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

The _____ relationship is the relational database norm.

A _____ key can be described as a minimal superkey, a superkey without any unnecessary attributes.

Each table _____ represents an attribute.

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

What is a key and how is it important in a relational model?

The _____ relationship is the "relational model ideal."

A(n) _____ only returns matched records from the tables that are being joined.

Only a single attribute, not multiple attributes, can define functional dependence.

If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that composite key, the attribute (B) is fully functionally dependent on (A).

A primary key is a(n) _____ key chosen to be the primary means by which rows of a table are uniquely identified.

Describe the use of the INTERSECT operator.

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

Big Data and Nosql

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 3: The Relational Database Model

_____ returns only the attributes requested, in the order in which they are requested.

A(n) ______ provides a detailed description of all tables found within the user/designer-created database.

A _____ is any key that uniquely identifies each row.

The idea of determination is unique to the database environment.

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

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

According to Codd's _____ rule of relational databases, 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).

_____ are especially useful when you are trying to determine what values in related tables cause referential integrity problems.

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

The _____ relationship is the relational database norm.

A _____ key can be described as a minimal superkey, a superkey without any unnecessary attributes.

Each table _____ represents an attribute.

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

What is a key and how is it important in a relational model?

The _____ relationship is the "relational model ideal."

A(n) _____ only returns matched records from the tables that are being joined.

Only a single attribute, not multiple attributes, can define functional dependence.

If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that composite key, the attribute (B) is fully functionally dependent on (A).

A primary key is a(n) _____ key chosen to be the primary means by which rows of a table are uniquely identified.

Describe the use of the INTERSECT operator.

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

Big Data and Nosql

Database Connectivity and Web Technologies

Database Administration and Security

Filters