Introduction to SQL Questions

• COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
• SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
• The keyword LIKE can be used in a WHERE clause to refer to a range of values.
• A dynamic view is one whose contents materialize when referenced.
• The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.
• A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.
• Indexes may be created or dropped at any time.
• SQL is a programming language.
• The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.