MySQL Database Operations
- The higher priority is ______________.
writes, reads
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
A client performing an operation that modifies a table is a writer and the client that performs a retrieval from the table is a reader. The writes have higher priority than reads.
- What is the default size of ‘max_binlog_cache_size’ system variable?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: D
The max_binlog_cache_size system variable can be used to restrict the total size used to cache a multiple-statement transaction. If transaction is larger than this it fails and rolls back.
- The metadata log is _______________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
The DDL log is also known as the metadata log. The metadata operations performed by the DDL statements. The Relay Log has the data changes received from a replication master server written in it.
- What is the log in which data changes received from a replication master server are written?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
The Relay Log has the data changes received from a replication master server written in it. The problems encountered during the starting, running or stopping of ‘mysqld’ is written in error log.
- Multiple MySQL servers can be run on the same machine.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
It is useful to run multiple servers on the same machine under certain circumstances. A new MySQL release can also be tested while leaving the current production server in place.