Question 1

The following database will be used in this question:
GENERAL SALES DATABASE:
SALESREP
  
CUSTOMER
  
Explain the use of the SQL keyword LIKE.Include an example based on the CUSTOMER table from the General Sales database.

Accepted Answer

The answer of The following database will be used in...

Question 2

What is SQL?

Accepted Answer

The answer of What is SQL?...

Question 3

In an SQL query,which SQL keyword is used to specify the names of tables to be joined?
A)FROM
B)HAVING
C)JOIN
D)SELECT
E)WHERE

Accepted Answer

The FROM keyword is used in SQL to specify the tables from which to retrieve data, including when joining tables.

Question 4

The following database will be used in this question:
GENERAL SALES DATABASE:
SALESREP
  
CUSTOMER
  
Explain the use of the of SQL keyword SELECT.Include an example based on the CUSTOMER table in the General Sales database.

Accepted Answer

The answer of The following database will be used in...

Question 5

When one SQL query is embedded in another SQL query,the first SQL query can still contain an SQL ________ clause.
A)FROM THE
B)WHERE THE
C)ORDER BY
D)GROUP BY
E)C and D

Accepted Answer

The first SQL query can still contain an ORDER BY or GROUP BY clause when embedded in another SQL query.

Question 6

Regarding the interchangeability of subqueries and joins,
A)a join can always be used as an alternative to a subquery,and a subquery can always be used as an alternative to a join.
B)a join can sometimes be used as an alternative to a subquery,and a subquery can sometimes be used as an alternative to a join.
C)a join can always be used as an alternative to a subquery,and a subquery can sometimes be used as an alternative to a join.
D)a join can sometimes be used as an alternative to a subquery,and a subquery can always be used as an alternative to a join.
E)a join can never be used as an alternative to a subquery,and a subquery can never be used as an alternative to a join.

Accepted Answer

Joins and subqueries can sometimes be used interchangeably, but not always. The choice depends on the specific requirements and structure of the query.

Question 7

When one SQL query is embedded in another SQL query,the second SQL query is embedded in the ________ of the first query.
A)SELECT
B)FROM
C)WHERE
D)GROUP BY
E)HAVING

Accepted Answer

The second SQL query is typically embedded in the WHERE clause of the first query as a subquery to filter results based on specific conditions.

Question 8

In an SQL query,which SQL keyword is used with built-in functions to group together rows that have the same value in a specified column?
A)GROUP BY
B)ORDER BY
C)SELECT
D)SORT BY
E)DISTINCT SET

Accepted Answer

The GROUP BY keyword is used with built-in functions to group together rows that have the same value in a specified column. It enables aggregation and summarization of data based on common values in a column. Options B) ORDER BY, C) SELECT, D) SORT BY, and E) DISTINCT SET do not serve the same purpose as GROUP BY in SQL.

Question 9

In an SQL query,which built-in function is used to compute the number of rows in a table?
A)AVG
B)COUNT
C)MAX
D)MIN
E)MEAN

Accepted Answer

The built-in function COUNT is used to compute the number of rows in a table. It returns the number of rows that match a specific condition, or all the rows in the table if no condition is specified. AVG calculates the average value of a selected column, MAX returns the maximum value in a selected column, MIN returns the minimum value in a selected column, and MEAN is not a valid SQL function.

Question 10

Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the following is not a valid ANSI SQL command?
A)SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'Ja%';
B)SELECT COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000;
C)SELECT COUNT(EmpNo)
FROM EMPLOYEE;
D)SELECT HireDate,COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000;
E)SELECT HireDate,COUNT(*)
FROM EMPLOYEE
GROUP BY HireDate;

Accepted Answer

The command in option D is not valid because it uses an aggregate function (COUNT) without a GROUP BY clause for the non-aggregated column (HireDate).

Question 11

Briefly describe subqueries and joins.Explain when each is not an acceptable alternative for the other.

Accepted Answer

The answer of Briefly describe subqueries and joins.Explain when each...

Question 12

Based on the tables below,which of the following ANSI SQL commands would return the average customer balance grouped by SalesRepNo? GENERAL SALES DATABASE:
SALESREP

CUSTOMER

A)SELECT AVG (Balance)
FROM CUSTOMER
WHERE SalesRepNo;
B)SELECT AVG (Balance)
FROM CUSTOMER
GROUP BY SalesRepNo;
C)SELECT AVG (Balance)
FROM CUSTOMER,SALESREP
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo;
D)SELECT AVG (Balance)
FROM CUSTOMER
ORDER BY SalesRepNo;
E)SELECT AVG (BalancE)
FROM CUSTOMER,SALESREP
WHERE CUSTOMER.SalesRepNo = CUSTOMER.SalesRepNo
HAVING SalesRepNo;

Accepted Answer

This is the correct syntax for grouping the average customer balance by SalesRepNo. The other options either do not group by SalesRepNo or have syntax errors.

Question 13

In an SQL query,which SQL keyword is used with GROUP BY to select groups meeting specified criteria?
A)AND
B)EXISTS
C)HAVING
D)IN
E)WHERE

Accepted Answer

