nerdexam
IBM

C2090-558 · Question #64

Given the following: CREATE TABLE customer (customer_num INT, company CHAR(25)); Which of the following SQL statements will return an error?

The correct answer is A. INSERT INTO customer VALUES (453). See the full explanation below for the reasoning.

Question

Given the following: CREATE TABLE customer (customer_num INT, company CHAR(25)); Which of the following SQL statements will return an error?

Options

  • AINSERT INTO customer VALUES (453);
  • BINSERT INTO customer VALUES (453, '"ABC Company");
  • CINSERT INTO customer (company) VALUES ("ABC Company");
  • DINSERT INTO customer (customer_num, company) VALUES (453, "ABC Company");

How the community answered

(28 responses)
  • A
    82% (23)
  • B
    4% (1)
  • C
    4% (1)
  • D
    11% (3)

Community Discussion

No community discussion yet for this question.

Full C2090-558 Practice