nerdexam
Oracle

1Z0-882 · Question #43

Assume your connection uses SQL mode ANSI_QUOTES. Which two statements cause a syntax error?

The correct answer is B. CREATE TABLE BINARY (PRIMARY SMALLINT) E. CREATE TABLE INTERVAL (ELAPSED_TIME TIME). See the full explanation below for the reasoning.

Question

Assume your connection uses SQL mode ANSI_QUOTES. Which two statements cause a syntax error?

Options

  • ACREATE TABLE FRIENDS (NAME CHAR (10))
  • BCREATE TABLE BINARY (PRIMARY SMALLINT)
  • CCREATE TABLE `TABLE' (COLUMN' INTEGER)
  • DCREATE TABLE "CONDITION" ("DESCRIBE" TEXT)
  • ECREATE TABLE INTERVAL (ELAPSED_TIME TIME)

How the community answered

(57 responses)
  • A
    11% (6)
  • B
    81% (46)
  • C
    4% (2)
  • D
    5% (3)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-882 Practice