Question

In a registration database, Ross has tables for student, professor, classroom, class, class-hour. Since his campus has about 12,000 students, when he runs queries about what student is in what class, taught by what professor in what classroom at which hour, the DBMS software will have to perform many _________
a)Axes
b)Parallels
c)Concretes
d)Joins
e)Enrolls

Answer 1

Answer:

The correct answer for the given question is option(d) i.e " joins ".

Explanation:

Joins are used in the database to combining the two or more than two tables.The data base management system (DBMS) performing the joining queries to combine the student, professor, classroom, class, class-hour tables.The join connected the two or more table by matching the columns between the tables .

Their are many types of joining in the database.

1.  Inner join.

2. Outer join .

3. Left join.

4. Natural join.