Question 1

A is the primary key of one table that has been placed into another table to create a common attribute.

Accepted Answer

A) superkey 
B) composite primary key 
C) candidate key 
D) foreign key 
A) superkey 
B) composite primary key 
C) candidate key 
D) foreign key

Question 2

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

Accepted Answer

A) primary rule 
B) superkey 
C) relationship 
D) index 
A) primary rule 
B) superkey 
C) relationship 
D) index

Question 3

__ 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 4

The relationship is the relational database norm.

Accepted Answer

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

Question 5

The DIFFERENCE operator subtracts one table from the other.

Accepted Answer

A) True 
 B)False

Question 6

In a relational model,are also used to establish relationships among tables and to ensure the integrity of the data.

Accepted Answer

The answer of In a relational model,are also used to...

Question 7

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

Accepted Answer

A) database tuple 
B) systematic database 
C) unique index 
D) system catalog 
A) database tuple 
B) systematic database 
C) unique index 
D) system catalog

Question 8

As rare as 1:1 relationships should be,certain conditions absolutely require their use.

Accepted Answer

A) True 
 B)False

Question 9

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 10

The CUSTOMER table's primary key is CUS_CODE.The CUSTOMER primary key column has no null entries,and all entries are unique.This is an example of integrity.

Accepted Answer

A) entity 
B) referential 
C) relational 
D) null 
A) entity 
B) referential 
C) relational 
D) null

Question 11

__ 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 12

The DIVIDE operation uses one single­column table (e.g.,column "a")as the divisor and one two­column table (e.g.,columns "a" and "b")as the dividend.

Accepted Answer

A) True 
 B)False

Question 13

_____ relationships can be implemented by creating a new entity in 1:M relationships with the original entities.

Accepted Answer

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

Question 14

A key is defined as a key that is used strictly for data retrieval purposes.

Accepted Answer

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

Question 15

A table is also called a(n)because the relational model's creator,E.F.Codd,used the two terms as synonyms.

Accepted Answer

The answer of A table is also called a(n)because the...

Question 16

__ ,also known as RESTRICT,yields values for all rows found in a table that satisfy a given condition.

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

The one­to­many (1: M)relationship is easily implemented in the relational model by putting the foreign key of the "1" side in the table of the "many" side as a primary key.

Accepted Answer

A) True 
 B)False

Question 19

Relational algebra defines the theoretical way of manipulating table contents using relational operators.

Accepted Answer

A) True 
 B)False

Question 20

RDBMSs enforce integrity rules automatically.

Accepted Answer

A) True 
 B)False

A is the primary key of one table that has been placed into another table to create a common attribute.

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

__ 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.

The DIFFERENCE operator subtracts one table from the other.

In a relational model,are also used to establish relationships among tables and to ensure the integrity of the data.

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

As rare as 1:1 relationships should be,certain conditions absolutely require their use.

The relationship is the "relational model ideal."

The CUSTOMER table's primary key is CUS_CODE.The CUSTOMER primary key column has no null entries,and all entries are unique.This is an example of integrity.

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

The DIVIDE operation uses one singlecolumn table (e.g.,column "a")as the divisor and one twocolumn table (e.g.,columns "a" and "b")as the dividend.

_____ relationships can be implemented by creating a new entity in 1:M relationships with the original entities.

A key is defined as a key that is used strictly for data retrieval purposes.

A table is also called a(n)because the relational model's creator,E.F.Codd,used the two terms as synonyms.

__ ,also known as RESTRICT,yields values for all rows found in a table that satisfy a given condition.

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

The onetomany (1: M)relationship is easily implemented in the relational model by putting the foreign key of the "1" side in the table of the "many" side as a primary key.

Relational algebra defines the theoretical way of manipulating table contents using relational operators.

RDBMSs enforce integrity rules automatically.

Database Systems

Data Models

Entity Relationship Ermodeling

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 Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 3: The Relational Database Model

A is the primary key of one table that has been placed into another table to create a common attribute.

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

__ 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.

The DIFFERENCE operator subtracts one table from the other.

In a relational model,are also used to establish relationships among tables and to ensure the integrity of the data.

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

As rare as 1:1 relationships should be,certain conditions absolutely require their use.

The relationship is the "relational model ideal."

The CUSTOMER table's primary key is CUS_CODE.The CUSTOMER primary key column has no null entries,and all entries are unique.This is an example of integrity.

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

The DIVIDE operation uses one single­column table (e.g.,column "a")as the divisor and one two­column table (e.g.,columns "a" and "b")as the dividend.

_____ relationships can be implemented by creating a new entity in 1:M relationships with the original entities.

A key is defined as a key that is used strictly for data retrieval purposes.

A table is also called a(n)because the relational model's creator,E.F.Codd,used the two terms as synonyms.

__ ,also known as RESTRICT,yields values for all rows found in a table that satisfy a given condition.

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

The one­to­many (1: M)relationship is easily implemented in the relational model by putting the foreign key of the "1" side in the table of the "many" side as a primary key.

Relational algebra defines the theoretical way of manipulating table contents using relational operators.

RDBMSs enforce integrity rules automatically.

Database Systems

Data Models

Entity Relationship Ermodeling

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 Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters

The DIVIDE operation uses one singlecolumn table (e.g.,column "a")as the divisor and one twocolumn table (e.g.,columns "a" and "b")as the dividend.

The onetomany (1: M)relationship is easily implemented in the relational model by putting the foreign key of the "1" side in the table of the "many" side as a primary key.