Question 1

What is the difference between an AND criterion and an OR criterion?

Accepted Answer

In an AND criterion, both crit

Question 2

Based on the tables below, which command creates a new table named CustSales that combines the Customer and SalesPerson tables based on SalesPersonNum??Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, SalesPersonNum)?SalesPerson (SalesPersonNum, LastName, FirstName)

Accepted Answer

A)  PROJECT Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum MAKING CustSales 
B)  UNION Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum MAKING CustSales 
C)  SELECT Customer SalesPerson JOIN Customer.SalesPersonNum=SalesPerson.SalesPersonNum GIVING CustSales 
D)  JOIN Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum GIVING CustSales 
A)  PROJECT Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum MAKING CustSales 
B)  UNION Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum MAKING CustSales 
C)  SELECT Customer SalesPerson JOIN Customer.SalesPersonNum=SalesPerson.SalesPersonNum GIVING CustSales 
D)  JOIN Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum GIVING CustSales

Question 3

In the Access Query window, the upper portion of the window contains the design grid.

Accepted Answer

A) True 
 B)False

Question 4

In relational algebra, what command causes only certain columns to be included in the new table?

Accepted Answer

A)  SELECT 
B)  DELETE 
C)  PROGRAM 
D)  PROJECT 
A)  SELECT 
B)  DELETE 
C)  PROGRAM 
D)  PROJECT

Question 5

Which term is another word for a row in a table?

Accepted Answer

A)  tuple 
B)  field 
C)  group 
D)  relation 
A)  tuple 
B)  field 
C)  group 
D)  relation

Question 6

Which of the following is the column or collection of columns that uniquely identifies a given row in that table?

Accepted Answer

A)  primary key 
B)  secondary key 
C)  foreign key 
D)  minor key 
A)  primary key 
B)  secondary key 
C)  foreign key 
D)  minor key

Question 7

The compound criteria (conditions) are created by using which of the following two keywords?

Accepted Answer

A)  AND, OR 
B)  AND, NOR 
C)  OR, NOT 
D)  NOT, ONLY 
A)  AND, OR 
B)  AND, NOR 
C)  OR, NOT 
D)  NOT, ONLY

Question 8

The relational operators are +, *, %, and /.

Accepted Answer

A) True 
 B)False

Question 9

How do you refer to a column named State in a table named Client?

Accepted Answer

A)  State.Client 
B)  State(Client) 
C)  Client.State 
D)  Client(State) 
A)  State.Client 
B)  State(Client) 
C)  Client.State 
D)  Client(State)

Question 10

Which operation will allow you to extract data from more than one table?

Accepted Answer

A)  Select 
B)  Merge 
C)  Project 
D)  Join 
A)  Select 
B)  Merge 
C)  Project 
D)  Join

Question 11

When some of the entries in a structure contain repeating groups and thus are not single-valued, the structure is called a(n) ____________________.

Accepted Answer

unnormaliz

Question 12

List the six properties that define a relation in a two-dimensional table.

Accepted Answer

A relation is a two-dimensional table in

Question 13

A column whose value uniquely identifies a given row in the table is the secondary key.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is true if two tables have the same number of columns and their corresponding columns represent the same type of data?

Accepted Answer

A)  They are union compatible. 
B)  They are intersection compatible. 
C)  They are difference compatible. 
D)  They are product compatible. 
A)  They are union compatible. 
B)  They are intersection compatible. 
C)  They are difference compatible. 
D)  They are product compatible.

Question 15

The attributes of an entity become the fields or columns in a table.

Accepted Answer

A) True 
 B)False

Question 16

The field on which records are sorted is called the composite primary key.

Accepted Answer

A) True 
 B)False

Question 17

What type of query changes data?

Accepted Answer

A)  addition 
B)  update 
C)  update. 
D)  select 
A)  addition 
B)  update 
C)  update. 
D)  select

Question 18

The primary key of a table is the row or rows that uniquely identify a given column in that table.

Accepted Answer

A) True 
 B)False

Question 19

The concept of grouping means that statistics will be calculated for individual records.

Accepted Answer

A) True 
 B)False

Question 20

A query is a question represented in a way that the DBMS can recognize and process.

Accepted Answer

A) True 
 B)False

What is the difference between an AND criterion and an OR criterion?

Based on the tables below, which command creates a new table named CustSales that combines the Customer and SalesPerson tables based on SalesPersonNum??Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, SalesPersonNum)?SalesPerson (SalesPersonNum, LastName, FirstName)

In the Access Query window, the upper portion of the window contains the design grid.

In relational algebra, what command causes only certain columns to be included in the new table?

Which term is another word for a row in a table?

Which of the following is the column or collection of columns that uniquely identifies a given row in that table?

The compound criteria (conditions) are created by using which of the following two keywords?

The relational operators are +, *, %, and /.

How do you refer to a column named State in a table named Client?

Which operation will allow you to extract data from more than one table?

When some of the entries in a structure contain repeating groups and thus are not single-valued, the structure is called a(n) ____________________.

List the six properties that define a relation in a two-dimensional table.

A column whose value uniquely identifies a given row in the table is the secondary key.

Which of the following is true if two tables have the same number of columns and their corresponding columns represent the same type of data?

The attributes of an entity become the fields or columns in a table.

The field on which records are sorted is called the composite primary key.

What type of query changes data?

The primary key of a table is the row or rows that uniquely identify a given column in that table.

The concept of grouping means that statistics will be calculated for individual records.

A query is a question represented in a way that the DBMS can recognize and process.

Introduction to Database Management

The Relational Model 2: SQL

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters

Exam 2: The Relational Model 1: Introduction, QBE, and Relational Algebra

What is the difference between an AND criterion and an OR criterion?

Based on the tables below, which command creates a new table named CustSales that combines the Customer and SalesPerson tables based on SalesPersonNum??Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, SalesPersonNum)?SalesPerson (SalesPersonNum, LastName, FirstName)

In the Access Query window, the upper portion of the window contains the design grid.

In relational algebra, what command causes only certain columns to be included in the new table?

Which term is another word for a row in a table?

Which of the following is the column or collection of columns that uniquely identifies a given row in that table?

The compound criteria (conditions) are created by using which of the following two keywords?

The relational operators are +, *, %, and /.

How do you refer to a column named State in a table named Client?

Which operation will allow you to extract data from more than one table?

When some of the entries in a structure contain repeating groups and thus are not single-valued, the structure is called a(n) ____________________.

List the six properties that define a relation in a two-dimensional table.

A column whose value uniquely identifies a given row in the table is the secondary key.

Which of the following is true if two tables have the same number of columns and their corresponding columns represent the same type of data?

The attributes of an entity become the fields or columns in a table.

The field on which records are sorted is called the composite primary key.

What type of query changes data?

The primary key of a table is the row or rows that uniquely identify a given column in that table.

The concept of grouping means that statistics will be calculated for individual records.

A query is a question represented in a way that the DBMS can recognize and process.

Introduction to Database Management

The Relational Model 2: SQL

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters