Question 1

You adjust a default configuration to the following /etc/my.cnf on a Linux installation:

[mysqld]

Loq-bin

Binrylog_format=ROW

You do not notice the spelling error in binrylog_format and restart your production server.

How does the MySQL server behave with incorrectly spelled options?

Options :

A : Mysqld uses internal configuration versioning and reverts to the previous configuration.

B : When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes.

C : The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes.

D : Mysqld prints to the error log about an unknown variable, and then exits.

Answer: D

Question 2

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.

Which two conditions must be true? (Choose two.)

Options :

A : Each extra column in the copy with more columns must not have a default value.

B : Columns that are common to both versions of the table must be defined in the same order on the master and the slave.

C :

The slave database cannot have more columns than the master. Only the master database can have more columns.

D : Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server.

E : The master database cannot have more columns than the slave. Only the slave deatbase can have more columns.

Answer: B,D

Question 3

Which three are properties of the MyISAM storage engine? (Choose three.)

Options :

A : Transaction support

B : FULLTEXT indexing for text matching

C : Table and page level locking support

D : Foreign key support

E : Geospatial indexing

F : HASH index support

G : Table level locking only

Answer: A,B

Question 4

Which statement is true about FLUSH LOGS command?

Options :

A : It requires the RELOAD, FILE, and DROP privileges.

B : It closes and reopens all log files.

C : It closes and sends binary log files to slave servers.

D : It flushes dirty pages in the buffer pool to the REDO logs.

Answer: B

Question 5

User bob@% has the following roles granted: app_read and app_write.

How would you show the privileges for bob@% when it uses app_write? (Choose one).

Options :

A : SHOW GRANTS FOR bob@'%';

B : SHOW GRANTS FOR bob@'%' USING 'app_write';

Answer: B

Confidently Practice Online with Free 1Z0-908 Exam Cram

Buying Options: