Examine the command to create the BOOKS table.

Oracle 1z0-071 Question Answer

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.

insert into books (book id title, author_id values

(‘101’，’LEARNING SQL’,’Tim Jones’)

It executes successfully and the row is inserted with a null PLBLISHER_ID.

It executes successfully only if NULL is explicitly specified in the INSERT statement.

It executes successfully only NULL PUBLISHER_ID column name is added to the columns list in the INSERT statement.

It executes successfully onlyif NULL PUBLISHER ID column name is added to the columns list and NULL is explicitly specified In the INSERT statement.

Oracle 1z0-071 Summary

Price: $52.5 ~~$149.99~~