该博客讨论了Oracle OCP考试中的一个问题，涉及CREATE TABLE AS SELECT语句的使用。内容指出，在创建NEW_SALES表时，即使在列定义中指定了DEFAULT SYSDATE，表仍然可以成功创建，并且源表上的NOT NULL约束将传递到新表，但FOREIGN KEY约束不会。
1. 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 table, 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 not get created because the DEFAULT value cannot be specified in the
column definition.
B. The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified </
最低0.47元/天 解锁文章
3756
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
