Questões de Concurso

DPE-SP

Concurso: DPE-SP
Cargo: Analista da Defensoria Pública - Programador
Ano: 2013

Ano:

2013

Banca:

FCC

Cargo:

Analista da Defensoria Pública - Programador

Disciplina: Banco de Dados

notificar erro

Uma instrução SQL correta para criar a tabela NOTAFISCAL apresentada no modelo é:

(a)

CREATE TABLE NOTAFISCAL (idNOTAFISCAL INTEGER NOT NULL, dataEmissao DATE NULL, PRIMARY KEY(idNOTAFISCAL));

(b)

CREATE TABLE NOTAFISCAL (idNOTAFISCAL INTEGER NULL AUTOINCREMENT, dataEmissao DATE NULL, PRIMARY KEY(idNOTAFISCAL));

(c)

CREATE SCHEMA NOTAFISCAL (idNOTAFISCAL INTEGER NOT NULL AUTO_INCREMENT, dataEmissao DATE NOT NULL, PRIMARY KEY(idNOTAFISCAL));

(d)

CREATE TABLE NOTAFISCAL (idNOTAFISCAL INTEGER NULL, dataEmissao DATE NOT NULL, CONSTRAINT UNIQUE KEY(idNOTAFISCAL));

(e)

CREATE TABLE NOTAFISCAL (idNOTAFISCAL INTEGER NULL CONSTRAINT PRIMARY KEY, dataEmissao DATE NULL);