SQL Q.18

18A relational database contains two tables student and department in which the student table has columns (roll_no, name, and dept_id )and the department table has columns (dept-id and dept-name).
The following insert statements were executed successfully to populate the empty tables:
Insert into department values (1, 'Mathematics');
Insert into department values(1, 'Physics');
Insert into department values(1, 'Navin', 1);
Insert into student values (2, 'Ravi', 2);
Insert into student values (3, `Gitu', 1);
How many rows and columns will be retrieved by the following SQL, statement?
Select * from student, department:

Option : D
Explanation :

Forgot your password?

I agree with the Terms.