Question 1

When both criteria must be true for the compound criterion to be true, the _______________ operator is being used.

Accepted Answer

AND

Question 2

Based on the table below, which command creates a new table named CustState containing the fields CustomerNum and State??Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)

Accepted Answer

A)  JOIN Customer WITH (CustomerNum, State) GIVING CustState 
B)  PROJECT Customer OVER (CustomerNum, State) GIVING CustState 
C)  SELECT Customer OVER (CustomerNum, State) GIVING CustState 
D)  MAKE-TABLE CustState FROM Customer WITH (CustomerNum, State) 
A)  JOIN Customer WITH (CustomerNum, State) GIVING CustState 
B)  PROJECT Customer OVER (CustomerNum, State) GIVING CustState 
C)  SELECT Customer OVER (CustomerNum, State) GIVING CustState 
D)  MAKE-TABLE CustState FROM Customer WITH (CustomerNum, State) B

Question 3

Explain what relational algebra is and how it is used.

Accepted Answer

Relational algebra is a theoretical way of manipulating a relational database. Relational algebra includes operations that act on existing tables to produce new tables, similar to the way the operations of addition and subtraction act on numbers to produce new numbers in the mathematical algebra with which you are familiar. Retrieving data from a relational database through the use of relational algebra involves issuing relational algebra commands to operate on existing tables to form a new table containing the desired information. Sometimes you might need to execute a series of commands to obtain the desired result.

Question 4

A ______________ primary key is composed of more than one column so that the row is unique.

Accepted Answer

The answer of A ______________ primary key is composed of...

Question 5

To select data from more than one table at the same time, you need to perform a make-table query.

Accepted Answer

A) True 
 B)False

Question 6

What type of functions are Count, Sum, Avg, Max, and Min?

Accepted Answer

A)  accumulation 
B)  allowed 
C)  primary 
D)  aggregate 
A)  accumulation 
B)  allowed 
C)  primary 
D)  aggregate

Question 7

Which command contains all rows that are common in two tables?

Accepted Answer

A)  UNION 
B)  SUBTRACT 
C)  JOIN 
D)  INTERSECT 
A)  UNION 
B)  SUBTRACT 
C)  JOIN 
D)  INTERSECT

Question 8

Which command creates a table containing all rows that are in either or both of two tables?

Accepted Answer

A)  UNION 
B)  SUBTRACT 
C)  JOIN 
D)  INTERSECT 
A)  UNION 
B)  SUBTRACT 
C)  JOIN 
D)  INTERSECT

Question 9

Which operator is used to concatenate every row in the first table with every row in the second table?

Accepted Answer

A)  union 
B)  difference 
C)  product 
D)  intersection 
A)  union 
B)  difference 
C)  product 
D)  intersection

Question 10

Which of the following is NOT true about a relation in a two-dimensional table?

Accepted Answer

A)  The entries in the table are single-valued. 
B)  All values in a column are values of the same attribute. 
C)  Two or more columns can share the same name. 
D)  The order of rows is immaterial. 
A)  The entries in the table are single-valued. 
B)  All values in a column are values of the same attribute. 
C)  Two or more columns can share the same name. 
D)  The order of rows is immaterial.

Question 11

Multiple entries in tables are often called ____________________.

Accepted Answer

The answer of Multiple entries in tables are often called...

Question 12

A query ___________________ is a DBMS component that analyzes queries and attempts to determine the most efficient way to execute a given query.

Accepted Answer

The answer of A query ___________________ is a DBMS component...

Question 13

A(n) ______________ query makes a specified change to all records satisfying the criteria in the query.

Accepted Answer

The answer of A(n) ______________ query makes a specified change...

Question 14

A relational database handles entities, attributes, and relationships by storing each entity in its own row.

Accepted Answer

A) True 
 B)False

Question 15

A relational database is a collection of tables.

Accepted Answer

A) True 
 B)False

