(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

Remove Ads
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh is an IIT Kanpur graduate and has been teaching for 16+ years. At Teachoo, he breaks down Maths, Science and Computer Science into simple steps so students understand concepts deeply and score with confidence.

Many students prefer Teachoo Black for a smooth, ad-free learning experience.