Mysql Setup
- What is the storage size in bytes required for the MEDIUMINT datatype?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
The numeric datatypes used in MySQL vary over ranges. There are a variety of INT types in the type specification. TINYINT requires 1, SMALLINT requires 2 bytes and MEDIUMINT requires 3.
- How many options can be used to control LOCAL capability at runtime?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
At runtime, the server can be started with the ‘–local-infile’ or ‘–skip-local-infile’ options to enable or disable ‘LOCAL’ capability on the server side. It can be enabled at build time too.
- The log enabled by –relay-log-index is _____________
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
The system variable ‘time_zone’ represents the default time zone of the MySQL server. By default, this variable is set to ‘SYSTEM’ which means to use the system_time_zone setting.
- The option that supplies the pathname to root directory of MySQL installation is _____________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
The option ‘–basedir’ has the purpose to specify the pathname to the root directory of the MySQL installation. The pathname to the data directory is specified by the option ‘–datadir’.
- OS imposes per process limits on the number of open file descriptors.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
OS imposes per process limits on the number of open file descriptors. If the system makes it difficult to raise the limit, running multiple instances of the server binary is done.