【071题库】最新OCP-071考试题库解析-第53题
071考试是OCP考试科目的一种,由于071考题多变,我们专门收集整理了最新的考试题库,并对这些考题进行讲解,希望可以帮助广大考生。
每周五晚8点,我们有免费的OCP解析公开课,地址:https://ke.qq.com/course/326223 OCP题库交流群:1015267481,验证ocp
-------------------------------------------------------
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
-
标签错误:<!-- #Label#
labelId=20160707140604
moduleId=1
classId=12231768634
orderby=2
fields=url,title,u_info
attribute=
datatypeId=22192428132
recordCount=3
pageSize=
<htmlTemplate><dt><img src="/images/index_26${index}.jpg" width="100" height="62" /><a href="$url" title="${title}">${title}</a><span>${api.left(u_info,60)}</span></dt></htmlTemplate>
-->
- 我要参加技术沙龙