(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

 

Slide23.JPG

Slide24.JPG
Slide25.JPG
Slide26.JPG

Go Ad-free
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science and Computer Science at Teachoo