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 .f

题目
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

相似考题

1.Whichviewprovidesinformationonthebackupstatusofthedatafilesinthedatabase?()A.V$BACKUPB.V$BACKUP_STATUSC.V$BACKUP_DATAFILED.V$DATAFILE_BACKUPE.V$TABLESPCE_BACKUP

2.Youperformdifferentialincrementallevel1backupsofyourdatabaseoneachworkingdayandlevel0backuponSundays,totape.Whichtwostatementsaretrueaboutdifferentialincrementalbackups()A.ThebackupperformedonSundayscontainsalltheblocksthathaveeverbeenusedinthedatabase.B.ThebackupperformedonSundayscontainsalltheblocksthathavechangedsincethelastlevel1backup.C.Thebackupperformedoneachworkingdaycontainsalltheblocksthathavechangedsincethelastlevel0 backup.D.ThebackupperformedonMondaycontainsalltheblocksthathavechangedsincethelevel0backup，and everyotherworkingdaycontainsalltheblocksthathavechangedsincethelevel1backup

3.关于myisamchk工具,以下描述正确的有哪些?()A.它能检查MyISAM表B.它能修复MyISAM表C.它能获取MyISAM表的信息D.它能优化MyISAM表

4.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.

更多“Which two are correct steps in taking a binary backup of MyISAM tables?() ”相关问题

  • 第1题：

    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.conf

    B.restore -Tvf /mnt/backup/server1.mksysb ./etc/resolv.conf

    C.listvgbackup -f /mnt/backup/server1.mksysb -r ./etc/resolv.conf

    D.restorevgfiles -xrm /mnt/backup/server1.mksysb ./etc/resolv.conf


    参考答案：C

  • 第2题：

    MySQL8.0默认的存储引擎是MyISAM。（）


    B

  • 第3题：

    1、Mysql 的存储引擎,myisam和innodb的区别。


    MyISAM不支持事务

  • 第4题：

    MyISAM表比InnoDB表数据写入速度快。（）


    A

  • 第5题：

    以下______不是MySQL常用的存储引擎。

    A．OLAP

    B．OLTP

    C．InnoDB

    D．MyISAM


    MyISAM##%_YZPRLFH_%##myisam##%_YZPRLFH_%##MyIsam##%_YZPRLFH_%##Myisam

  • 第6题：

    关于MyISAM和InnoDB引擎的表，下列说法正确的是

    A．MyISAM表数据更改会锁住整张表

    B．如果一个事务同时操作了InnoDB表和MyISAM表,那么不管是否提交,MyISAM表中的数据变化都能被别的连接看到

    C．InnoDB表数据更改只可能锁住要更改的行

    D．如果一个事务同时操作了InnoDB表和MyISAM表,那么对MyISAM的操作也可以被回滚


    MyISAM表数据更改会锁住整张表;如果一个事务同时操作了InnoDB表和MyISAM表,那么不管是否提交,MyISAM表中的数据变化都能被别的连接看到

相关内容