SQL Interview Questions Every Fresher Should Know

What is SQL:?

[{"selector":"#anim-0e799a14-9395-4ba6-abc2-d6639474ae73","keyframes":{"transform":["translate3d(-125.36232%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ab1c3b69-4193-433e-a79d-db9405a3620b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e503b4d6-940b-48f0-9290-9f671aa5dab5","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-b7d3d57b-d55a-4d17-a8ee-c44a3c4e22cd","keyframes":{"transform":["translate3d(124.01433%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-81ee2542-e2e3-4d32-a686-4206a007f845","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-dcb3fdc0-584a-46f6-9707-553a588c9154","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] Explain that SQL (Structured Query Language) is used to store, retrieve, update, and manage data in relational databases.

What is the Difference Between WHERE and HAVING?

[{"selector":"#anim-cfb1ca53-7f47-49f5-bd8c-5627c312fedc","keyframes":{"transform":["translate3d(108.49859%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5bdb84be-d4b2-41a9-a34f-5985fce72e82","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-628e84f1-12cd-4b19-a260-7eacb992cc2c","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-e37c67a9-f5cc-456b-b44c-1f00d98d896e","keyframes":{"transform":["translate3d(-113.04347%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3795ea1c-bf21-48f2-a9b6-0f324b569597","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-789c8f63-f35a-442c-9c05-3ed6b1af7de2","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] WHERE filters rows before grouping, while HAVING filters grouped data after aggregate functions are applied.

Explain SQL JOIN Types

[{"selector":"#anim-77c87ae9-df5e-4470-a19b-464b4d81e057","keyframes":{"transform":["translate3d(-108.19208%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8f7727de-df44-43b4-81bc-753c804820ad","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-468e25f5-60f3-48b6-8a20-cd202333ec69","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-bc930e8a-72ff-4df5-8f8d-4090c6bae8fc","keyframes":{"transform":["translate3d(107.95455%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a0750cc1-026b-466d-b66b-2033143c4ea5","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a88fda20-e5ca-4bcf-9be9-0ada88c2fad2","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] Learn the purpose of INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN to combine data from multiple tables.

What are a Primary Key and a Foreign Key?

[{"selector":"#anim-19d3c6e7-55c1-4da5-80fb-a1d110ed581c","keyframes":{"transform":["translate3d(107.12329%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3e4060e5-f4ae-4e4b-be38-559a3d35e329","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0b419de0-2609-4297-af7e-6c853cde6181","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-13485d33-24b5-4e93-97f2-bc21fffff946","keyframes":{"transform":["translate3d(-106.62983%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2ea6e19e-cbff-440b-b4b4-c1bc7d147fca","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8e5b97c6-a2d6-4679-a931-28def8d80a32","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] Understand how primary keys uniquely identify records and foreign keys create relationships between database tables.

Crack Your SQL Interview

[{"selector":"#anim-6ab1450c-c4da-4f37-a0ea-f54a9be14095","keyframes":{"transform":["translate3d(-107.62712%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-06f10c30-9001-4359-a44c-611da4a8b765","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5c76e1fa-1dcc-4006-9325-968f3a8e4e47","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-2fc4bdae-d281-4218-a1be-1134125e11bc","keyframes":{"transform":["translate3d(108.88252%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d91a18e1-a38d-4f42-9fcc-68ef4543f81e","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0f9c0bc4-dc0c-4ffa-8bde-157728305fbc","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] Join CBITSS Chandigarh to strengthen your SQL concepts, solve real interview questions, and build confidence for technical interviews.

Practice SQL with CBITSS Chandigarh

[{"selector":"#anim-9c3ed243-98a6-4318-a988-157b8012981a","keyframes":{"transform":["translate3d(106.57535%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-de155708-0c2b-4642-b655-572caa3ae6c8","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5a26b33e-1790-447c-aa30-2d8cc1e65df8","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-7d4532dd-ede2-4972-a443-256c3ec31f5b","keyframes":{"transform":["translate3d(-109.2219%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-971484c1-1c3b-44f7-94da-92cf5e8f9b4a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9288b926-6c16-4b88-9690-43f4f492d20c","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] Master SQL queries, joins, subqueries, aggregate functions, and interview preparation through practical training at CBITSS Chandigarh.