1.

(i) Which command is used to view the list of tables in a database?(ii) Give one point of difference between an equi-join and a natural join.

Answer»

(i) SHOW TABLES:

(ii) Equi- join: 

  •  The join in which columns from two tables are compared for equality 
  •  Duplicate columns are shown Natural Join 
  • The join in which only one of the identical columns existing in both tables is present 
  •  No duplication of columns


Discussion

No Comment Found

Related InterviewSolutions