Modern Database Management Study Set 2

Computing

Quiz 6 :

Advanced SQL

Quiz 6 :

Advanced SQL

Question Type
search
arrow
A type of join between three tables is called a(n):
Free
Multiple Choice
Answer:

Answer:

A

Tags
Choose question tag
close menu
arrow
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;
Free
Multiple Choice
Answer:

Answer:

C

Tags
Choose question tag
close menu
arrow
The most commonly used form of join operation is the:
Free
Multiple Choice
Answer:

Answer:

D

Tags
Choose question tag
close menu
arrow
A join operation:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
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;
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A join in which the joining condition is based on equality between values in the common columns is called a(n):
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
One major advantage of the outer join is that:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The UNION clause is used to:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
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):
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A ________ is a temporary table used in the FROM clause of an SQL query.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The ________ operator is used to combine the output from multiple queries into a single result table.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
All of the following are guidelines for better query design EXCEPT:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
In which of the following situations would one have to use an outer join in order to obtain the desired results?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The outer join syntax does not apply easily to a join condition of more than ________ tables.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
In order for two queries to be UNION-compatible, they must:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The following code would include: SELECT Customer_T.CustomerID,CustomerName, OrderID FROM Customer_T RIGHT OUTER JOIN Order_T ON Customer_T.CustomerID = Order_T.CustomerID;
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
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;
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
An operation to join a table to itself is called a(n):
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
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):
Multiple Choice
Answer:
Tags
Choose question tag
close menu
Showing 1 - 20 of 95