✅ Table Full Scan read all blocks in table to find data used for database optimization, optimizing query 👎🏻 can affect database performance if the table is big, query is complex ✅ Index R...

✅ Schema define database structure and constraints logical representation of data shows how data in DB should be stored logically attribute: characteristic of entity entity: collectio...

✅ NoSQL unrelational DB not only SQL can use query language depending on API/DB/query 👍🏻 scalability 👍🏻 availability 👍🏻 data is saved according to how application is used 👍...

✅ ORM Object Relational Mapping Map object and relational DB automatically save burden to code SQL Object oriented programming: use class Relational DB: use table thus, there ...

✅ Partitioning divide big table into small several tables 👍🏻 improve query performace data is physically divided into seperate tables but user can access the data as if it is on ...

✅ 모의면접 스터디를 신청하고 시작하게 된 계기 네트워크 지식 향상 면접 태도 개선 학습에 대한 강제성, 부담 부여 ✅ 스터디를 마무리하며 성장한 점, 느낀점 같이 공부하면 어느정도 부담이 있지만, 또 그만큼 열심히 하게 된다. 나는 함께 공부하는 습관이 어느정도 강제성도 부여해주고, 잘 맞는 것 같다. ✅ Feedba...

✅ Starvation resource management problem process priority is low process is never allocated resource priority is low: came late, takes long time… 💡 How to prioritize proc...

📌 Web application security ✅ How did you ensure the security of sensitive data in the “Aplicación Web HTTPS TLS/SSL CA: Let's encrypt Nginx use symmetric, assymetric key ✅ Can you explain how H...

✅ Page Replacement Algorithm in OS that uses paging for memory management which page should be replaced when a new page comes in used 1️⃣ when page fault occurs and 2️⃣ there is no free pag...

📌 IP address ✅ What is IP address? - address for each device connected to network ✅ Two parts of IP address? - network part ➕ host part - network part가 같다면 같은 네트워트 ➡️ switch, bridge,...