【C10】A．everB．neverC．eitherD．neither

a. The stored procedure prepare_db () has 10 auditable statements.You run the following statements in the mydb database: Mysql＞ CALL prepare_db ();Mysql＞ LOAD DATA INFILE ‘/tmp/data.cav‘ INTO TABLE mytable; Mysql＞ SHOW TABLES;How many events are added to the audit log as a result of the preceding statements？（）

A.12; only top-level statements and stored procedure events are logged

B.111; top-level statements and all lower-level statements are logged

C.3; only the top-level statements are logged

D.102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event

a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error.In the audit log file, you notice the final entry:…What action should you take to fix the error and allow the service to start？（）

A.Re-install the audit plugin

B.Execute the command FLUSH LOGS

C.Execute the command SET GLOBAL audit_log_fiush= ON

D.Move or rename the existing audit.log file

iguration tile: [mysqld] Plugin-load=audit_log.so Audit-log=FORCE_PLUS_PERMANENT You attempt to start up the MySQL service and notice that it fails to start.Which two statements would explain why the service did not start？（）

A.FORCE_PLUS_PERMANENT is not valid for the audit-log option

B.The audit_log.so library does not exist

C.The audit_log.so library is in a location that is different from that defined by the plugin_dir option

D.The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command

E.The audit log file does not exist in which to write audit events

F.The audit_log.so library is not an executable file

A、An audit committee must comprise at least four independent non-executive directors.

B、Where there is no internal audit function the audit committee should consider the need for one on an annual basis.

C、The role and responsibilities of the audit committee are set out in statute.

D、Every company must have an audit committee

A. activity audit

B. administration

C. policy establishment

D. technology implementation

4 (a) The purpose of ISA 250 Consideration of Laws and Regulations in an Audit of Financial Statements is to

establish standards and provide guidance on the auditor’s responsibility to consider laws and regulations in an

audit of financial statements.

Explain the auditor’s responsibilities for reporting non-compliance that comes to the auditor’s attention

during the conduct of an audit. (5 marks)

A.File system snapshots

B.Mysqldumpslow

C.Mysqlhotcopy

D.Mysqldump with – binary-data option

E.Mysql Enterprise Backup

A.Mysql NDB Cluster

B.Mysql Replication

C.Distributed Replicated Block Device (DRBD) and Mysql

D.Windows Cluster and Mysql

E.Solaris Cluster and Mysql