1Z0-007 Question #200: Real Exam Question with Answer & Explanation

The correct answer is E. You can join n tables (all having single column primary keys) in a SQL statement by specifying a. For N joined tables using Oracle or ANSI/ISO syntax for table joins, you need at least N-1 equijoin conditions in the WHERE clause of your SELECT statement or N-1 JOIN table_name ON join_condition clauses in order to avoid a Cartesian product, respectively. Incorrect Answers A: T

Question

What is true about joining tables through an equijoin?

Options

AYou can join a maximum of two tables through an equijoin.
BYou can join a maximum of two columns through an equijoin.
CYou specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
DTo join two tables through an equijoin, the columns in the join condition must be primary key and
EYou can join n tables (all having single column primary keys) in a SQL statement by specifying a

Explanation

For N joined tables using Oracle or ANSI/ISO syntax for table joins, you need at least N-1 equijoin conditions in the WHERE clause of your SELECT statement or N-1 JOIN table_name ON join_condition clauses in order to avoid a Cartesian product, respectively. Incorrect Answers A: There is no maximum on two tables to join them through an equijoin. B: There is no maximum on two columns to join them through an equijoin. C: You can specify an equijoin condition only in the FROM clauses of a SELECT statement. D: There is no limitation about primary key and foreign key for the columns to use them for an

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice