Data Management Specialist Interview Questions and Answers

A table is a collection of data organized in rows and columns, while a view is a virtual table derived from one or more tables.

• Tables store actual data, while views store queries that retrieve data from tables.

• Tables can be modified directly, while views are read-only.

• Tables have physical storage, while views do not.

• Tables can have indexes and constraints, while views cannot.

• Tables are used to store and manage data, while views are used to simplify complex queries or provide ...read more

Different types of Joins

• Inner Join: Returns only the matching rows from both tables

• Left Join: Returns all the rows from the left table and the matching rows from the right table

• Right Join: Returns all the rows from the right table and the matching rows from the left table

• Full Outer Join: Returns all the rows from both tables, including the unmatched rows

• Cross Join: Returns the Cartesian product of both tables