SWE FINAL PREP

Question 1

Difference between TCP vs UDP?

Question 2

Difference between no SQL and SQL DB?

Question 3

What is SOLID principal?

Answer 3

Solid principle is a acronym to guide object oriented design. It is used to create systems that are modular, scalable and easy to maintaining.

S -> Single responsibility: Meaning that each class should have one responsibility.

O-> Open/Closed principle: Allowing software entities to be open for extension but closed for modification. ( Allowing entity to extend its behavior without changing source code)

L-> Liskov Substitution Principle: Which is a principle where subtypes should be substitutable for their base types.

I -> Interface Segregation Principle: Clients should not depend on interfaces they do not use

D-> Dependency Inversion: Depend on abstractions not concretions

Question 4

What is ACID principle?

Answer 4

Atomicity: Ensures all operations in a transaction are complete if not then the entire transaction is rolled back

Consistency: Ensures that a transaction bring the DB from one valid state to another

Isolation: Ensures that concurrent transactions do not affect each other’s execution

Durability: Guarantees that once a transaction is commited, it will remain, so, even if a system fails

Question 5

What is CAP Theorem?

Question 6

Difference between thread and process?

Question 7

Difference between Interpreter and Compiler

Question 8

Tell me about yourself?

Question 9

Tell me about a bug you have encounter?

Question 10

Explain the pillar of OOP

Question 11

Explain the sublanguages of SQL

Question 12

What is referential integrity?

Question 13

How to avoid hash colision?

Question 14

Difference between deep and shallow copy

Question 15

What is a race condition?

Question 16

Difference between asyncronous and syncronous programming

Question 17

Benefit of cloud computing?

Question 18

What is Data Access Object design pattern

Answer 18

It is a design pattern that abstracts and encapsulates all access to the data source. The DAO handles the CRUD operations making the code maintainable and scalable.

Question 19

What is HTTP request and reposnses

Answer 19

HTTP is a set of rules the establishes how web browsers and web servers commuicate with each other with each other

Question 20

What is TDD

Answer 20

Test driven development is a methodology where tests are written before the actual code.

Question 21

What are SQL stored procedures

Answer 21

Precompiled collections of one or more SQL statements in a DB that canexecute as a single command.

Question 22

What are REST api

Answer 22

Rest( Represents state transfer) is a architectural style for designing network applications. The api provides functions over http such as get post put patch and delete

Question 23

What is CORS

Question 24

How to keep data safe?

Question 25

Name a time you had an issue with a coworker

Question 26

Best practices for testing?

Question 27

Explain your experience in agile

Question 28

Career Goals?

Question 29

Explain Micro Services

Question 30

Authentications vs Authorization

Question 31

Explain Auth0 and JWT

Question 32

Explain how you would design a data pipeline.