Question 1

Instead of listing all the field names in the SELECT clause, you can use the @ symbol.

Accepted Answer

A) True 
 B)False  False

Question 2

Based on the code shown, which query changes the postal code of the student with ID 11433 to 14455???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)

Accepted Answer

A)  UPDATE Student SET PostalCode='14455' ; 
B)  UPDATE Student SET PostalCode WHERE StudentID='11433' ; 
C)  UPDATE Student IN PostalCode='14455' WHERE StudentID='11433' ; 
D)  UPDATE Student SET PostalCode='14455' WHERE StudentID='11433' ; 
A)  UPDATE Student SET PostalCode='14455' ; 
B)  UPDATE Student SET PostalCode WHERE StudentID='11433' ; 
C)  UPDATE Student IN PostalCode='14455' WHERE StudentID='11433' ; 
D)  UPDATE Student SET PostalCode='14455' WHERE StudentID='11433' ; D

Question 3

Use the ___________ operator when an exact match won't work.

Accepted Answer

LIKE

Question 4

Microsoft Access uses the != version of the "not equal to" operator.

Accepted Answer

A) True 
 B)False

Question 5

Which part of the SQL query specifies the table or tables that contain the data you wish to display in the query results?

Accepted Answer

A)  SELECT clause 
B)  WHERE clause 
C)  WITHIN clause 
D)  FROM clause 
A)  SELECT clause 
B)  WHERE clause 
C)  WITHIN clause 
D)  FROM clause

Question 6

A compound condition includes either or both of the AND and OR operators.

Accepted Answer

A) True 
 B)False

Question 7

In a DBMS such as Oracle or SQL Server, the _______________ command reverses changes to a database.

Accepted Answer

The answer of In a DBMS such as Oracle or...

Question 8

When you connect simple conditions using the AND operator, only one of the simple conditions must be true for the compound condition to be true.

Accepted Answer

A) True 
 B)False

Question 9

Use the _____________ function to calculate the number of rows that match the query.

Accepted Answer

The answer of Use the _____________ function to calculate the...

Question 10

In a SELECT statement, the WHERE clause is mandatory.

Accepted Answer

A) True 
 B)False

Question 11

____________________ means creating groups of records that share some common characteristics.

Accepted Answer

The answer of ____________________ means creating groups of records that...

Question 12

In versions of SQL other than Access, which character is used as a wildcard to represent any collection of characters?

Accepted Answer

A)  asterisks (*) 
B)  percent sign (%) 
C)  underscore (_) 
D)  hash tag (#) 
A)  asterisks (*) 
B)  percent sign (%) 
C)  underscore (_) 
D)  hash tag (#)

Question 13

When you place one query inside another, the inner query is called a ________________ and is evaluated first.

Accepted Answer

The answer of When you place one query inside another,...

Question 14

What command do you use to make changes to existing data in a table?

Accepted Answer

A)  MODIFY 
B)  CHANGE 
C)  SELECT 
D)  UPDATE 
A)  MODIFY 
B)  CHANGE 
C)  SELECT 
D)  UPDATE

Question 15

Based on the code shown, which query lists the number, name, and available credit for all customers with credit limits that exceed their balances???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

Accepted Answer

A)  SELECT CustomerNum, CustomerName AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ; 
B)  SELECT CustomerNum, CustomerName, CreditLimit AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ; 
C)  SELECT CustomerNum, CustomerName, Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ; 
D)  SELECT CustomerNum, CustomerName, CreditLimit-Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ; 
A)  SELECT CustomerNum, CustomerName AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ; 
B)  SELECT CustomerNum, CustomerName, CreditLimit AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ; 
C)  SELECT CustomerNum, CustomerName, Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ; 
D)  SELECT CustomerNum, CustomerName, CreditLimit-Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;

Question 16

In an SQL query, after the word _______________ , you list the fields you want to display in the query result.

Accepted Answer

The answer of In an SQL query, after the word...

Question 17

What are some common restrictions placed on table and column names by DBMSs?

Accepted Answer

Some common restrictions are:
1. The nam

Question 18

