CMS专题

多选题What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?（）AFile system snapshotsBMysqldumpslowCMysqlhotcopyDMysqldump with – binary-data optionEMysql Enterprise Backup

题目
多选题
What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?（）
A

File system snapshots

B

Mysqldumpslow

C

Mysqlhotcopy

D

Mysqldump with – binary-data option

E

Mysql Enterprise Backup

如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

The following commands are available in the Linux binary distributions of Mysql: Mysqld Mysqld_safe Mysql.server What is the correct description of each of these commands?()

A.A

B.B

C.C

D.D


参考答案：A

第2题：

Which two are correct steps in taking a binary backup of MyISAM tables?()

A.Always stop the server prior to the backup

B.Stop the server or lock the tables prior to the backup

C.Stop the server or lock the databases prior to the backup

D.Make a copy of the .frm, .myd, and the .myi files

E.Make a copy of the binary log and tablespace files


参考答案：B, D

第3题：

You are managing a 24*7 database. The backup strategy for the database is to perform user－managed backups. Identify two prerequisites to perform the backups.()

A. The database must be opened in restricted mode.

B. The database must be configured to run in ARCHIVELOG mode.

C. The tablespaces are required to be in backup mode before taking the backup.

D. The tablespaces are required to be in read-only mode before taking the backup


参考答案：B, C

第4题：

Which two are correct steps in taking a binary backup of MyISAM tables?（）

  • A、Always stop the server prior to the backup
  • B、Stop the server or lock the tables prior to the backup
  • C、Stop the server or lock the databases prior to the backup
  • D、Make a copy of the .frm, .myd, and the .myi files
  • E、Make a copy of the binary log and tablespace files

正确答案:B,D

第5题：

What are two valid Cluster load balancing methods? ()(Choose two.)

A. urlhash

B. backup chaining

C. least connections

D. fewest outstanding requests


参考答案：A, D

第6题：

You are managing a 24*7 database. The backup strategy for the database is to perform user－managedbackups.Identify two prerequisites to perform the backups. (Choose two.)()

A. The database must be opened in restricted mode.

B. The database must be configured to run in ARCHIVELOG mode.

C. The tablespaces are required to be in backup mode before taking the backup.

D. The tablespaces are required to be in read-only mode before taking the backup


参考答案：B, C

第7题：

What are four capabilities of the mysql client program?()

A.Creating, dropping, and modifying tables and indexes

B.Initiating a binary backup of the database by using the START BACKUP command

C.Displaying replication status information

D.Shutting down the server by using the SHUTDOWN command

E.Creating and dropping databases

F.Creating and administering users


参考答案：A, C, E, F

第8题：

Which two are true regarding MySQL binary and text backups?()

A.Binary backups are usually faster than text backups

B.Binary backups are usually slower than text backups

C.Text backups are human-readable while binary backups are not

D.Binary backups are not portable across different operating systems


参考答案：A, C

第9题：

What are two valid Cluster load balancing methods? （）(Choose two.)

  • A、urlhash
  • B、backup chaining
  • C、least connections
  • D、fewest outstanding requests

正确答案:A,D

第10题：

Weekly backups of the system are done on Sundays， and daily backups are done the rest of the week.  Which of following backup methods were used if the system crashes on Friday and only requires two backup sets to recover the system？（）

  • A、 Incremental and snapshot
  • B、 Full and differential
  • C、 Full and incremental
  • D、 Differential and incremental

正确答案:B

更多相关问题
相关内容