Top SQL Interview Questions with Answers

Q: Explain the difference Between a Primary Key and a Foreign key in a relational database.

[{"selector":"#anim-d3c622fc-abc4-4875-9840-f9ef381ad1b6","keyframes":{"transform":["translate3d(-114.0625%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ac3deb89-4dd1-4a05-9f72-38da2e29f5c4","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4da0afc2-2d13-4d23-b04b-06f56464f6d0","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-3233a557-b63b-45b4-a024-c402a5d54681 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":500,"fill":"forwards"}]

Q: what is a join in SQL, and what are the different types of Joins?

[{"selector":"#anim-82e80a15-8b55-4950-992a-5d086237126e [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":500,"fill":"forwards"}] [{"selector":"#anim-c9559c06-e07c-436a-bdaf-804802b029ff","keyframes":{"transform":["translate3d(-114.0625%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7991676e-3ffd-4648-aa17-c705e55557b5","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3c6bc7ac-9ad5-40fb-a833-3f214d296407","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

Q: What is a view?

[{"selector":"#anim-7385f3a6-47f9-41ff-a2e7-78502bab4b65","keyframes":{"transform":["translate3d(-113.75%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-db153b11-8854-4924-8995-49012b9d3267","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-96d09253-9e07-4ce8-bad8-7510abe6a5fb","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-b23aac6e-cc2d-4f30-a073-a9e550531471 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":500,"fill":"forwards"}]

Q: What is a stored procedure?

[{"selector":"#anim-7048b655-ba14-4a02-ac17-4122132083b8 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":500,"fill":"forwards"}] [{"selector":"#anim-4628f991-75bf-4848-96bd-6e188a4aea51","keyframes":{"transform":["translate3d(-113.75%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-069e4b7e-9936-4719-b8bc-0ac40b50eefc","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-55704f61-a2e2-494d-8026-73de7261f05f","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

Q: What is a trigger?

[{"selector":"#anim-b521190a-c0d3-4579-b92b-5cf09d9b2ea5 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":500,"fill":"forwards"}] [{"selector":"#anim-66191c6b-6380-4031-bdfd-07cd6fb45832","keyframes":{"transform":["translate3d(-113.75%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ef994b19-2755-4eb0-9f1f-f71524bb294b","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-858390c3-0d1f-4b13-89bb-dd5ba1f4c1b1","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

Q: What is a group by clause?

[{"selector":"#anim-86aeb77f-5410-49af-9549-140534113b79 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":500,"fill":"forwards"}] [{"selector":"#anim-011c302e-af97-4825-a2a7-73e9bd1adec9","keyframes":{"transform":["translate3d(-113.75%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b94b572c-6930-495e-8060-47168b400642","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-72a201c3-6629-4779-981e-a4ed282116a2","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

Q: What is an aggregate function?

[{"selector":"#anim-dd6001c3-70bb-4e6b-bdc9-53412cc71daa [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":500,"fill":"forwards"}] [{"selector":"#anim-2823bc20-1596-44d8-a7d1-25a0eacad25f","keyframes":{"transform":["translate3d(-113.75%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2357b62f-482a-48ca-96f5-49ac871dfd67","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d570ac7a-f6ed-4f1b-a954-80390fcc0f1a","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

Q: What is a case statement?

[{"selector":"#anim-6feedfd7-46ff-4afe-9267-5074fb2d6479 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":500,"fill":"forwards"}] [{"selector":"#anim-e41f1438-e4b3-4d96-82c6-69bc73aa8a09","keyframes":{"transform":["translate3d(-113.75%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f148e6e5-a268-4dd0-ad58-1969cf3e7030","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2c33247c-f39f-4533-a336-b1eae2c15e38","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

Q: What is a full-text search?

[{"selector":"#anim-03c18dbe-e17c-402b-a5eb-746eab831cf3 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":500,"fill":"forwards"}] [{"selector":"#anim-41a8926d-a2ee-4ef2-a337-00bcacbf11f9","keyframes":{"transform":["translate3d(-113.75%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8e2905a8-bc3c-49a3-bd42-dfe4d7c125dc","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1bebe46d-29cc-47e6-a04d-f7e2abcbd262","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]