Question 1

Which statement creates a table named PostalCodes with a five-character PostalCode text field and a two-character Abbrev text field?

Accepted Answer

A) CREATE TABLE PostalCodes (PostalCode TEXT, Abbrev TEXT); 
B) CREATE TABLE PostalCodes (PostalCode (TEXT 5), Abbrev (TEXT 2)); 
C) CREATE TABLE PostalCodes (PostalCode TEXT (5), Abbrev TEXT (2)); 
D) CREATE TABLE (PostalCode TEXT (5), Abbrev TEXT (2)); 
A) CREATE TABLE PostalCodes (PostalCode TEXT, Abbrev TEXT); 
B) CREATE TABLE PostalCodes (PostalCode (TEXT 5), Abbrev (TEXT 2)); 
C) CREATE TABLE PostalCodes (PostalCode TEXT (5), Abbrev TEXT (2)); 
D) CREATE TABLE (PostalCode TEXT (5), Abbrev TEXT (2)); C

Question 2

How are compound SQL criteria conditions formed?

Accepted Answer

Compound conditions are formed by connecting two or more single conditions using one or both of the following operators: AND and OR.

Question 3

Which function calculates the number of records in a table?

Accepted Answer

A) COUNT 
B) SUM 
C) MAX 
D) MIN 
A) COUNT 
B) SUM 
C) MAX 
D) MIN A

Question 4

Which of the following SQL commands sorts records by ProductName within ProductType?

Accepted Answer

A) SORT BY ProductType, ProductName 
B) LIST ProductName IN ProductType 
C) ORDER BY ProductName IN ProductType 
D) ORDER BY ProductType, ProductName 
A) SORT BY ProductType, ProductName 
B) LIST ProductName IN ProductType 
C) ORDER BY ProductName IN ProductType 
D) ORDER BY ProductType, ProductName

Question 5

What are five restrictions placed on table and field names in Access?

Accepted Answer

Some common restrictions are:
1. Table a

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Why is SQL a highly sought-after language for programmers?

Accepted Answer

A) SQL is difficult to learn because it does not use English-like commands. 
B) SQL is a universal language for selecting and maintaining data in a relational database. 
C) SQL provides a foundation for learning about artificial intelligence. 
D) SQL is a popular language for manipulating graphical objects. 
A) SQL is difficult to learn because it does not use English-like commands. 
B) SQL is a universal language for selecting and maintaining data in a relational database. 
C) SQL provides a foundation for learning about artificial intelligence. 
D) SQL is a popular language for manipulating graphical objects.

Question 8

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

Accepted Answer

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

Question 9

What SQL command can you use to join two tables?

Accepted Answer

A) CONTAINS 
B) WHERE 
C) EXTRACT 
D) MERGE 
A) CONTAINS 
B) WHERE 
C) EXTRACT 
D) MERGE

Question 10

When you use a name containing a space in Access SQL, what must you do to specify the table or column name?

Accepted Answer

A) Enclose it in "quotation marks". 
B) Enclose it in [square brackets]. 
C) Enclose it in *asterisks*. 
D) Enclose it in (parentheses). 
A) Enclose it in "quotation marks". 
B) Enclose it in [square brackets]. 
C) Enclose it in *asterisks*. 
D) Enclose it in (parentheses).

Question 11

Based on the table description and SQL shown, which query increases the FeeAmount by 2 percent? Fees ( FeeID, FeeType, FeeAmount )

Accepted Answer

A) UPDATE Fees SET FeeAmount = FeeAmount * 1.2; 
B) UPDATE Fees SET FeeAmount = FeeAmount * 2%; 
C) UPDATE Fees SET FeeAmount = FeeAmount * 1.02; 
D) SELECT Fees WHERE FeeAmount = FeeAmount * 1.02; 
A) UPDATE Fees SET FeeAmount = FeeAmount * 1.2; 
B) UPDATE Fees SET FeeAmount = FeeAmount * 2%; 
C) UPDATE Fees SET FeeAmount = FeeAmount * 1.02; 
D) SELECT Fees WHERE FeeAmount = FeeAmount * 1.02;

Question 12

Which of the following is currently considered the most sought-after language for programmers?

Accepted Answer

A) Visual Basic 
B) SQL 
C) COBOL 
D) CSS 
A) Visual Basic 
B) SQL 
C) COBOL 
D) CSS

Question 13

In a query that uses an aggregate function, which SQL clause do you use to include criteria that limits the number of records selected for the query?

Accepted Answer

A) RESTRICTING 
B) GROUPING 
C) JOINING 
D) HAVING 
A) RESTRICTING 
B) GROUPING 
C) JOINING 
D) HAVING

Question 14

In Access SQL, which operator could you use to list all fields from a Customers table where the City field is Madison, Middleton, or Belleville?

Accepted Answer

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

Question 15

Based on the table description and SQL shown, which query lists the first name and last name of all students, separated by a space? ​
Students (StudentID, FirstName, LastName, Street, City, State, PostalCode)

Accepted Answer

