Statements operate on tables and relationships using selection, joins, aggregation, constraints, and transactions. The database optimizer chooses an execution plan based on indexes and statistics. Vendors share a standard core but support different extensions and operational behavior.