Consider the following three table to store student enrollements in different courses.Student(EnrollNo, Name)Course(CourseID, Name)EnrollMents(EnrollNo, CourseID) (EnrollNo,CourseID are primary keys)What does the following query do?SELECT S.NameFROM Student S, Course C, Enrollments EWHERE S.EnrollNo = E.EnrollNo AND C.Name = "DBMS" AND E.CourseID = C.CourseID AND S.EnrollNo IN (SELECT S2.EnrollNo FROM Student S2, Course C2, Enrollments E2 WHERE S2.EnrollNo = E2.EnrollNo AND E2.CourseID = C2.CourseID C2.Name = "OS")

• A. Name of all students who are either enrolled in "DBMS" or "OS" courses
• B. Name of all students who are enrolled in "DBMS" and "OS"
• C. Name of all students who are either enrolled in "DBMS" or "OS" or both
• D. None of the above