What to expect from the Database section when walking into a Data Analyst interview
Q : What do you mean by DBMS?
A : Database Management System (DBMS) is a software application that interacts with the user, applications and the database itself to capture and analyze data. The data stored in the database can be modified, retrieved and deleted.
Q : What is Normalization?
A : Normalization is the process of organizing data to avoid duplication and redundancy. There are many successive levels of normalization. These are called normal forms.
Q : What is ACID property in a database?
A : ACID is an acronym for Atomicity, Consistency, Isolation, and Durability. This property is used in the databases to ensure whether the data transactions are processed reliably in the system or not.
Q : What are the different types of Joins?
A : The various types of joins used to retrieve data between tables are Inner Join, Left Join, Right Join and Full Outer Join.
Q : What is an SQL View?
A : A view is a virtual table whose contents are obtained from an existing table or tables, called base tables. The retrieval happens through an SQL statement, incorporated into the view. The view itself does not contain any real data.
Tweet thread version of the blog:
Follow for more!