大數(shù)據(jù)就業(yè)實戰(zhàn)培訓(xùn) Oracle就業(yè)實戰(zhàn)培訓(xùn)
071考試題庫之前是比較穩(wěn)定的,但隨著Oracle的調(diào)整,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 答案可以通過創(chuàng)建同義詞來實現(xiàn),這道題比較靈活,表達的比較隱晦。)