Q. Consider a database name "db_name" whose attributes are intern_id (primary key), subject.
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
If these are one to one relation then what will be the output of the following MySQL statement?
SELECT intern_id
FROM db_name
WHERE subject IN (c, c++, oop, SQL);

  • (A) {5, 6}
  • (B) Perl
  • (C) {3, 4}
  • (D) Empty set
πŸ’¬ Discuss
βœ… Correct Answer: (D) Empty set
Explanation: This question is about understanding how MySQL queries work with a database and its attributes. Here's a breakdown of the concepts:
Explanation by: Ritu Singhal
This question is about understanding how MySQL queries work with a database and its attributes. Here's a breakdown of the concepts:

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
125
Total Visits
πŸ“½οΈ
2 y ago
Published
πŸŽ–οΈ
Ritu Singhal
Publisher
πŸ“ˆ
93%
Success Rate