Benedictine Hw5 Quiz BALT6201

 

our work has been saved and submitted

Written Feb 16, 2025 5:01 PM - Feb 16, 2025 5:15 PMAttempt 1 of 2

Attempt Score	20 / 20 - 100 %
Overall Grade (Highest Attempt)	20 / 20 - 100 %

Question 1

2 / 2 points

A join in which the joining condition is based on equality between values in the common columns is called a(n):

Question options:

	A)  equi-join.
	B)  unilateral join.
	C)  natural join.
	D)  both equi-join. and natural join. .

Question 2

2 / 2 points

The following code is an example of a(n):

SELECT Customer_T.CustomerID, Order_T.CustomerID,
CustomerName, OrderID
FROM Customer_T, Order_T
WHERE Customer_T.CustomerID = Order_T. CustomerID;

Question options:

	A)  equi-join.
	B)  subquery.
	C)  Full Outer JOIN.
	D)  Right Outer JOIN.

Question 3

2 / 2 points

The following code would include:

SELECT Customer_T.CustomerID,CustomerName, OrderID
FROM Customer_T LEFT OUTER JOIN Order_T ON
Customer_T.CustomerID = Order_T.CustomerID;

Question options:

	A)  all rows of the Order_T Table regardless of matches with the Customer_T Table.
	B)  all rows of the Customer_T Table regardless of matches with the Order_T Table.
	C)  only rows that match both Customer_T and Order_T Tables.
	D)  only rows that don't match both Customer_T and Order_T Tables.

Question 4

2 / 2 points

The following code would include:

SELECT Customer_T.CustomerID, Order_T.CustomerID,
CustomerName, OrderID
FROM Customer_T, Order_T
WHERE Customer_T.CustomerID = Order_T. CustomerID;

Question options:

	A)  all rows of the Order_T Table regardless of matches with the Customer_T Table.
	B)  all rows of the Customer_T Table regardless of matches with the Order_T Table.
	C)  only rows that match both Customer_T and Order_T Tables.
	D)  only rows that don't match both Customer_T and Order_T Tables.

Question 5

2 / 2 points

A join that is based upon equality between values in two common columns with the same name and where one duplicate column has been removed is called a(n):

Question options:

	A)  equi-join.
	B)  natural join.
	C)  multivariate join.
	D)  inner join.

Question 6

2 / 2 points

A join in which rows that do not have matching values in common columns are still included in the result table is called a(n):

Question options:

	A)  natural join.
	B)  equi-join.
	C)  outer join.
	D)  union join.

Question 7

2 / 2 points

The outer join syntax can apply easily to a join condition of  ________ tables.

Question options:

	A)  two
	B)  three
	C)  four
	D)  five

Question 8

2 / 2 points

A type of query that is placed within a WHERE or HAVING clause of another query is called a:

Question options:

	A)  master query.
	B)  subquery.
	C)  superquery.
	D)  multi-query.

Question 9

2 / 2 points

________ use the result of the inner query to determine the processing of the outer query.

Question options:

	A)  Correlated subqueries
	B)  Outer subqueries
	C)  Inner subqueries
	D)  Subqueries

Question 10

2 / 2 points

The following code is an example of a:

SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState,
CustomerPostalCode
FROM Customer_T
WHERE Customer_T.CustomerID =
(SELECT Order_T.CustomerID
FROM Order_T
WHERE OrderID = 1008);

Question options:

	A)  correlated subquery.
	B)  subquery.
	C)  join.
	D)  FULL OUTER JOIN.