A) SELECT FirstName & LastName AS FullName FROM Students; 
B) SELECT FirstName & ' ' & LastName AS FullName FROM Students;; 
C) SELECT FirstName ' ' LastName AS FullName FROM Students; 
D) SELECT FirstName, LastName AS FullName FROM Students; 
A) SELECT FirstName & LastName AS FullName FROM Students; 
B) SELECT FirstName & ' ' & LastName AS FullName FROM Students;; 
C) SELECT FirstName ' ' LastName AS FullName FROM Students; 
D) SELECT FirstName, LastName AS FullName FROM Students;

Question 16

Based on the table description and SQL shown, which query lists the states in the Students table and displays the number of students from each state? Students (StudentID, FirstName, LastName, Street, City, State, PostalCode)

Accepted Answer

A) SELECT State, COUNT(*) AS CountOfState FROM Students ORDER BY State; 
B) SELECT State, COUNT(*) AS CountOfState FROM Students HAVING State; 
C) SELECT State, COUNT(*) AS CountOfState FROM Students; 
D) SELECT State, COUNT(*) AS CountOfState FROM Students GROUP BY State; 
A) SELECT State, COUNT(*) AS CountOfState FROM Students ORDER BY State; 
B) SELECT State, COUNT(*) AS CountOfState FROM Students HAVING State; 
C) SELECT State, COUNT(*) AS CountOfState FROM Students; 
D) SELECT State, COUNT(*) AS CountOfState FROM Students GROUP BY State;

Question 17

What SQL keyword do you use in a query that saves the results of the query as a table?

Accepted Answer

A) UPDATE 
B) INSERT 
C) INTO 
D) DELETE 
A) UPDATE 
B) INSERT 
C) INTO 
D) DELETE

Question 18

Which SQL commands do you use to update the values of an existing field?

Accepted Answer

A) UPDATE and SET 
B) LIKE and IN 
C) FROM and WHERE 
D) INSERT and INTO 
A) UPDATE and SET 
B) LIKE and IN 
C) FROM and WHERE 
D) INSERT and INTO

Question 19

What SQL 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 20

List five Access data types and their corresponding SQL data types.

Accepted Answer

Access SQL
AutoNumber COUNTER or AUTOINC

Which statement creates a table named PostalCodes with a five-character PostalCode text field and a two-character Abbrev text field?

How are compound SQL criteria conditions formed?

Which function calculates the number of records in a table?

Which of the following SQL commands sorts records by ProductName within ProductType?

What are five restrictions placed on table and field names in Access?

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

Why is SQL a highly sought-after language for programmers?

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

What SQL command can you use to join two tables?

When you use a name containing a space in Access SQL, what must you do to specify the table or column name?

Based on the table description and SQL shown, which query increases the FeeAmount by 2 percent? Fees ( FeeID, FeeType, FeeAmount )

Which of the following is currently considered the most sought-after language for programmers?

In a query that uses an aggregate function, which SQL clause do you use to include criteria that limits the number of records selected for the query?

In Access SQL, which operator could you use to list all fields from a Customers table where the City field is Madison, Middleton, or Belleville?

Based on the table description and SQL shown, which query lists the first name and last name of all students, separated by a space? Students (StudentID, FirstName, LastName, Street, City, State, PostalCode)

Based on the table description and SQL shown, which query lists the states in the Students table and displays the number of students from each state? Students (StudentID, FirstName, LastName, Street, City, State, PostalCode)

What SQL keyword do you use in a query that saves the results of the query as a table?

Which SQL commands do you use to update the values of an existing field?

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

List five Access data types and their corresponding SQL data types.

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 statement creates a table named PostalCodes with a five-character PostalCode text field and a two-character Abbrev text field?

How are compound SQL criteria conditions formed?

Which function calculates the number of records in a table?

Which of the following SQL commands sorts records by ProductName within ProductType?

What are five restrictions placed on table and field names in Access?

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

Why is SQL a highly sought-after language for programmers?

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

What SQL command can you use to join two tables?

When you use a name containing a space in Access SQL, what must you do to specify the table or column name?

Based on the table description and SQL shown, which query increases the FeeAmount by 2 percent? Fees ( FeeID, FeeType, FeeAmount )

Which of the following is currently considered the most sought-after language for programmers?

In a query that uses an aggregate function, which SQL clause do you use to include criteria that limits the number of records selected for the query?

In Access SQL, which operator could you use to list all fields from a Customers table where the City field is Madison, Middleton, or Belleville?

Based on the table description and SQL shown, which query lists the first name and last name of all students, separated by a space? ​ Students (StudentID, FirstName, LastName, Street, City, State, PostalCode)

Based on the table description and SQL shown, which query lists the states in the Students table and displays the number of students from each state? Students (StudentID, FirstName, LastName, Street, City, State, PostalCode)

What SQL keyword do you use in a query that saves the results of the query as a table?

Which SQL commands do you use to update the values of an existing field?

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

List five Access data types and their corresponding SQL data types.

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

Based on the table description and SQL shown, which query lists the first name and last name of all students, separated by a space? Students (StudentID, FirstName, LastName, Street, City, State, PostalCode)