Which two are correct steps in taking a binary backup of MyISAM tables?() A.Always stop the server prior to the backupB.Stop the server or lock the tables prior to the backupC.Stop the server or lock the databases prior to the backupD.Make a copy of the .frm, .myd, and the .myi filesE.Make a copy of the binary log and tablespace files

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

相关考题：

Whichviewprovidesinformationonthebackupstatusofthedatafilesinthedatabase?() A.V$BACKUPB.V$BACKUP_STATUSC.V$BACKUP_DATAFILED.V$DATAFILE_BACKUPE.V$TABLESPCE_BACKUP
查看答案
Which of the following NLS_SORT parameter values would result in case－insensitive and accent－insensitive binary sorts?() A. NLS_SORT = BINARYB. NLS_SORT = BINARY_AIC. NLS_SORT = BINARY_CID. NLS_SORT = BINARY_AI_CIE. Binary sorts are case insensitive and accent insensitive by default.
查看答案
Youperformdifferentialincrementallevel1backupsofyourdatabaseoneachworkingdayandlevel0backuponSundays,totape.Whichtwostatementsaretrueaboutdifferentialincrementalbackups() A.ThebackupperformedonSundayscontainsalltheblocksthathaveeverbeenusedinthedatabase.B.ThebackupperformedonSundayscontainsalltheblocksthathavechangedsincethelastlevel1backup.C.Thebackupperformedoneachworkingdaycontainsalltheblocksthathavechangedsincethelastlevel0 backup.D.ThebackupperformedonMondaycontainsalltheblocksthathavechangedsincethelevel0backup，and everyotherworkingdaycontainsalltheblocksthathavechangedsincethelevel1backup
查看答案
关于myisamchk工具,以下描述正确的有哪些?() A.它能检查MyISAM表B.它能修复MyISAM表C.它能获取MyISAM表的信息D.它能优化MyISAM表
查看答案
An administrator wants to restore the /etc/resolv.conf file from a mksysb backup onto server1. After the mksysb is mounted in /mnt/backup/ from the local nim server.Which command should be run to restore the file?（）A.tar -xvf /mnt/backup/server1.mksysb ./etc/resolv.confB.restore -Tvf /mnt/backup/server1.mksysb ./etc/resolv.confC.listvgbackup -f /mnt/backup/server1.mksysb -r ./etc/resolv.confD.restorevgfiles -xrm /mnt/backup/server1.mksysb ./etc/resolv.conf
查看答案
MyISAM表比InnoDB表数据写入速度快。（）
查看答案
MySQL8.0默认的存储引擎是MyISAM。（）
查看答案
以下______不是MySQL常用的存储引擎。A．OLAPB．OLTPC．InnoDBD．MyISAM
查看答案
1、Mysql 的存储引擎,myisam和innodb的区别。
查看答案
关于MyISAM和InnoDB引擎的表，下列说法正确的是A．MyISAM表数据更改会锁住整张表B．如果一个事务同时操作了InnoDB表和MyISAM表,那么不管是否提交,MyISAM表中的数据变化都能被别的连接看到C．InnoDB表数据更改只可能锁住要更改的行D．如果一个事务同时操作了InnoDB表和MyISAM表,那么对MyISAM的操作也可以被回滚
查看答案
热门标签