What is Procedure? What is Functions? What is Joins? Sub queries Constraints? Triggers Package

Question

Accepted Answer

SQL concepts - Procedure, Functions, Joins, Sub queries, Constraints, Triggers, Package

Procedure - a set of SQL statements that perform a specific task
Functions - a set of SQL statements that return a single value
Joins - used to combine rows from two or more tables based on a related column
Sub queries - a query within another query
Constraints - rules that enforce data integrity
Triggers - a set of SQL statements that automatically execute in response to certain events
Package - a collection of related procedures, functions, and other database objects

Popular interview questions of SQL Developer