Question 1

You can use the SQL CREATE TABLE command to insert rows into a table.

Accepted Answer

A) True 
 B)False

Question 2

Based on the code shown, for each sales rep, which query lists the rep number, the number of customers assigned to the rep, and the average balance of the rep's customers? The records are grouped by rep number and ordered by rep number.??Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

Accepted Answer

A)  SELECT RepNum, AVG(Balance) FROM Customer GROUP BY RepNum ORDER BY RepNum ; 
B)  SELECT RepNum, COUNT(*), AVG(Balance) FROM Part GROUP BY RepNum ORDER BY RepNum ; 
C)  SELECT RepNum, COUNT(*), AVG(Balance) FROM Customer GROUP BY RepNum ORDER BY RepNum ; 
D)  SELECT RepNum, COUNT(*) FROM Customer GROUP BY RepNum ORDER BY RepNum ; 
A)  SELECT RepNum, AVG(Balance) FROM Customer GROUP BY RepNum ORDER BY RepNum ; 
B)  SELECT RepNum, COUNT(*), AVG(Balance) FROM Part GROUP BY RepNum ORDER BY RepNum ; 
C)  SELECT RepNum, COUNT(*), AVG(Balance) FROM Customer GROUP BY RepNum ORDER BY RepNum ; 
D)  SELECT RepNum, COUNT(*) FROM Customer GROUP BY RepNum ORDER BY RepNum ;

Question 3

Based on the code shown, which query lists the number and name of all customers that are either represented by sales rep 30 or that currently have orders on file, or both???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

Accepted Answer

A)  SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer ; 
B)  SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders WHERE Customer.CustomerNum=Orders.CustomerNum ; 
C)  SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' WHERE Customer.CustomerNum=Orders.CustomerNum ; 
D)  SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders ; 
A)  SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer ; 
B)  SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders WHERE Customer.CustomerNum=Orders.CustomerNum ; 
C)  SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' WHERE Customer.CustomerNum=Orders.CustomerNum ; 
D)  SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders ;

Question 4

SQL is the standard language for relational ___________________ manipulation.

Accepted Answer

The answer of SQL is the standard language for relational...

Question 5

Based on the code shown, which query lists the complete student table???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)

Accepted Answer

A)  SELECT Student ; 
B)  SELECT & FROM Student ; 
C)  SELECT * FROM Student ; 
D)  SELECT LastName, FirstName, Street, City, State, PostalCode FROM Student 
A)  SELECT Student ; 
B)  SELECT & FROM Student ; 
C)  SELECT * FROM Student ; 
D)  SELECT LastName, FirstName, Street, City, State, PostalCode FROM Student

Question 6

The BETWEEN operator is exclusive; it includes all numbers between the lower and higher numbers, but excludes the lower and higher numbers themselves.

Accepted Answer

A) True 
 B)False

Question 7

Based on the code shown, which query finds the name of the student whose ID is 1167???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)

Accepted Answer

A)  SELECT FirstName, LastName FROM Course WHERE StudentID='1167' ; 
B)  SELECT FirstName, LastName FROM * WHERE StudentID='1167' ; 
C)  SELECT FirstName, LastName FROM Student WHERE StudentID='1167' ; 
D)  SELECT FirstName, LastName FROM Customer WHERE StudentID='1167' ; 
A)  SELECT FirstName, LastName FROM Course WHERE StudentID='1167' ; 
B)  SELECT FirstName, LastName FROM * WHERE StudentID='1167' ; 
C)  SELECT FirstName, LastName FROM Student WHERE StudentID='1167' ; 
D)  SELECT FirstName, LastName FROM Customer WHERE StudentID='1167' ;

Question 8

Words that are part of the SQL language are called ____________________ words.

Accepted Answer

The answer of Words that are part of the SQL...

Question 9

Which query will return the number of rows where the State field is 'AZ' from the table Customers?

Accepted Answer

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

Question 10

Based on the code shown, which query lists the number, name, street, and credit limit of all customers? The records are ordered by customer name within descending credit limit.??Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

Accepted Answer

A)  SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer SORT BY CreditLimit DESC, CustomerName ; 
B)  SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer SORT BY CreditLimit ASC, CustomerName ; 
C)  SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ; 
D)  SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit ASC, CustomerName ; 
A)  SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer SORT BY CreditLimit DESC, CustomerName ; 
B)  SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer SORT BY CreditLimit ASC, CustomerName ; 
C)  SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ; 
D)  SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit ASC, CustomerName ;

Question 11

Based on the code shown, which query lists the name of every student whose postal code is 10113???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)

Accepted Answer

A)  SELECT FirstName, LastName WHERE PostalCode='10113' ; 
B)  SELECT FirstName, LastName FROM Student WHERE PostalCode='10113' ; 
C)  SELECT FirstName, LastName FROM Student WHERE PostalCode='10113' 
D)  SELECT * FROM Student WHERE PostalCode='10113' ; 
A)  SELECT FirstName, LastName WHERE PostalCode='10113' ; 
B)  SELECT FirstName, LastName FROM Student WHERE PostalCode='10113' ; 
C)  SELECT FirstName, LastName FROM Student WHERE PostalCode='10113' 
D)  SELECT * FROM Student WHERE PostalCode='10113' ;