Question 16

Based on the table below, which command lists all information from the table concerning the customer with CustomerNum 260? Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)

Accepted Answer

A)  SELECT Customer 260 RESULTS Answer 
B)  SELECT Customer WHERE CustomerNum=260 GIVING Answer 
C)  SELECT Customer GIVING Answer WHERE CustomerNum='260' 
D)  SELECT Customer WHERE CustomerNum='260' RESULTS Answer 
A)  SELECT Customer 260 RESULTS Answer 
B)  SELECT Customer WHERE CustomerNum=260 GIVING Answer 
C)  SELECT Customer GIVING Answer WHERE CustomerNum='260' 
D)  SELECT Customer WHERE CustomerNum='260' RESULTS Answer

Question 17

In a relation, the order of rows is important.

Accepted Answer

A) True 
 B)False

Question 18

In an AND criterion, the overall criterion is true if either of the individual criteria is true.

Accepted Answer

A) True 
 B)False

Question 19

In relational database shorthand, the structure of a relational database is written with the name of the table followed by the columns in the table listed within parentheses.

Accepted Answer

A) True 
 B)False

Question 20

List at least six of the aggregate functions available in Access.

Accepted Answer

All products that support QBE, including

When both criteria must be true for the compound criterion to be true, the _______________ operator is being used.

Based on the table below, which command creates a new table named CustState containing the fields CustomerNum and State??Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)

Explain what relational algebra is and how it is used.

A ______________ primary key is composed of more than one column so that the row is unique.

To select data from more than one table at the same time, you need to perform a make-table query.

What type of functions are Count, Sum, Avg, Max, and Min?

Which command contains all rows that are common in two tables?

Which command creates a table containing all rows that are in either or both of two tables?

Which operator is used to concatenate every row in the first table with every row in the second table?

Which of the following is NOT true about a relation in a two-dimensional table?

Multiple entries in tables are often called ____________________.

A query ___________________ is a DBMS component that analyzes queries and attempts to determine the most efficient way to execute a given query.

A(n) ______________ query makes a specified change to all records satisfying the criteria in the query.

A relational database handles entities, attributes, and relationships by storing each entity in its own row.

A relational database is a collection of tables.

Based on the table below, which command lists all information from the table concerning the customer with CustomerNum 260? Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)

In a relation, the order of rows is important.

In an AND criterion, the overall criterion is true if either of the individual criteria is true.

In relational database shorthand, the structure of a relational database is written with the name of the table followed by the columns in the table listed within parentheses.

List at least six of the aggregate functions available in Access.

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

When both criteria must be true for the compound criterion to be true, the _______________ operator is being used.

Based on the table below, which command creates a new table named CustState containing the fields CustomerNum and State??Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)

Explain what relational algebra is and how it is used.

A ______________ primary key is composed of more than one column so that the row is unique.

To select data from more than one table at the same time, you need to perform a make-table query.

What type of functions are Count, Sum, Avg, Max, and Min?

Which command contains all rows that are common in two tables?

Which command creates a table containing all rows that are in either or both of two tables?

Which operator is used to concatenate every row in the first table with every row in the second table?

Which of the following is NOT true about a relation in a two-dimensional table?

Multiple entries in tables are often called ____________________.

A query ___________________ is a DBMS component that analyzes queries and attempts to determine the most efficient way to execute a given query.

A(n) ______________ query makes a specified change to all records satisfying the criteria in the query.

A relational database handles entities, attributes, and relationships by storing each entity in its own row.

A relational database is a collection of tables.

Based on the table below, which command lists all information from the table concerning the customer with CustomerNum 260? Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)

In a relation, the order of rows is important.

In an AND criterion, the overall criterion is true if either of the individual criteria is true.

In relational database shorthand, the structure of a relational database is written with the name of the table followed by the columns in the table listed within parentheses.

List at least six of the aggregate functions available in Access.

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