Based on the code shown, which query lists the descriptions of all items that are located in Storehouse3 and for which there are more than 20 units on hand???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )

Accepted Answer

A)  SELECT Description FROM Item WHERE Storehouse='3' AND OnHand>20 ; 
B)  SELECT Description FROM Item WHERE Storehouse='3' OR OnHand>20 ; 
C)  SELECT Description FROM Item WHERE Storehouse='3' ; 
D)  SELECT Description FROM Customer WHERE Storehouse='3' AND OnHand>20 ; 
A)  SELECT Description FROM Item WHERE Storehouse='3' AND OnHand>20 ; 
B)  SELECT Description FROM Item WHERE Storehouse='3' OR OnHand>20 ; 
C)  SELECT Description FROM Item WHERE Storehouse='3' ; 
D)  SELECT Description FROM Customer WHERE Storehouse='3' AND OnHand>20 ;

Question 19

One common restriction placed on table and column names by DBMSs is that names must start with a(n) ____________________.

Accepted Answer

The answer of One common restriction placed on table and...

Question 20

There is no difference between the COUNT function and the SUM function.

Accepted Answer

A) True 
 B)False

Instead of listing all the field names in the SELECT clause, you can use the @ symbol.

Based on the code shown, which query changes the postal code of the student with ID 11433 to 14455???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)

Use the ___________ operator when an exact match won't work.

Microsoft Access uses the != version of the "not equal to" operator.

Which part of the SQL query specifies the table or tables that contain the data you wish to display in the query results?

A compound condition includes either or both of the AND and OR operators.

In a DBMS such as Oracle or SQL Server, the _______________ command reverses changes to a database.

When you connect simple conditions using the AND operator, only one of the simple conditions must be true for the compound condition to be true.

Use the _____________ function to calculate the number of rows that match the query.

In a SELECT statement, the WHERE clause is mandatory.

____________________ means creating groups of records that share some common characteristics.

In versions of SQL other than Access, which character is used as a wildcard to represent any collection of characters?

When you place one query inside another, the inner query is called a ________________ and is evaluated first.

What command do you use to make changes to existing data in a table?

Based on the code shown, which query lists the number, name, and available credit for all customers with credit limits that exceed their balances???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

In an SQL query, after the word _______________ , you list the fields you want to display in the query result.

What are some common restrictions placed on table and column names by DBMSs?

Based on the code shown, which query lists the descriptions of all items that are located in Storehouse3 and for which there are more than 20 units on hand???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )

One common restriction placed on table and column names by DBMSs is that names must start with a(n) ____________________.

There is no difference between the COUNT function and the SUM function.

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

Instead of listing all the field names in the SELECT clause, you can use the @ symbol.

Based on the code shown, which query changes the postal code of the student with ID 11433 to 14455???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)

Use the ___________ operator when an exact match won't work.

Microsoft Access uses the != version of the "not equal to" operator.

Which part of the SQL query specifies the table or tables that contain the data you wish to display in the query results?

A compound condition includes either or both of the AND and OR operators.

In a DBMS such as Oracle or SQL Server, the _______________ command reverses changes to a database.

When you connect simple conditions using the AND operator, only one of the simple conditions must be true for the compound condition to be true.

Use the _____________ function to calculate the number of rows that match the query.

In a SELECT statement, the WHERE clause is mandatory.

____________________ means creating groups of records that share some common characteristics.

In versions of SQL other than Access, which character is used as a wildcard to represent any collection of characters?

When you place one query inside another, the inner query is called a ________________ and is evaluated first.

What command do you use to make changes to existing data in a table?

Based on the code shown, which query lists the number, name, and available credit for all customers with credit limits that exceed their balances???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

In an SQL query, after the word _______________ , you list the fields you want to display in the query result.

What are some common restrictions placed on table and column names by DBMSs?

Based on the code shown, which query lists the descriptions of all items that are located in Storehouse3 and for which there are more than 20 units on hand???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )

One common restriction placed on table and column names by DBMSs is that names must start with a(n) ____________________.

There is no difference between the COUNT function and the SUM function.

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