The HAVING keyword is used after a GROUP BY clause to filter the groups based on specified criteria. It allows us to apply conditions to the aggregated data and filter the groups that meet those conditions. The WHERE keyword is used to filter individual rows before grouping, while the HAVING keyword is used to filter the grouped data. The AND, EXISTS, and IN keywords are used for different purposes and do not apply to filtering groups in a GROUP BY query.

Question 14

In an SQL query of two tables,which SQL keyword indicates that we want data from all the rows of one table to be included in the result,even if the row does not correspond to any data in the other table?
A)LEFT JOIN
B)RIGHT JOIN
C)INCLUDE
D)A and B
E)A,B,and C

Accepted Answer

The answer of In an SQL query of two tables,which...

Question 15

In an SQL query,which SQL keyword is used to implement a subquery?
A)GROUP BY
B)HAVING
C)ORDER BY
D)SELECT
E)SORT BY

Accepted Answer

The SELECT keyword is used to implement a subquery in SQL. Subqueries are enclosed in parentheses and are used as part of a larger query to retrieve data for further analysis or processing. The result of a subquery is used to filter or further refine data in the main query.

Question 16

When one SQL query is embedded in another SQL query,this is referred to as a ________.
A)subset
B)join
C)WHERE Query
D)subquery
E)set query

Accepted Answer

When a SQL query is embedded inside another SQL query, it is called a subquery. The subquery is used within the WHERE clause of the main query, and it is enclosed within parentheses. The subquery can be used to filter results based on specific conditions, or to retrieve data from related tables.

Question 17

In an SQL query,the built-in function COUNT works with columns containing data of which of the following data types?
A)Integer
B)Numeric
C)Char
D)A and B
E)A,B,and C

Accepted Answer

The COUNT function in SQL can be used with columns of any data type, including Integer, Numeric, and Char, to count the number of non-NULL values.

Question 18

In an SQL query,which SQL keyword is used to specify the column names to be used in a join?
A)FROM
B)HAVING
C)JOIN
D)SELECT
E)WHERE

Accepted Answer

The answer of In an SQL query,which SQL keyword is...

Question 19

Based on the tables below,which of the following commands in ANSI SQL would return only the name of the sales representative and the name of the customer for each customer that has a balance greater than 400? GENERAL SALES DATABASE:
SALESREP

CUSTOMER

A)SELECT *
FROM SALESREP,CUSTOMER
WHERE Balance > 400;
B)SELECT DISTINCT RepName,CustName
FROM SALESREP,CUSTOMER
WHERE Balance > 400;
C)SELECT *
FROM SALESREP,CUSTOMER
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo
AND Balance > 400;
D)SELECT RepName,CustName
FROM SALESREP,CUSTOMER
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo
AND Balance > 400;
E)SELECT RepName,CustName
FROM SALESREP,CUSTOMER
WHERE Balance > 400
GROUP BY SalesRepNo;

Accepted Answer

Option A would return all columns from both tables, which is not specified in the requirement. 
Option B uses the DISTINCT keyword unnecessarily and omits the join condition.
Option C returns all columns, which is not specified in the requirement.
Option D is correct because it selects only the required columns and includes the join condition and filter condition necessary to satisfy the requirement. 
Option E uses the GROUP BY clause unnecessarily and doesn't include the join condition.

Question 20

Explain why it is important to learn SQL.

Accepted Answer

The answer of Explain why it is important to learn...

Quiz 2: Introduction to Structured Query Language SQL

The following database will be used in this question: GENERAL SALES DATABASE: SALESREP CUSTOMER Explain the use of the SQL keyword LIKE.Include an example based on the CUSTOMER table from the General Sales database.

What is SQL?

In an SQL query,which SQL keyword is used to specify the names of tables to be joined?

The following database will be used in this question: GENERAL SALES DATABASE: SALESREP CUSTOMER Explain the use of the of SQL keyword SELECT.Include an example based on the CUSTOMER table in the General Sales database.

When one SQL query is embedded in another SQL query,the first SQL query can still contain an SQL ________ clause.

Regarding the interchangeability of subqueries and joins,

When one SQL query is embedded in another SQL query,the second SQL query is embedded in the ________ of the first query.

In an SQL query,which SQL keyword is used with built-in functions to group together rows that have the same value in a specified column?

In an SQL query,which built-in function is used to compute the number of rows in a table?

Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate) ,which of the following is not a valid ANSI SQL command?

Briefly describe subqueries and joins.Explain when each is not an acceptable alternative for the other.

Based on the tables below,which of the following ANSI SQL commands would return the average customer balance grouped by SalesRepNo? GENERAL SALES DATABASE: SALESREP CUSTOMER

In an SQL query,which SQL keyword is used with GROUP BY to select groups meeting specified criteria?

In an SQL query of two tables,which SQL keyword indicates that we want data from all the rows of one table to be included in the result,even if the row does not correspond to any data in the other table?

In an SQL query,which SQL keyword is used to implement a subquery?

When one SQL query is embedded in another SQL query,this is referred to as a ________.

In an SQL query,the built-in function COUNT works with columns containing data of which of the following data types?

In an SQL query,which SQL keyword is used to specify the column names to be used in a join?

Based on the tables below,which of the following commands in ANSI SQL would return only the name of the sales representative and the name of the customer for each customer that has a balance greater than 400? GENERAL SALES DATABASE: SALESREP CUSTOMER

Explain why it is important to learn SQL.