$1\mathrm{.}0$p $3$ Consider a database with the following relational schema:

Person$($id$,$ name, address, city, gender$)$

The role Job has no privileges on the database. The DBA wants Job to have the following privileges:

Job is not allowed to insert data nor delete data from the table Person.

Jobs is not allowed to update the attribute id from the table Person, but may update all other attributes

including name and gender to support transgender rights.

Job is allowed to select all data from the table Person.

What SQL statement should the DBA execute to achieve the above?

GRANT SELECT, UPDATE $($name$,$ address, city, gender$)$ ON Person TO Job

GRANT SELECT, UPDATE ON Person TO Jo

REVOKE INSERT, DELETE, UPDATE ON Person FROM Job

REVOKE INSERT, DELETE, UPDATE$($id$)$ ON Person FROM Job

$1\mathrm{.}0$p $4$ Complete the following sentence about SQL injection:

$"$SQL injection happens whenever a web application..."

$...$ is fetching data from a database without validating the user$-$supplied malicious SQL$.$

$...$ reveals stack traces or overly informative SQL error messages to users.

$...$ maliciously acts outside their granted SQL database privileges.

$...$ sends malicious SQL code that users typed into web form fields $($like fields for their username$)$ to the database. $1\mathrm{.}0$p $5$ What is a so$-$called Column$-$store?

A RDBMS that stores data by column rather than by row

An SQL INSERT statement that only inserts one column

An SQL CREATE statement that creates a one$-$column database

An SQL UPDATE statement that only updates one column $1\mathrm{.}0$p $6$ What is a trigger?

A trigger is a statement that the DBMS executes automatically if certain database modifications occur.

The trigger is a set of system tables holding information about the database itself, for example about base tables, views, domains, constraints, and privileges.

A database trigger is the assurance of and the maintenance of the accuracy and consistency of data of its entire life$-$cycle.

A database trigger allows a query to efficiently retrieve data from a database.