لغة الاستعلام ..3

retrieves information from the database.

• Database backup procedures
• User authentication

• database

• SELECT statement

in SELECT statement, you can use the following capabilities

• filter data

• Joining

• sort data

• Selection

• Projection

Choose the columns in a table that are returned by a query. Choose as few or as many of the columns as needed.

• Projection

• Selection

• Joining

Bring together data that is stored in different tables by specifying the link between them.

• Projection

• Selection

• Joining

Choose the rows in a table that are returned by a query.

• Projection

• Selection

• Joining

You can Choose as few or as many of the columns as needed.

• True

• False

You cann't Choose as few or as many of the columns as needed.

• True

• False

Various criteria can be used to restrict the rows that are retrieved.

• True

• False

Various criteria cann't be used to restrict the rows that are retrieved.

• True

• False

a SELECT statement must include the following:

• 'SELECT' clause and 'FROM' clause

• SELECT and ORDER BY
• SELECT and GROUP BY
• SELECT and WHERE