发出下列语句:alter table sales drop columm profit;何时从Oracle中实际删除列?()
A、执行语句后立即删除
B、发出alter table drop unused columns命令之后
C、发出alter table set unused columns命令之后
D、发出alter table modify命令之后
A、执行语句后立即删除
B、发出alter table drop unused columns命令之后
C、发出alter table set unused columns命令之后
D、发出alter table modify命令之后
A、A.alter user hr unlock B、B.alter user hr account unlock C、C.alter table alter hr unlock D、D.alter table alter unlock hr
A、alter table sales modify(unit_prices null) B、alter table sales modify(unit_prices not null) C、alter table sales add(unit_prices null) D、alter table sales add(unit_prices not null)
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、SET TABLE B、ALTER TABLE C、CREATE TABLE D、ADD TABLE
A、alter table authors add first_name not null B、alter table authors modify first_name not null C、alter table authors alter first_name not null D、alter table authors drop first_name not null
A、ALTER TABLE 表名 ALTER COLUMN 列名 数据类型 B、ALTER TABLE 表名 ALTER 列名 数据类型 C、ALTER TABLE MODIFY COLUMN 列名 数据类型 D、ALTER TABLE 表名 ADD 列名 数据类型
A、ALTER TABLE T ADD COLUMN c1 int B、ALTER TABLE T ADD (c1 int) C、ALTER TABLE T ADD COLUMN c1 D、ALTER TABLE T ADD c1
A、A.ALTER  TABLE  M  ADD  COLUMN  Type  NCHAR(4) B、B.ALTER  TABLE  M  ALTER  COLUMN  Type  NCHAR(4) C、C.ALTER  TABLE  M  DROP  COLUMN  Type  NCHAR(4) D、D.ALTER  TABLE  M  ALTER  Type  NCHAR(4)
A、REMOVE TABLE users B、DROP TABLE users C、DELETE FROM users D、ALTER TABLE users