13
QuizMultiple Choice

Unit Test — Unit test

Question 13 • FT Business and Technology B IC – 76

Which option is typically only used when utilizing self joins?

Answer
A
display name
B
alias
C
relationship
D
primary key

Explanation

A self join uses the same table more than once in a query, so each instance needs a distinct alias to tell them apart. Therefore, the correct choice is alias. Aliases can also be used in other queries, but they are especially necessary to distinguish copies of a table in a self join.

AI-written and checked against the verified answer.

Previous
Next