Question 1

SQL has built-in functions, which are also called ____________________ functions to calculate the number of entries, or the sum or average of all entries.

Accepted Answer

The answer of SQL has built-in functions, which are also...

Question 2

Which query will return the number of rows where the State field is 'AZ' from the table Customers and provide a total of the Payment field?

Accepted Answer

A)  SELECT COUNT(*) WHERE State='AZ' SUM(Payment) FROM Customers; 
B)  SELECT FROM Customers COUNT(Payment) SUM(*) WHERE State='AZ'; 
C)  SELECT FROM Customers SUM(Payment) WHERE State='AZ' COUNT(*); 
D)  SELECT COUNT(*), SUM(Payment) FROM Customers WHERE State='AZ'; 
A)  SELECT COUNT(*) WHERE State='AZ' SUM(Payment) FROM Customers; 
B)  SELECT FROM Customers COUNT(Payment) SUM(*) WHERE State='AZ'; 
C)  SELECT FROM Customers SUM(Payment) WHERE State='AZ' COUNT(*); 
D)  SELECT COUNT(*), SUM(Payment) FROM Customers WHERE State='AZ';

Question 3

By using the word ____________________ in a query after a computation, you can assign a name to the computed field.

Accepted Answer

The answer of By using the word ____________________ in a...

Question 4

Based on the code shown, which query deletes any row in the OrderLine table in which the item number is MT03???OrderLine (OrderNum, ItemNum, NumOrdered, QuotedPrice)?Item (ItemNum, Description, OnHand, Category, Storehouse, Price )

Accepted Answer

A)  DELETE FROM OrderLine WHERE ItemNum='MT03' ; 
B)  DELETE FROM OrderLine WHERE ItemNum=MT03 ; 
C)  REMOVE FROM OrderLine WHERE ItemNum='MT03' ; 
D)  REMOVE FROM OrderLine WHERE ItemNum=MT03 ; 
A)  DELETE FROM OrderLine WHERE ItemNum='MT03' ; 
B)  DELETE FROM OrderLine WHERE ItemNum=MT03 ; 
C)  REMOVE FROM OrderLine WHERE ItemNum='MT03' ; 
D)  REMOVE FROM OrderLine WHERE ItemNum=MT03 ;

Question 5

Based on the code shown, which query lists the number, name, and balance of all customers with balances greater than or equal to $2,000 and less than or equal to $5,000???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

Accepted Answer

A)  SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ; 
B)  SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance > 2000 ; 
C)  SELECT CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ; 
D)  SELECT CustomerNum, CustomerName FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ; 
A)  SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ; 
B)  SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance > 2000 ; 
C)  SELECT CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ; 
D)  SELECT CustomerNum, CustomerName FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;

Question 6

Based on the code shown, which query lists the descriptions of all items that are not in Storehouse 3???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )

Accepted Answer

A)  SELECT Description FROM Customer WHERE NOT Storehouse='3' ; 
B)  SELECT Description FROM Item WHERE Storehouse='4' ; 
C)  SELECT Description FROM Item WHERE Storehouse>'3' ; 
D)  SELECT Description FROM Item WHERE NOT Storehouse='3' ; 
A)  SELECT Description FROM Customer WHERE NOT Storehouse='3' ; 
B)  SELECT Description FROM Item WHERE Storehouse='4' ; 
C)  SELECT Description FROM Item WHERE Storehouse>'3' ; 
D)  SELECT Description FROM Item WHERE NOT Storehouse='3' ;

Question 7

Computed fields are existing fields in the database that you can perform computations with.

Accepted Answer

A) True 
 B)False

Question 8

How are compound conditions formed?

Accepted Answer

Compound conditions are formed by connec

Question 9

When used after the word SELECT, which symbol indicates that you want to include all fields in the query results in the order in which you described them to the DBMS when you created the table?

Accepted Answer

A)  * 
B)  & 
C)  # 
D)  $ 
A)  * 
B)  & 
C)  # 
D)  $

Question 10

Use the ___________________ clause to indicate grouping.

Accepted Answer

The answer of Use the ___________________ clause to indicate grouping....

Question 11

Fields will appear in alphabetical order in the query results of a SELECT clause.

Accepted Answer

A) True 
 B)False

Question 12

Preceding a condition by the NOT operator reverses the result of the original condition.

Accepted Answer

A) True 
 B)False

Question 13

CHAR data types can be used to store numbers that will not be used in calculations.

Accepted Answer

A) True 
 B)False

Question 14

Use the ____________________ data type for fields that contain letters and other special characters, and for fields that contain numbers that will not be used for arithmetic.

Accepted Answer

The answer of Use the ____________________ data type for fields...

Question 15

You use the WHERE clause on groups and the HAVING clause on rows.

Accepted Answer

A) True 
 B)False

SQL has built-in functions, which are also called ____________________ functions to calculate the number of entries, or the sum or average of all entries.

Which query will return the number of rows where the State field is 'AZ' from the table Customers and provide a total of the Payment field?

By using the word ____________________ in a query after a computation, you can assign a name to the computed field.

Based on the code shown, which query deletes any row in the OrderLine table in which the item number is MT03???OrderLine (OrderNum, ItemNum, NumOrdered, QuotedPrice)?Item (ItemNum, Description, OnHand, Category, Storehouse, Price )

Based on the code shown, which query lists the number, name, and balance of all customers with balances greater than or equal to $2,000 and less than or equal to $5,000???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

Based on the code shown, which query lists the descriptions of all items that are not in Storehouse 3???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )

Computed fields are existing fields in the database that you can perform computations with.

How are compound conditions formed?

When used after the word SELECT, which symbol indicates that you want to include all fields in the query results in the order in which you described them to the DBMS when you created the table?

Use the ___________________ clause to indicate grouping.

Fields will appear in alphabetical order in the query results of a SELECT clause.

Preceding a condition by the NOT operator reverses the result of the original condition.

CHAR data types can be used to store numbers that will not be used in calculations.

Use the ____________________ data type for fields that contain letters and other special characters, and for fields that contain numbers that will not be used for arithmetic.

You use the WHERE clause on groups and the HAVING clause on rows.

Introduction to Database Management

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

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters

Exam 3: The Relational Model 2: SQL

SQL has built-in functions, which are also called ____________________ functions to calculate the number of entries, or the sum or average of all entries.

Which query will return the number of rows where the State field is 'AZ' from the table Customers and provide a total of the Payment field?

By using the word ____________________ in a query after a computation, you can assign a name to the computed field.

Based on the code shown, which query deletes any row in the OrderLine table in which the item number is MT03???OrderLine (OrderNum, ItemNum, NumOrdered, QuotedPrice)?Item (ItemNum, Description, OnHand, Category, Storehouse, Price )

Based on the code shown, which query lists the number, name, and balance of all customers with balances greater than or equal to $2,000 and less than or equal to $5,000???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

Based on the code shown, which query lists the descriptions of all items that are not in Storehouse 3???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )

Computed fields are existing fields in the database that you can perform computations with.

How are compound conditions formed?

When used after the word SELECT, which symbol indicates that you want to include all fields in the query results in the order in which you described them to the DBMS when you created the table?

Use the ___________________ clause to indicate grouping.

Fields will appear in alphabetical order in the query results of a SELECT clause.

Preceding a condition by the NOT operator reverses the result of the original condition.

CHAR data types can be used to store numbers that will not be used in calculations.

Use the ____________________ data type for fields that contain letters and other special characters, and for fields that contain numbers that will not be used for arithmetic.

You use the WHERE clause on groups and the HAVING clause on rows.

Introduction to Database Management

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

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters