What is normalization and why do campus interviews ask for 1NF, 2NF, 3NF?
Simple meaning
Normalization organises tables to reduce duplicate data and update anomalies.
Open the full page for Why, Steps, Example and Key takeaway.
Panel-ready Java Specialist questions for freshers and experienced developers. Practice at Coding Cadre in Faridabad, or Online from Delhi NCR.
Normalization organises tables to reduce duplicate data and update anomalies.
Open the full page for Why, Steps, Example and Key takeaway.
WHERE filters rows before grouping.
Open the full page for Why, Steps, Example and Key takeaway.
DELETE removes rows and can use a WHERE clause
Open the full page for Why, Steps, Example and Key takeaway.
NULL means unknown or missing, not the integer zero or empty string.
Open the full page for Why, Steps, Example and Key takeaway.
UNION concatenates result sets and then removes duplicates, which requires a sort or hash.
Open the full page for Why, Steps, Example and Key takeaway.
A transaction is a group of SQL statements that must all commit or all roll back, so you never leave half-updated data.
Open the full page for Why, Steps, Example and Key takeaway.
REST is an architectural style for APIs over HTTP where you manipulate resources with standard verbs and URLs.
Open the full page for Why, Steps, Example and Key takeaway.
GET is safe and idempotent: it reads a resource and must not change server state beyond logging.
Open the full page for Why, Steps, Example and Key takeaway.
PUT replaces the whole resource at that URL and is idempotent.
Open the full page for Why, Steps, Example and Key takeaway.
200 OK means the request succeeded and usually includes a body.
Open the full page for Why, Steps, Example and Key takeaway.
400 is a bad request: malformed JSON or failed validation.
Open the full page for Why, Steps, Example and Key takeaway.
500 Internal Server Error means your code or an unexpected dependency failed.
Open the full page for Why, Steps, Example and Key takeaway.
A path parameter identifies a resource, like /users/17.
Open the full page for Why, Steps, Example and Key takeaway.
Repeating the same GET must not change resource state
Open the full page for Why, Steps, Example and Key takeaway.
Authentication proves who you are, for example login with password or OTP.
Open the full page for Why, Steps, Example and Key takeaway.
After login the server stores session data in memory or Redis and sends a session id in a Set-Cookie header.
Open the full page for Why, Steps, Example and Key takeaway.
A JSON Web Token is a signed string with a header, payload, and signature, often used as a bearer access token.
Open the full page for Why, Steps, Example and Key takeaway.
Hashing is one-way: even the server should not be able to recover the original password.
Open the full page for Why, Steps, Example and Key takeaway.
Spring Boot is opinionated Spring: starters, auto-configuration, and an embedded Tomcat so you can ship a fat JAR.
Open the full page for Why, Steps, Example and Key takeaway.
A bean is an object whose lifecycle Spring manages: create, inject dependencies, destroy.
Open the full page for Why, Steps, Example and Key takeaway.