Quiz Complete, well Done!
In a parameter query, the
of the parameter can be changed each time the query is executed.
having
In SQL,
functions (e.g. AVG,SUM) are used to perform calculations on a set of values and return a single value.
A
clause (e.g. WHERE) in SQL is used to specify a condition for selecting rows from a table.
What is SQL injection?
Which operator is used to combine multiple conditions in SQL?
What is the purpose of a database view?
filter
The INSERT INTO statement is used to
new records into a database table.
The
function used to calculate the sum of values in a column.
How do you filter data in SQL?
What is a SELECT query?
A view is updated automatically when the underlying
are modified.
statements (e.g. IF) in SQL are used to perform different actions based on different conditions.
aggregate
The
SQL aggregate function is used to find the highest value in a column.
sort
Which SQL keyword is used to perform calculations on a set of values in a specific column?
The SQL
clause is used to sort the result set in ascending or descending order based on one or more columns.
Which keyword is used to create a derived field in SQL?
