The safer , easier way to help you pass any IT exams.
11 / 61
A. Use the LIMIT clause to limit the deletion to 100,000 rows.
B. Change the replication mode to MIXED before issuing any delete statements when the LIMIT clause is
used.
C. Use the LIMIT clause in conjunction with the ORDER BY clause.
D. 11 the data modification is non-deterministic, the query optimizer will resolve any potential issues.
Answer:BC
31.Data is stored in MyISAM engine and needs backups taken using the mysq1dj,p tool. This database
has many triggers and views that also need to be backed up at the same time.
A user ‘backupuser’ is created to facilitate backups automatically and has the following privilleges:
When the backup is taken, there are no errors.
Why are triggers missing from the backup?
A. The FILE privilege is required to back up the TRG files stored in the database directory.
B. The PROCESS privilege will allow the user access to process items such as triggers and functions.
C. The ALL privilege is required to back up triggers because triggers have a wide variety of abilities.
D. The TRIGGER privilege Is required to create, execute, and show triggers in a database.
Answer:D
32.There are multiple Instances of MySQL Server running on a single OS that is backed up using the
mysqlbackup command.
The servers are configured as follows:
The /etc/my.cnf contains default values eg; datadir=/var/Iib/mysql/with extra instances having their own
separate my.cnf file (eg /etc/mysql/instanreN.cnf overrding the defaults as required.
A restore of the second stance is attempted from the mysqlbackup archive using the following command:
Upon starting the second mysqld instance, you notice that the data does not match the expected backup.
Which command-line option is required to successfully update the second instance?
A. –instance=/var/lib/maysql/instance2
B. –restore=2
C. –copy-back-from-log
D. –defaults-file=/etc/mysql/instance2.cnf
E. –backup-instance=/var/lib/mysql/instance2
Answer:D
33.Consider the table mydata:
剩余60页未读，继续阅读
worthcvt
- 粉丝: 91
- 资源: 407
我的内容管理
展开
最新资源
- 贵州煤矿矿井水分类与处理策略：悬浮物、酸性与非酸性
- 醛固酮增多症肾上腺静脉采样对比：ACTH后LR-CAV的最优评估
- 开源云连接传感器监控平台：农业土壤湿度远程监测
- 母婴用品企业年度生产计划线性规划优化模型：实证与应用
- 井下智能变电站：Rogowski线圈电流检测系统的研发与性能验证
- 霍州矿区煤巷稳定性分析及支护策略
- ARM嵌入式系统远程软件更新方案：基于TFTP协议
- 煤炭选煤中汞分布规律与洗选脱汞效果
- 提升码垛机器人性能：拉格朗日动力学模型与滑模模糊控制的应用
- 增强现实技术提升学前手写教学：设计与开发案例
- 不规则工作面沉陷三角剖分算法提升与应用
- 卡尔曼滤波在瞬变电磁干扰压制中的应用研究
- 煤矿安全能力研究：理论与系统构建
- LonWorks总线技术在斜巷运输车辆定位与跑车防护中的应用
- 神东煤炭集团高效煤粉锅炉系统：节能环保新实践
- Ti/SnO2+Sb2Ox/PbO2电极分形维数与电催化性能研究
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
