Oracle 11g OCP最新题库（OCP考试必备）--更新于11月3号目前最新

guoyJoe

mtktang 发表于 2013-11-22 02:54
Thanks for latest update!

you are welcome!

lukean88

看看看看看看

kl13579y

说的好吓人。。

nc_bill

楼主好人啊

xixialu1

谢谢，谢谢，非常感谢！

guolijie_gg

1z0-051  11月22又更新了吗？这个题库是哪天更新的？一共多少道题啊

walkbob

楼主长命百岁

xhishl

好东西，谢谢分享。。

guolijie_gg

大师：
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;

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
columns would be passed to the new table.
C. The NEW_SALES table would not get created because the column names in the CREATE TABLE
command and the SELECT clause do not match.
D. The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the
specified columns would be passed to the new table.


这道题怎么解读啊，我怎么感觉选D答案啊？

bryanliutw

Thanks!