【12c OCP】最新OCP 12c題庫考試原題(071-42題)
最新學訊:近期OCP認證正在報名中,因考試人員較多請盡快報名獲取最近考試時間,報名費用請聯系在線老師,甲骨文官方認證,報名從速!
我要咨詢2018年OCP 11g考試原題解析已經講解30多次課,500多道考試原題,最終達到98%以上的考題覆蓋度及95%以上的考試通過率。
2019年OCP 11g將升級到12c,OCP 12c考試解析免費公開課也已經開始了,歡迎大家收看!
OCP解析公開課時間:【每周五晚8點】
OCP解析公開課地址:http://ke.qq.com/course/326223
OCP解析群資料分享:1015267481 驗證:ocp
另外,除了OCP公開課,OCM題庫直播也同步進行中,OCM最新題庫大爆料-【每周四晚8點】,【微信群直播】,可以聯系咨詢老師進群參與
-------------------------------------------------------
42、(9-1)choose the best answer:
Which statement is true about the Oracle SQL, DELETE and TRUNCATE statements?
A) DELETE but not TRUNCATE statement can be used to remove data from selective columns and rows of a table.
B) DELETE and TRUNCATE statements can have a rollback done to restore data into a table.
C) DELETE and TRUNCATE statements remove all indexes for the tables on which they are performed.
D) DELETE but not TRUNCATE statement can be used to selectively remove rows from a table.
Answer:D
(解析:Truncate 是刪除整張表的數據,delete 不能刪除某個列的數據,刪除的是行的數據)