Quiz Complete, well Done!
In SQL,
statements (e.g., IF, CASE) are used to perform different actions based on different conditions.
Injection attacks
What is a SELECT query?
sort
Which of the following is true about views?
The
SQL aggregate function used to find the first value in a column.
In SQL, the
operation is used to arrange the rows of a result set in a specific order.
Which of the following is used to pass input values to a SQL parameter query?
subquery
What is the syntax for creating a derived field in SQL?
The
SQL aggregate function used to calculate the average of a column.
How do you filter data in SQL?
A database view is a
table that is based on the result of a query.
limit
The
function is used to calculate the total number of unique values in a column.
Why do attackers use SQL injection?
10. The SQL function used to sort records in ascending order is
.
A
clause (e.g. WHERE) in SQL is used to specify a condition for selecting rows from a table.
Which SQL keyword is used to update data in a database table?
conditional
