Question

Which statement can be detected by monitoring of access to sensitive data?

O UPDATE quarter_reference set Q1='012022'
O CREATE index emp_id_idx on EMPLOYEES(emp_id);
O SELECT * from EMPLOYEES;
O SELECT SYSDATE from DUAL;

Answer 1

The SQL query 'SELECT * from EMPLOYEES' can be detected by monitoring systems as it accesses sensitive data from the EMPLOYEES table, potentially containing confidential information.

Step-by-step explanation:

The statement that can be detected by monitoring of access to sensitive data is SELECT * from EMPLOYEES. This SQL query is requesting all of the information from the EMPLOYEES table, which could contain sensitive employee data such as personal identifiers, salaries, or other confidential information. Monitoring systems set to detect access to sensitive data would likely flag this type of query for review to ensure that the data access is authorized and appropriate within the given context.

The other SQL statements provided, such as UPDATE quarter_reference set Q1='012022', CREATE index emp_id_idx on EMPLOYEES(emp_id), and SELECT SYSDATE from DUAL, do not directly access sensitive data. The UPDATE statement changes data in a different table, the CREATE INDEX statement is used for performance tuning, and accessing SYSDATE from DUAL merely fetches the current system date from a dummy table.