MGSC 394 Quiz 4

Expression SQL term

Combination of identifiers, operators, constants and functions that evaluates to a single value

Rules of SQL syntax

Every statement ends with a semi-colon (;) Has clauses Each clause performs a function

Operator SQL term

Keyword that represents an action or modifies an action

Select SQL clause

List the fields that contain data or interest Required in each SQL

From SQL clause

Lists the tables that contain the fields listed in the select clause Required in each SQL

Identifiers with spaces

Must be enclosed in square brackets

Constant SQL term

Value that does not change, such as a number or NULL

SQL syntax

A set of rules that define how elements of a language are correctly combined

What does a wildcard do (*)

Allows you to include all fields from a data source

Identifier SQL term

Name used to identify a database object Name of a field or table

Multiple identifiers in a clause

Need a comma between them

Is SQL case sensitive?

No, but can be used to improve readability

What is Structured Query Language?

Programming language designed specifically for managing data held in relational database management systems

Group By SQL clause

SQL statement that lists fields that are not summarized in the select clause

Having SQL clause

Specifies conditions that must by fields that are summarized in the select statement

Where SQL clause

Specifies field criteria that must be met by each record to be included

Order by SQL clause

Specifies how to sort the results

Inner Join On SQL Clause

Specifies the of join and the linking fields

What does SQL stand for?

Structured Query Language

Why should you learn SQL?

Understanding it can help you create better queries and fix a query that is not returning desired results

Does access ignore line breaks?

Yes, and line breaks should be used to improve readability

Can you use SQL in programs outside of access?

Yes, is an international standard that can be used in other programs