Check sibling questions

(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

Are ads bothering you?

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.