A relational database contains two tables student and department in which student table has columns (roll_no, name and dept_id )and 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 retrived by the following SQL, statement?
Select * from student, department;
| A. | 0 row and 4 columns |
| B. | 3 rows and 4 columns |
| C. | 3 rows and 5 columns |
| D. | 6 rows and 5 columns |
Answer : D Explanation : Hiren MEr said: (6:07pm on Tuesday 6th September 2016)
Insert into department values(1, 'Navin', 1);How this statement can insert the data
|
|
|
Option: A Explanation : Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. |
