Q8.Stored procedures with which of the following option have access privileges that are same as the MySQL user who defined the stored procedure?*1 pointSQL SECURITY DEFINERSQL SECURITY USERSQL SECURITY INVOKERSQL SECURITY CREATOR

Which command grants or removes other users’ privileges in MySQL?

Which of the following best represents a 'role' in the context of database access control?A set of database tablesA collection of SQL commandsA named group of related privilegesA database schema

Q10.Which of the following statements about stored procedures are true?*2 pointsProviding a parameter list to CREATE PROCEDURE is optionalStored procedures are case-sensitiveStored procedures cannot be imported from one database system to anotherStored procedures are saved in the table mysql.proc

Which of the following is NOT a feature of MySQL?ACID complianceSupport for NoSQL databasesTriggers and stored proceduresUser authentication and access control

1.Question 1What are categories of security controls? Select all that apply.1 pointOperationalTechnicalPrivacyManagerial2.Question 2Fill in the blank: A data _____ decides who can access, edit, use, or destroy their information.1 pointownerhandlercustodianprotector3.Question 3A writer for a technology company is drafting an article about new software features that are being released. According to the principle of least privilege, what should the writer have access to while drafting the article? Select all that apply.1 pointSoftware developers who are knowledgeable about the productThe software they are reviewingOther new software that is in developmentLogin credentials of the software users4.Question 4Which privacy regulations influence how organizations approach data security? Select three answers.1 pointGeneral Data Protection Regulation (GDPR)Infrastructure as a Service (IaaS)Payment Card Industry Data Security Standard (PCI DSS)Health Insurance Portability and Accountability Act (HIPAA)