【12c OCP認證】2019年度OCP最新考試題庫-071.87題
最新學訊：近期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點】，【微信群直播】，可以聯系咨詢老師進群參與
-------------------------------------------------------
87、View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES
tables.
The PROD_ID column is the foreign key in the SALES tables, which references the PRODUCTS table.
Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Evaluate the following CREATE TABLE command:
CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE) AS SELECT prod_id, cust_id, time_id FROM sales;
Which statement is true regarding the above command?
A. The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.
B. The NEW_SALES table would not get created because the DEFAULTvalue cannot be specified in the column definition.
C. The NEW_SALES table would not get created because the column names in the CREATE TABLEcommand and the SELECTclause do not match.
D. The NEW_SALES table would get created and all the FOREIGN KEYconstraints defined on the specified columns would be passed to the new table.
Correct Answer: A
Section: (none)
Explanation( ( 解析：經過測試發現表能夠創建成功，非空約束被傳遞到新表，以前沒有注意這一點，其它約束不會傳遞，defualt 選項只會影響以后插入的行，對當前的行沒有任何影響;如果在 order_date 列上加一個非空約束，則會報錯，因為當前表的行可能有空值。)
