(i) Which command is used to view the list of tables in a database?
Answer
SHOW TABLES;
(ii) Give one point of difference between an equi-join and a natural join.
Answer
Equi Join |
Natural Join |
The join in which columns from two tables are compared for equality |
The join in which only one of the identical columns existing in both tables is present |
Duplicate columns are shown |
No duplication columns shown |