While reviewing the MySQL error log, you see occasions where

题目
单选题
While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles in use?()
A

Activating the MySQL Enterprise thread pool plugin

B

Relocating your data and log files to separate storage devices

C

Disconnecting idle localhost client sessions

D

Implementing storage engine data compression options

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第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?()

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


参考答案:D

第2题:

You work as a database administrator for Certkiller .com. You received the following error while working on your database: ORA-01555: snapshot too old  In which situation would you receive such an error?()

  • A、You performed rollback after commit.
  • B、If a log switch occurs in your database.
  • C、Thearchiverfails to generate an archived log file.
  • D、Instance recovery fails to find one of the redo log files.
  • E、A long-running query is unable to get read-consistent image.
  • F、If you perform manual undo management operations in auto mode.

正确答案:E

第3题:

You are using tracing to diagnose run-time issues.When you look at the traces for the service in SvcTraceViewer.exe,you see what is shown in the exhibit:The exception trace is selected in SvcTraceViewer.exe. You need to interpret the trace results to determine where the error occurred and what to do next.What should you do?()

A.

B.

C.

D.


参考答案:B

第4题:

You are attempting to secure a MySQL server by using SSL encryption. On starting MySQL, you get this error: 130123 10:38:02 [ERROR] mysqld: unknown option '—ssl' What is the cause of the error?()

  • A、The — ssl level was not specified
  • B、The server was not started with the – enable–ssl-plugin option
  • C、— ssl is not a valid server option
  • D、The mysqld binary was not compiled with SSL support
  • E、The server's SSL certificate was invalid

正确答案:C

第5题:

During the installation of the cisco wcs version 4.0,an error occurs. Where would you look for the installation log,in order to learn more about this error?()

  • A、at the root of the installation drive
  • B、in the cisco wcs installation directory
  • C、on the desktop of the server
  • D、in the cisco wcs/logs directory

正确答案:C

第6题:

During the installation of the Cisco WCS version 4.0, an error occurs. Where would you look forthe installation log,in order to learn more about this error?()

  • A、at the root of the installation drive
  • B、in the Cisco WCS installation directory
  • C、on the desktop of the server
  • D、in the Cisco WCS/Logs directory

正确答案:C

第7题:

A system administrator noticed several error messages on the screen while the system was booting up; but was not able to write them down. Where should the system administrator look for the console log, assuming it is in the default location?()

  • A、/tmp/conslog
  • B、/etc/console.log
  • C、/var/adm/ras/conslog
  • D、/var/ras/console.log

正确答案:C

第8题:

While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.Which method will reduce the number of file handles in use?()

A.Activating the MySQL Enterprise thread pool plugin

B.Relocating your data and log files to separate storage devices

C.Disconnecting idle localhost client sessions

D.Implementing storage engine data compression options


参考答案:C

第9题:

A System p administrator noticed several error messages on the screen while the system was booting up; but was not able to write them down.  Where should the system administrator look for the console log, assuming it is in the default location()

  • A、/var/log/conslog
  • B、/var/log/console.log
  • C、/var/adm/ras/conslog
  • D、/var/ras/console.log

正确答案:C

第10题:

In which two cases would you perform only consistent backup?()

  • A、You are working on a database where downtime is not tolerated.
  • B、You are working on a database where downtime can be tolerated.
  • C、You are working on a database that operates in ARCHIVELOG mode.
  • D、You are working on a database that operates in NOARCHIVELOG mode.
  • E、You are working on a database where all the tablespaces are locally managed.
  • F、You are working on a database where control files and redo log files are multiplexed.
  • G、You are working on a database where control files and redo log files are not multiplexed.

正确答案:B,D

更多相关问题