Which two statements cause a syntax error?

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

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

A.
CREATE TABLE FRIENDS (NAME CHAR (10))

B.
CREATE TABLE BINARY (PRIMARY SMALLINT)

C.
CREATE TABLE ‘TABLE’ (COLUMN’ INTEGER)

D.
CREATE TABLE “CONDITION” (“DESCRIBE” TEXT)

E.
CREATE TABLE INTERVAL (ELAPSED_TIME TIME)

Show Hint

Leave a Reply 4

Your email address will not be published. Required fields are marked *

Zizo

Zizo

Correct Answers are B and E due to using common mysql keywords for table names unquoted whether in single or double quotes.

Reply

Jay

Jay

BE

set sql_mode = ”;

set sql_mode = ‘ANSI_QUOTES’;

select @@sql_mode;

CREATE TABLE FRIENDS (NAME CHAR (10));
CREATE TABLE BINARY (PRIMARY SMALLINT);
CREATE TABLE `TABLE` (`COLUMN` INTEGER);
CREATE TABLE “CONDITION” (“DESCRIBE” TEXT);
CREATE TABLE INTERVAL (ELAPSED_TIME TIME);

Reply