CREATE TABLE test(t_idINT,t_nmae CHAR(10))后,增加t_sex字段,以下语句正确的是()。
A、ALTER TABLE test ADD t_sex CHAR(2)
B、ALTER TABLE test ADD t_sex
C、ALTER TABLE test ALTER t_sex CHAR(2)
D、ALTER TABLE test DROP(t_sex CHAR(2))
A、ALTER TABLE test ADD t_sex CHAR(2)
B、ALTER TABLE test ADD t_sex
C、ALTER TABLE test ALTER t_sex CHAR(2)
D、ALTER TABLE test DROP(t_sex CHAR(2))
A、TAKE BACK CREATE ANY TABLE FROM test B、REVOKE CREATE ANY TABLE FROM test C、REVOKE CREATE ANY TABLE test D、TAKE BACK CREATE ANY TABLE test
A、GRANT CREATE ANY TABLE test B、GRANT CREATE ANY TABLE TO test C、TAKE CREATE ANY TABLE TO test D、ALTER CREATE ANY TABLE TO test
A、CREATE TABLE EMP9$# AS (empid number(2)); B、CREATE TABLE EMP*123 AS (empid number(2)); C、CREATE TABLE PACKAGE AS (packid number(2)); D、CREATE TABLE 1EMP_TEST AS (empid number(2));
A、CREATE TABLE EMP9$# AS (empid number(2)); B、CREATE TABLE EMP*123 AS (empid number(2)); C、CREATE TABLE PACKAGE AS (packid number(2)); D、CREATE TABLE 1EMP_TEST AS (empid number(2));
A、c:\_test目录下的test.doc不再存在,编辑的结果存入另一个新文件 B、编辑结果存于c:\_test目录下的test.Doc中 C、编辑的结果存入c:\_test目录下的test.doc中,同时编辑的结果存入另一个新文件,文件和存放位置由用户在对话框中指定 D、c:\_test目录下的test.doc保持不变,同时编辑的结果存入另一个新文件,文件名和存放位置由用户在对话框中指定
A、ALTER TABLE students ADD PRIMARY KEY student_id; B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student _ id); C、ALTER TABLE students ADD CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id); D、ALTER TABLE students MODIFY CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);
A、ALTER TABLE table_name ENABLE constraint_name; B、ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name; C、ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name; D、ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;
A、ALTER TABLE table_name ENABLE constraint_name; B、ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name; C、ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name; D、ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;