大数据就业实战培训 Oracle就业实战培训
071考试题库之前是比较稳定的,但随着Oracle的调整,071考试不断的增加新的考题,增加了考试的难度,所以我们专门收集整理了这些考试,并对这些考题进行解析,希望可以对考生有帮助。
每周五晚8点,我们有免费的OCP解析公开课,地址:https://ke.qq.com/course/326223 OCP题库交流群:1015267481,验证ocp
-------------------------------------------------------
071考试-第42题、choose three
Which three tasks can be performed by DDL statements?
A) preventing data retrieval from a table outside of office hours
B) modifying a table to prevent data that violate certain conditions from being entered in a column
C) preventing any data modification to a table
D) creating multiple savepoints to enable partial rollback of a transaction
E) providing an alternative name for a table
Anser:BCE
(解析:B 答案可以用添加约束来解决;C 答案可以用 alter 命令把表变成只读模式;E 答案可以通过创建同义词来实现,这道题比较灵活,表达的比较隐晦。)