mysql8.0英文OCP考试第61-70题

Q61.You wish to protect your MySQL database against SQL injection attacks.

Which method would fail to do this?

A)using stored procedures for any database access

B)using PREPARED STATEMENTS

C)installing and configuring the Connection Control plugin （ slow down brute force attacks）

D)avoiding concatenation of SQL statements and user-supplied values in an application

Answer:C

Q62.Which two statements are true about MySQL server multi-source replication?

A)It relies on relay_log_recovery for resilient operations.   

B)It does not attempt to detect or resolve replication conflicts.

C)It needs to be re-instanced after a crash to maintain consistency.

D)It is not compatible with auto-positioning.

E)It must use GTID replication.

F)It uses only time-based replication conflict resolution.

Answer:AB

Q63.You are using an existing server with a new configuration. MySQL Server fails to start. Examine this snapshot of the error log:

190925 12：49:05 InooDB;  Initializing buffer pool,size=3.0G

190925 12：49:05 InooDB;  Completed Initializing of buffer poo

InnoDB:Error:log file ./ib_logfiiel0 is of different size 0 5242880 bytes

InnoDB than specified in the .cnf fiel 0 26214400 bytes 1

190925 12:49:05 [ERROR] Plugin ‘InnoDB’ init  function returned error.

190925 12:49:05 [ERROR] Plugin ‘InnoDB’registation as a STORAGE PNGINR failed

190925 12:49:05 [ERROR] Plugin ‘Aborting

190925 12:49:05 [ERROR] Plugin ‘/usr/sbin/mysqld:Shutdown complete

Which action would allow the server to start?

A)Remove ib_logfile0 and ib_logfile1 files from the file system.

B)Execute mysqladmin flush-logs