当前位置: X题卡 > 所有题目 > 题目详情

一个信息表student,要求它由学号sno,姓名sname,性别sex,年龄age,4个属性组成。现在对这个现有的表增加一个入学时间cometime字段为日期型,下列语句正确的是______。

查看本题答案

你可能感兴趣的试题

CREATE TABLE student
(sno char(5) NOT NULL
sname char(8) NOT NULL
sex char(1)
age int);  
CREATE TABLE student
(sno char(5) NOT NULL UNIQUE
sname char(8)
sex char(1)
age int);  
CREATE TABLE
(sno char(5) NOT NULL UNIQUE
sname char(8) NOT NULL
sex char(1)
age int);  
CREATE TABLE student
(sno char(5) NOT NULL UNIQUE
sname char(8) NOT NULL
sex char(1)
age int);  
CREATE TABLE student  (sno char(5)NOT NULL  sname char(8)NOT NULL  sex char(1)  age int);  CREATE TABLE student  (sno char(5)NOT NULL  sname char(8)NOT NULL  sex char(1)  age int);  CREATE TABLE  (sno char(5)NOT NULL UNIQUE  sname char(8)NOT NULL  sex char(1)  age int);  CREATE TABLE student  (sno char(5)NOT NULL UNIQUE  sname char(8)NOT NULL  sex char(1)  age int);  
CREATE TABLE student (sno char(5) NOT NULL sname char(8) NOT NULL sex char(1) age in;  CREATE TABLE atudent (sno char(5) NOT NULL UNIQUE sname char(8) sexchar(1) age in;  CREATE TABLE (sno char(5) NOT NULL UNIQUE sname char(8) NOT NULL sex char(1) age ih;  CREATE TABLE student (sno char(5) NOT NULL UNIQUE shame char(8) NOT NULL sex char(1) age in;  
ALTER TABLE student ADD cometime DATE NOT NULL;  ALTER TABLE sudent ADD cometime DATE;  AlTER TABLE student DROP cometime DATE NOT NULL;  ALTER TABLE sudent MODIFY cometime DATE;  
CREATE TABLE student (sno char(5)NOT NUIL sname char(8)NOT NULL sex char(1) age in;  CREATE TABLE student (sno char(5)NOT NULL UNIQUE sname char(8) Sex char(1) age in;  CREATE TABLE (sno char(5)NOT NULL UNIQUE sname char(8)NOT NULL sex char(1) age in;  CREATE TABLE student (sno char(5)NOT NULL UNIQUE sname char(8)NOT NULL Sex char(1) age in;  
CREATE TABLE student
(sno char(5) NOT NULL
sname char(8) NOT NULL
sex char(1)
age int);  
CREATE TABLE student
(sno char(5) NOT NULL UNIQUE
sname char(8)
sex char(1)
age int);  
CREATE TABLE
(sno char(5) NOT NULL UNIQUE
sname char(8) NOT NULL
sex char(1)
age int);  
CREATE TABLE student
(sno char(5) NOT NULL UNIQUE
sname char(8) NOT NULL
sex char(1)
age int);  
ALTER TABLE student ADD cometime DATE NOT NULL;  ALTER TABLE student ADD cometime DATE;  ALTER TABLE student DROP cometime DATE NOT NULL;  ALTER TABLE student MODIFY cometime DATE;  
CREATE TABLE student   (sno char(5)NOT NULL   sname char(8)NOT NULL   sex char(1)   age in;  CREATE TABLE student   (sno char(5)NOT NULL   sname char(8)NOT NULL   sex char(1)   age in;  CREATE TABLE   (sno char(5)NOT NULL UNIQUE   sname char(8)NOT NULL   sex char(1)   age in;  CREATE TABLE student   (sno char(5)NOT NULL UNIQUE   sname char(8)NOT NULL   sex char(1)   age in;  
CREATE TABLE student
(sno char(5)NOT NUIL
sname char(8)NOT NULL
sex char(1)
age int);  
CREATE TABLE student
(sno char(5)NOT NULL UNIQUE
sname char(8)
Sex char(1)
age int);  
CREATE TABLE
(sno char(5)NOT NULL UNIQUE
sname char(8)NOT NULL
sex char(1)
age int);  
CREATE TABLE student
(sno char(5)NOT NULL UNIQUE
sname char(8)NOT NULL
Sex char(1)
age int);  
CREATE TABLE student
(sno char(5) NOT NULL
sname char(8) NOT NULL
sex char(1)
age int);  
CREATE TABLE student
(sno char(5)NOT NULL UNIQUE
sname char(8)
sex char(1)
age int);  
CREATE TABLE
(sno char(5)NOT NULL UNIQUE)
sname char(8)NOT NULL
sex char(1)
age int);  
CREATE TABLE student
(sno char(5)NOT NULL UNIQUE)
sname char(8)NOT NULL
sex char(1)
age int);  
CREATE TABLE student
(sno char(5) NOT NULL
sname char(8) NOT NULL
sex char(1)
age int);  
CREATE TABLE student
(sno char(5) NOT NULL UNIQUE
sname char(8)
sex char(1)
age int);  
CREATE TABLE
(sno char(5) NOT NULL UNIQUE
sname char(8) NOT NULL
sex char(1)
age int);  
CREATE TABLE student
(sno char(5) NOT NULL UNIQUE
sname char(8) NOT NULL
sex char(1)
age int);  
CREATE TABLE student  (sno char(5) NOT NULL  sname char(8) NOT NULL  sex char(1)  age int);  CREATE TABLE student  (sno char(5) NOT NULL UNIQUE  sname char(8)  sex char(1)  age int);  CREATE TABLE  (sno char(5) NOT NULL UNIQUE  sname char(8) NOT NULL  sex char(1)  
ALTER TABLE student ADD cometime DATE NOT NULL;  ALTER TABLE sudent ADD cometime DATE;  ALTER TABLE student DROP cometime DATE NOT NULL;  ALTER TABLE sudent MODIFY cometime DATE;  
CREATE TABLE student (sno char(5) NOT NULL sname char(8) NOT NULL sex char(1) age in;  CREATE TABLE student (sno char(5) NOT NULL UNIQUE sname char(8) sex char(1) age in;  CREATE TABLE (sno char(5) NOT NULL UNIQUE sname char(8) NOT NULL sex char(1) age in;  CREATE TABLE student (sno char(5) NOT NULL UNIQUE sname char(8) NOT NULL sex char(1) age in;  
CREATE TABLE student
  (sno char(5)NOT NULL
  sname char(8)NOT NULL
  sex char(1)
  age int);  
CREATE TABLE student
  (sno char(5)NOT NULL
  sname char(8)NOT NULL
  sex char(1)
  age int);  
CREATE TABLE
  (sno char(5)NOT NULL UNIQUE
  sname char(8)NOT NULL
  sex char(1)
  age int);  
CREATE TABLE student
  (sno char(5)NOT NULL UNIQUE
  sname char(8)NOT NULL
  sex char(1)
  age int);  
ALTER TABLE student ADD cometime DATE NOT NULL;  ALTER TABLE student ADD cometime DATE;  ALTER TABLE student DROP cometime DATE NOT NULL:  ALTER TABLE student MODIFY cometime DATE;  
CREATE TABLE student (sno char(5)NOT NULL sname char(8)NOT NULL sex char(1) age in;  CREATE TABLE student (sno char(5)NOT NULL UNIQUE sname char(8) sex char(1) age in;  CREATE TABLE (sno char(5)NOT NULL UNIQUE sname char(8)NOT NULL sex char(1) age in;  CREATE TABLE student (sno char(5)NOT NULL UNIQUE sname char(8)NOT NULL sex char(1) age in;  
CREATE TABLE student (sno char(5) NOT NULL sname char(8) NOT NULL sex char(1) age in;  CREATE TABLE student (sno char(5) NOT NULL UNIQUE sname char(8) sex char(1) age in;  CREATE TABLE (sno char(5) NOT NULL UNIQUE sname char(8) NOT NULL sex char(1) age in;  CREATE TABLE student (sno char(5) NOT NULL UNIQUE sname char(8) NOT NULL sex char(1) age in;  

热门试题

更多