Which of the following join is also called as an 'inner-join'?
A. Non-Equijoin
B. Self-Join
C. Equijoin
D. None of these
Answer: Option C
Solution(By Examveda Team)
The join known as an 'inner-join' is also referred to as an Equijoin. An Equijoin is a type of join in SQL that combines rows from two or more tables based on a related column between them, using the equal (=) operator. It selects only the rows for which there is a match in both tables. Option C is the correct choice for the join also known as an 'inner-join.' Options A and B are different types of joins, and Option D states that none of these terms refer to an inner-join.Related Questions on Sql Miscellaneous
A. Structured Query Language
B. Structured Query List
C. Simple Query Language
D. None of these
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
A. Data Definition Language(DDL)
B. Data Manipulation Language(DML)
C. Both of above
D. None
Which operator performs pattern matching?
A. BETWEEN operator
B. LIKE operator
C. EXISTS operator
D. None of these
What operator tests column for the absence of data?
A. EXISTS operator
B. NOT operator
C. IS NULL operator
D. None of these
Join The Discussion