What are three facts about backups with mysqldump?（）

A

Can back up a remote database server

B

Allow a consistent backup to be taken

C

Are always faster to restore than binary backups

D

Are able to back up specific items within a database

E

Create automatically compressed backups

F

Will lock all storage engines for duration of backup

相关问题推荐

• How would the system administrator find information regarding smit menu definitions？（）

  A、Use ODM commands

  B、Use LVM commands

  C、In the /etc/environment file

  D、In the /usr/lib/smit/menu.cfg file

  查看答案

• A system administrator has determined that the /development filesystem needs to be changed from JFS to JFS2 to take advantage of the new capabilites available in JFS2. What is the method to convert the /development filesystem from type JFS to JFS2？（）

  A、Umount the /development filesystem and remount it using the following command： mount -t jfs2 /development

  B、Edit the /etc/filesystems file to change the type paramter to jfs2 and change the log parameter to jfs2log

  C、Backup the /development filesystem data， delete the JFS /development filesystem， create the new JFS2 /development filsystem， and restore the data to the /development filesystem

  D、Backup the /development filesystem data， change the /development filesystem using the following command，chfs -t type=jfs2 /development.then， restore the data to the /development filesystem

  查看答案

• Which two requirements would lead towards a high availability solution?（）

  A

  When uptime is critical

  B

  When data must be refactored

  C

  When application concurrency is static

  D

  When data loss is unacceptable

  E

  When application is a single point of failure

  查看答案

• Which two statements describe the behavior of the server's SQL mode?（）

  A

  The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax

  B

  The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE

  C

  The server's SQL mode can be changed at the session level with a SET SESSION sql_mode=new_value command

  D

  The server's SQL mode, when globally set on a slave server, applies to events sent from the master

  查看答案

• During system boot， the system hangs at LED 0C31. What is the first step the system administrator should take to correct the problem？（）

  A、Check system console connections

  B、Check system network connections

  C、Boot in service mode and change the bootlist

  D、Boot from the AIX installation media and mount rootvg filesystems

  查看答案