In a query, Table_A is joined with Table_B based on the join criteria (Table_A.Column_1 = Table_B.Column_1). The SME in the team mentions that Table_B is the child of Table_A based on Column_1 (one-to-many relationship) and should always have value. Given these considerations, which of the following doesn't apply to this situation?

technology databases

  1. There needs to be a Foreign Key relationship between the two tables.

  2. Table_B.Column_1 shouldn't have NULL values.

  3. There should be a clustered index on Table_A.Column_1 and a non-clustered index on Table_B.Column_1.

  4. Table_B.Column_1 should be unqiue.

Show answer
Correct Option: D

Find more quizzes: