Question 1

Which SQL keyword can you use to join two tables that have a one-to-many relationship?

Accepted Answer

A) LINK 
B) RELATE 
C) UNION 
D) WHERE 
A) LINK 
B) RELATE 
C) UNION 
D) WHERE

Question 2

Explain the requirements of two sets of records involved in a union.

Accepted Answer

The two sets of records involved in a un

Question 3

In an Access query, a "group" of records _____.

Accepted Answer

A) is rarely sorted 
B) always contains numeric fields 
C) has the same value in a particular field 
D) is a good candidate for a subquery 
A) is rarely sorted 
B) always contains numeric fields 
C) has the same value in a particular field 
D) is a good candidate for a subquery

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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

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 7

When you create a query using SQL View to display fields and records, Access automatically places the _______________ keyword in the query window.

Accepted Answer

A) SELECT 
B) UPDATE 
C) CREATE 
D) FIND 
A) SELECT 
B) UPDATE 
C) CREATE 
D) FIND

Question 8

Which part of a SQL query specifies the table names that contain the data you want 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 9

In what type of SQL operation must two tables have the same field structure?

Accepted Answer

A) union 
B) join 
C) concatenation 
D) extract 
A) union 
B) join 
C) concatenation 
D) extract

Question 10

When a SQL statement consists of two queries and you place one query inside another, the inner query becomes a(n) _____.

Accepted Answer

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

Question 11

How can you improve your SQL skills?

Accepted Answer

A) Practice using online SQL tutorials. 
B) Create Access queries exclusively in Query Design View. 
C) Take a course in JavaScript. 
D) Use a search engine to conduct searches for general information. 
A) Practice using online SQL tutorials. 
B) Create Access queries exclusively in Query Design View. 
C) Take a course in JavaScript. 
D) Use a search engine to conduct searches for general information.

Question 12

What would you most likely use in SQL to perform calculations on groups of records?

Accepted Answer

A) Boolean operators 
B) aggregate functions 
C) data definition language 
D) lookup functions 
A) Boolean operators 
B) aggregate functions 
C) data definition language 
D) lookup functions

Question 13

Based on the table description and SQL shown, which query finds the description and price of the items that have a Price field value greater than Wireless charger, ItemNum W208? Items (ItemNum, Description, OnHand, Category, Storehouse, Price )

Accepted Answer

A) SELECT Description, Price FROM Items WHERE Price >(SELECT Price FROM Items WHERE ItemNum = 'W208'); 
B) SELECT Description, Price FROM Items WHERE Price > ItemNum = 'W208'); 
C) SELECT Price FROM Items WHERE ItemNum > 'W208' (SELECT Description, Price FROM Items); 
D) SELECT Description, Price FROM Items WHERE Price > (SELECT ItemNum = 'W208' FROM Items); 
A) SELECT Description, Price FROM Items WHERE Price >(SELECT Price FROM Items WHERE ItemNum = 'W208'); 
B) SELECT Description, Price FROM Items WHERE Price > ItemNum = 'W208'); 
C) SELECT Price FROM Items WHERE ItemNum > 'W208' (SELECT Description, Price FROM Items); 
D) SELECT Description, Price FROM Items WHERE Price > (SELECT ItemNum = 'W208' FROM Items);

Question 14

A good name for an Access table might be tbl!Student.

Accepted Answer

A) True 
 B)False

Question 15

When you connect query conditions using the AND operator, only one of the conditions must be true for a particular record to be selected.

Accepted Answer

A) True 
 B)False

Question 16

Based on the SQL shown, which query lists the last names and bonuses of employees who have a Bonus field value greater than Juliana Suarez, EmployeeID 14? Employees ( EmployeeID, LastName, FirstName, HireDate, JobTitle, Bonus )

Accepted Answer

A) SELECT LastName, Bonus FROM Employees WHERE Bonus >(SELECT Bonus FROM Employees WHERE EmployeeID = '14'); 
B) SELECT LastName, Bonus FROM Employees HAVING Bonus > EmployeeID = '14'; 
C) SELECT LastName, Bonus FROM Employees WHERE Bonus > UNION (SELECT LastName, Bonus FROM Employees WHERE EmployeeID = '14'); 
D) SELECT LastName, Bonus FROM Employees WHERE Bonus > UPDATE SET EmployeeID = '14'; 
A) SELECT LastName, Bonus FROM Employees WHERE Bonus >(SELECT Bonus FROM Employees WHERE EmployeeID = '14'); 
B) SELECT LastName, Bonus FROM Employees HAVING Bonus > EmployeeID = '14'; 
C) SELECT LastName, Bonus FROM Employees WHERE Bonus > UNION (SELECT LastName, Bonus FROM Employees WHERE EmployeeID = '14'); 
D) SELECT LastName, Bonus FROM Employees WHERE Bonus > UPDATE SET EmployeeID = '14';

Question 17

Based on the SQL shown, which query selects the LastName, JobTitle, and increased bonus for all employees with a job title of SalesRep? The increased bonus is calculated as $100 more than the current bonus. Employees ( EmployeeID, LastName, FirstName, HireDate, JobTitle, Bonus )

Accepted Answer

A) SELECT LastName, JobTitle, Bonus FROM Employees WHERE JobTitle = 'SalesRep' AND IncreasedBonus = Bonus + 100; 
B) SELECT LastName, JobTitle, Bonus AS IncreasedBonus + 100 FROM Employees WHERE JobTitle = 'SalesRep'; 
C) SELECT * FROM Employees WHERE IncreasedBonus = Bonus + 100; 
D) SELECT LastName, JobTitle, Bonus + 100 AS IncreasedBonus FROM Employees WHERE JobTitle = 'SalesRep'; 
A) SELECT LastName, JobTitle, Bonus FROM Employees WHERE JobTitle = 'SalesRep' AND IncreasedBonus = Bonus + 100; 
B) SELECT LastName, JobTitle, Bonus AS IncreasedBonus + 100 FROM Employees WHERE JobTitle = 'SalesRep'; 
C) SELECT * FROM Employees WHERE IncreasedBonus = Bonus + 100; 
D) SELECT LastName, JobTitle, Bonus + 100 AS IncreasedBonus FROM Employees WHERE JobTitle = 'SalesRep';

Question 18

Explain how to use three SQL clauses to select fields and join tables using the WHERE keyword in SQL.

Accepted Answer

To join tables in SQL, do the following:

Question 19

While not always required, how should you end an SQL command?

Accepted Answer

A) with a comma (,) 
B) with a period (.) 
C) with a colon (:) 
D) with a semicolon (;) 
A) with a comma (,) 
B) with a period (.) 
C) with a colon (:) 
D) with a semicolon (;)

Question 20

In Access SQL, you use the asterisk (*) as a wildcard character to represent any number of characters.

Accepted Answer

A) True 
 B)False

Which SQL keyword can you use to join two tables that have a one-to-many relationship?

Explain the requirements of two sets of records involved in a union.

In an Access query, a "group" of records _____.

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

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

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

When you create a query using SQL View to display fields and records, Access automatically places the _______________ keyword in the query window.

Which part of a SQL query specifies the table names that contain the data you want to display in the query results?

In what type of SQL operation must two tables have the same field structure?

When a SQL statement consists of two queries and you place one query inside another, the inner query becomes a(n) _____.

How can you improve your SQL skills?

What would you most likely use in SQL to perform calculations on groups of records?

Based on the table description and SQL shown, which query finds the description and price of the items that have a Price field value greater than Wireless charger, ItemNum W208? Items (ItemNum, Description, OnHand, Category, Storehouse, Price )

A good name for an Access table might be tbl!Student.

When you connect query conditions using the AND operator, only one of the conditions must be true for a particular record to be selected.

Based on the SQL shown, which query lists the last names and bonuses of employees who have a Bonus field value greater than Juliana Suarez, EmployeeID 14? Employees ( EmployeeID, LastName, FirstName, HireDate, JobTitle, Bonus )

Based on the SQL shown, which query selects the LastName, JobTitle, and increased bonus for all employees with a job title of SalesRep? The increased bonus is calculated as $100 more than the current bonus. Employees ( EmployeeID, LastName, FirstName, HireDate, JobTitle, Bonus )

Explain how to use three SQL clauses to select fields and join tables using the WHERE keyword in SQL.

While not always required, how should you end an SQL command?

In Access SQL, you use the asterisk (*) as a wildcard character to represent any number of characters.

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

Which SQL keyword can you use to join two tables that have a one-to-many relationship?

Explain the requirements of two sets of records involved in a union.

In an Access query, a "group" of records _____.

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

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

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

When you create a query using SQL View to display fields and records, Access automatically places the _______________ keyword in the query window.

Which part of a SQL query specifies the table names that contain the data you want to display in the query results?

In what type of SQL operation must two tables have the same field structure?

When a SQL statement consists of two queries and you place one query inside another, the inner query becomes a(n) _____.

How can you improve your SQL skills?

What would you most likely use in SQL to perform calculations on groups of records?

Based on the table description and SQL shown, which query finds the description and price of the items that have a Price field value greater than Wireless charger, ItemNum W208? Items (ItemNum, Description, OnHand, Category, Storehouse, Price )

A good name for an Access table might be tbl!Student.

When you connect query conditions using the AND operator, only one of the conditions must be true for a particular record to be selected.

Based on the SQL shown, which query lists the last names and bonuses of employees who have a Bonus field value greater than Juliana Suarez, EmployeeID 14? Employees ( EmployeeID, LastName, FirstName, HireDate, JobTitle, Bonus )

Based on the SQL shown, which query selects the LastName, JobTitle, and increased bonus for all employees with a job title of SalesRep? The increased bonus is calculated as $100 more than the current bonus. Employees ( EmployeeID, LastName, FirstName, HireDate, JobTitle, Bonus )

Explain how to use three SQL clauses to select fields and join tables using the WHERE keyword in SQL.

While not always required, how should you end an SQL command?

In Access SQL, you use the asterisk (*) as a wildcard character to represent any number of characters.

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