Which MySQL privilege allows a user to create new databases?

• A.INSERT
• B.UPDATE
• C.CREATE
• D.DROP

Comment: *

Name: *

Email: *

Verification: *

How can you disable binary logging for a MySQL session?

• A.SET SQL_LOG_BIN = 0
• B.SET BINLOG_DISABLE = 1
• C.SET BIN_LOG = OFF
• D.SET BINLOG_LOGGING = 0

Comment: *

Name: *

Email: *

Verification: *

Which two MySQL privileges are necessary for creating and modifying user accounts?

• A.GRANT OPTION
• B.CREATE USER
• C.ALTER USER
• D.INSERT

Comment: *

Name: *

Email: *

Verification: *

Which parameter in MySQL configures the maximum number of connections that can be handled simultaneously by the server?

• A.max_threads
• B.thread_cache_size
• C.max_connections
• D.innodb_max_connections

Comment: *

Name: *

Email: *

Verification: *

Which of the following steps is necessary after installing MySQL on a Windows system?

• A.Compile the server from source code
• B.Configure server options in my.ini
• C.Set up table partitioning
• D.Install MySQL as a Linux service

Comment: *

Name: *

Email: *

Verification: *