Question 1

In Access SQL, which operator do you use in the WHERE clause when you want to include a wildcard in the criterion?

Accepted Answer

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

Question 2

When you place one query inside another, the inner query is called a(n) ___________________ and is evaluated first.

Accepted Answer

A) joined query 
B) aggregate query 
C) subquery 
D) compound query 
A) joined query 
B) aggregate query 
C) subquery 
D) compound query

Question 3

Which of the following SQL statements selects ProductDescription and Price fields for every record in the Products table with a Price value greater than $50.00?

Accepted Answer

A) SELECT ProductDescription, Price FROM Products WHERE Price > 50; B) SELECT ProductDescription, Price > 50 FROM Products; C) SELECT ProductDescription, Price FROM Products WITH Price > 50; D) SELECT ProductDescription, Price FROM Products WHERE Price < 50; A) SELECT ProductDescription, Price FROM Products WHERE Price > 50; B) SELECT ProductDescription, Price > 50 FROM Products; C) SELECT ProductDescription, Price FROM Products WITH Price > 50; D) SELECT ProductDescription, Price FROM Products WHERE Price < 50;

Question 4

What SQL command do you use to add new data to a table?

Accepted Answer

A) INSERT 
B) APPEND 
C) ADDTO 
D) SELECT 
A) INSERT 
B) APPEND 
C) ADDTO 
D) SELECT

Question 5

Which of the following operators allows you to specify a range and is often used with date criteria?

Accepted Answer

A) BETWEEN 
B) NOT 
C) LIKE 
D) IN 
A) BETWEEN 
B) NOT 
C) LIKE 
D) IN

Question 6

The Clients table contains 12 records with three different values in the PostalCode field. If you create a query that groups the records based on the PostalCode field, how many records do the results contain?

Accepted Answer

A) 12 
B) 36 
C) 3 
D) 4 
A) 12 
B) 36 
C) 3 
D) 4

Question 7

Based on the SQL 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? Group and order the records by rep number. Customers ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

Accepted Answer

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

Question 8

Which command joins the related Customers and Orders tables based on the common CustomerID field?

Accepted Answer

A) WHERE CustomerID.Customers = CustomerID.Orders 
B) JOIN Customers.CustomerID = Orders.CustomerID 
C) WHERE Customers.CustomerID = Orders.CustomerID 
D) SELECT Customers.CustomerID AND Orders.CustomerID 
A) WHERE CustomerID.Customers = CustomerID.Orders 
B) JOIN Customers.CustomerID = Orders.CustomerID 
C) WHERE Customers.CustomerID = Orders.CustomerID 
D) SELECT Customers.CustomerID AND Orders.CustomerID

Question 9

When do you use the & operator in an expression in Access Query Design View?

Accepted Answer

A) to match a specific list of criteria 
B) to reverse the result of the original condition. 
C) to combine values in character fields 
D) to sum values in numeric fields 
A) to match a specific list of criteria 
B) to reverse the result of the original condition. 
C) to combine values in character fields 
D) to sum values in numeric fields

Question 10

Fields appear in alphabetical order based on fieldname in the query results of a SELECT clause.

Accepted Answer

A) True 
 B)False

In Access SQL, which operator do you use in the WHERE clause when you want to include a wildcard in the criterion?

When you place one query inside another, the inner query is called a(n) ___________________ and is evaluated first.

Which of the following SQL statements selects ProductDescription and Price fields for every record in the Products table with a Price value greater than $50.00?

What SQL command do you use to add new data to a table?

Which of the following operators allows you to specify a range and is often used with date criteria?

The Clients table contains 12 records with three different values in the PostalCode field. If you create a query that groups the records based on the PostalCode field, how many records do the results contain?

Which command joins the related Customers and Orders tables based on the common CustomerID field?

When do you use the & operator in an expression in Access Query Design View?

Fields appear in alphabetical order based on fieldname in the query results of a SELECT clause.

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Industry Careers

Database Industry Trends

Filters

Exam 7: Database Management Systems Processes and Services

In Access SQL, which operator do you use in the WHERE clause when you want to include a wildcard in the criterion?

When you place one query inside another, the inner query is called a(n) ___________________ and is evaluated first.

Which of the following SQL statements selects ProductDescription and Price fields for every record in the Products table with a Price value greater than $50.00?

What SQL command do you use to add new data to a table?

Which of the following operators allows you to specify a range and is often used with date criteria?

The Clients table contains 12 records with three different values in the PostalCode field. If you create a query that groups the records based on the PostalCode field, how many records do the results contain?

Which command joins the related Customers and Orders tables based on the common CustomerID field?

When do you use the & operator in an expression in Access Query Design View?

Fields appear in alphabetical order based on fieldname in the query results of a SELECT clause.

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Industry Careers

Database Industry Trends

Filters