165.You have an ORDERS table with the following structure:
Name Null? Type
----------- -------- ----------
OID NUMBER(6)
ODATE DATE
CCODE NUMBER(6)
OAMT NUMBER(10,2)
The table has data in the ODATE column for all rows. Many orders are placed in a single day. You need to
ensure that the ODATE column must contain data for every order in future.
Which method would serve the purpose?
A.Modify the column using the ALTER TABLE...MODIFY command.
B.Add a UNIQUE constraint to the column using the ALTER TABLE...ADD CONSTRAINT command.
C.Add a NOT NULL constraint to the column using the ALTER TABLE...ADD CONSTRAINT command.
D.Add a PRIMARY KEY constraint to the column using the ALTER TABLE...ADD CONSTRAINT command.
答案:A
解析:这个题是说需要保证odata必须包含一个日期,因此需要加一个not null约束,使用方法如下
--增加not null约束(not null 比较特殊需要使用modify,其他都是add)
alter table orders modify ODATE constraint odate_nn not null;
--增加主键
alter table orders add constraint orders_pk primary key(ODATE);
--增加check
alter table orders add constraint orders_ck check (ODATE=to_date('2016-08-08','yyyy-mm-dd'));
--增加外键
alter table orders add constraint orders_fk odate references orders_old(odate);
Name Null? Type
----------- -------- ----------
OID NUMBER(6)
ODATE DATE
CCODE NUMBER(6)
OAMT NUMBER(10,2)
The table has data in the ODATE column for all rows. Many orders are placed in a single day. You need to
ensure that the ODATE column must contain data for every order in future.
Which method would serve the purpose?
A.Modify the column using the ALTER TABLE...MODIFY command.
B.Add a UNIQUE constraint to the column using the ALTER TABLE...ADD CONSTRAINT command.
C.Add a NOT NULL constraint to the column using the ALTER TABLE...ADD CONSTRAINT command.
D.Add a PRIMARY KEY constraint to the column using the ALTER TABLE...ADD CONSTRAINT command.
答案:A
解析:这个题是说需要保证odata必须包含一个日期,因此需要加一个not null约束,使用方法如下
--增加not null约束(not null 比较特殊需要使用modify,其他都是add)
alter table orders modify ODATE constraint odate_nn not null;
--增加主键
alter table orders add constraint orders_pk primary key(ODATE);
--增加check
alter table orders add constraint orders_ck check (ODATE=to_date('2016-08-08','yyyy-mm-dd'));
--增加外键
alter table orders add constraint orders_fk odate references orders_old(odate);