Advertisements
Advertisements
प्रश्न
Consider the following tables – LOAN and BORROWER:
Table: LOAN
| LOAN_NO | B_NAME | AMOUNT |
| L-170 | DELHI | 3000 |
| L-230 | KANPUR | 4000 |
Table: BORROWER
| CUST_NAME | LOAN_NO |
| JOHN | L-171 |
| KRISH | L-230 |
| RAVYA | L-170 |
How many rows and columns will be there in the natural join of these two tables?
लघु उत्तरीय
उत्तर
Rows: 2
Columns: 4
Explanation:
In a natural join, only the common row of the same field will be displayed; the common field is not repeated.
shaalaa.com
Using Two Relations in Query
क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
APPEARS IN
संबंधित प्रश्न
Which of the following join selects all rows from both the tables as long as the condition satisfies?
A ______ is a join of every row of one table to every row of another table.
In MYSQL database, if a table, Alpha has degree 5 and cardinality 3, and another table, Beta has degree 3 and cardinality 5, what will be the degree and cardinality of the Cartesian product of Alpha and Beta?