Question 12

A valid name for a table might be tbl$Student.

Accepted Answer

A) True 
 B)False

Question 13

In Access SQL, which character is used as a wildcard to represent any individual character?

Accepted Answer

A)  underscore (_) 
B)  hash tag (#) 
C)  asterisks (*) 
D)  question mark (?) 
A)  underscore (_) 
B)  hash tag (#) 
C)  asterisks (*) 
D)  question mark (?)

Question 14

Based on the code shown, which query lists the number, name, credit limit, and balance 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 FROM Customer WHERE CreditLimit>Balance ; 
B)  SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ; 
C)  SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE CreditLimit>Balance ; 
D)  SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer ; 
A)  SELECT CustomerNum, CustomerName FROM Customer WHERE CreditLimit>Balance ; 
B)  SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ; 
C)  SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE CreditLimit>Balance ; 
D)  SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer ;

Question 15

The ____________________ data type stores integers in the range -32768 to 32767.

Accepted Answer

The answer of The ____________________ data type stores integers in...

Question 16

SQL uses an on-screen form to create tables, update tables, and retrieve data from tables.

Accepted Answer

A) True 
 B)False

Question 17

Based on the code shown, which query finds how many items are in category TOY???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )

Accepted Answer

A)  SELECT SUM(*) FROM Item WHERE Category='TOY' ; 
B)  SELECT COUNT(*) FROM Item WHERE Category='TOY' ; 
C)  SELECT COUNT FROM Item WHERE Category='TOY' ; 
D)  SELECT COUNT* FROM Item WHERE Category='TOY' ; 
A)  SELECT SUM(*) FROM Item WHERE Category='TOY' ; 
B)  SELECT COUNT(*) FROM Item WHERE Category='TOY' ; 
C)  SELECT COUNT FROM Item WHERE Category='TOY' ; 
D)  SELECT COUNT* FROM Item WHERE Category='TOY' ;

Question 18

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

Accepted Answer

A)  SELECT Description FROM Customer 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 Item WHERE OnHand>20 ; 
A)  SELECT Description FROM Customer 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 Item WHERE OnHand>20 ;

Question 19

Which operator do you use in the WHERE clause when you want to include a wildcard?

Accepted Answer

A)  LIKE 
B)  AS 
C)  BETWEEN 
D)  UNION 
A)  LIKE 
B)  AS 
C)  BETWEEN 
D)  UNION

Question 20

A WHERE and a HAVING clause cannot be included in the same query.

Accepted Answer

A) True 
 B)False

You can use the SQL CREATE TABLE command to insert rows into a table.

Based on the code shown, which query lists the number and name of all customers that are either represented by sales rep 30 or that currently have orders on file, or both???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

SQL is the standard language for relational ___________________ manipulation.

Based on the code shown, which query lists the complete student table???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)

The BETWEEN operator is exclusive; it includes all numbers between the lower and higher numbers, but excludes the lower and higher numbers themselves.

Based on the code shown, which query finds the name of the student whose ID is 1167???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)

Words that are part of the SQL language are called ____________________ words.

Which query will return the number of rows where the State field is 'AZ' from the table Customers?

Based on the code shown, which query lists the number, name, street, and credit limit of all customers? The records are ordered by customer name within descending credit limit.??Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

Based on the code shown, which query lists the name of every student whose postal code is 10113???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)

A valid name for a table might be tbl$Student.

In Access SQL, which character is used as a wildcard to represent any individual character?

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

The ____________________ data type stores integers in the range -32768 to 32767.

SQL uses an on-screen form to create tables, update tables, and retrieve data from tables.

Based on the code shown, which query finds how many items are in category TOY???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )

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

Which operator do you use in the WHERE clause when you want to include a wildcard?

A WHERE and a HAVING clause cannot be included in the same query.

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

You can use the SQL CREATE TABLE command to insert rows into a table.

Based on the code shown, which query lists the number and name of all customers that are either represented by sales rep 30 or that currently have orders on file, or both???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

SQL is the standard language for relational ___________________ manipulation.

Based on the code shown, which query lists the complete student table???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)

The BETWEEN operator is exclusive; it includes all numbers between the lower and higher numbers, but excludes the lower and higher numbers themselves.

Based on the code shown, which query finds the name of the student whose ID is 1167???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)

Words that are part of the SQL language are called ____________________ words.

Which query will return the number of rows where the State field is 'AZ' from the table Customers?

Based on the code shown, which query lists the number, name, street, and credit limit of all customers? The records are ordered by customer name within descending credit limit.??Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

Based on the code shown, which query lists the name of every student whose postal code is 10113???Student (StudentID, FirstName, LastName, Street, City, State, PostalCode)

A valid name for a table might be tbl$Student.

In Access SQL, which character is used as a wildcard to represent any individual character?

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

The ____________________ data type stores integers in the range -32768 to 32767.

SQL uses an on-screen form to create tables, update tables, and retrieve data from tables.

Based on the code shown, which query finds how many items are in category TOY???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )

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

Which operator do you use in the WHERE clause when you want to include a wildcard?

A WHERE and a HAVING clause cannot be included in the same query.

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