071考試不僅是OCP11g的考試科目，同時也是OCP 12c的考試科目，所以關心071考題的同學有很多，對此我們專門收集整理了近期071考試的原題，并對這些考題進行講解，希望幫助廣大考生順利通過071考試。
--------------------------------------------
071考題解析-第53題、choose the best answer:
Examine the command to create the BOOKS table.
SQL>CREATE TABLE books
(book_id CHAR(6) PRIMARY KEY,
title VARCHAR2(100) NOT NULL,
publisher_id VARCHAR2(4),
author_id VARCHAR2(50));
The BOOK_ID value 101 does not exist in the table.
Examine the SQL statement:
SQL> INSERT INTO books(BOOK_ID, TITLE, AUTHOR_ID)
VALUES ('101', 'LEARNING SQL', 'Tim Jones');
Which statement is true?
A) It executes successfully only if the PUBLISHER_ID column name is added to the columns list and NULL is explicitly specified in the INSERT statement.
B) It executes successfully only if NULL is explicity specified in the INSERT statement.
C) It executes successfully only if the PUBLISHER_ID column name is added to the columns list in the INSERT statement.
D) It executes successfully and the row is inserted with a null PUBLISHER_ID.
Answer：D
-----------------------------------------------
OCP解析公開課時間：【每周五晚8點】
OCP解析公開課地址：https://ke.qq.com/course/326223
OCP解析群資料分享：1015267481 驗證：ocp
另外，除了OCP公開課，OCM題庫直播也同步進行中，OCM最新題庫大爆料-【每周四晚8點】，【微信群直播】，可以聯系咨詢老師進群參與
