OCP-1Z0-052-V8 02-165题

               

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.

Answer: A

答案解析：此题考如何添加非空约束

确保ODATE 列在以后都有数据。即添加非空约束，添加非空约束使用alter table modify。

To add a Not Null constraint using theALTER TABLE statement:

1. Click the icon SQL Worksheet.

   The SQL Worksheet pane appears.

2. In the SQL Worksheet pane, type this statement:

   ALTER TABLE PERFORMANCE_PARTS

   MODIFY WEIGHT NOT NULL;

3. Click the icon Execute Statement.

   The statement runs, adding the Not Null constraint to the WEIGHT column of thePERFORMANCE_PARTS table.

官方参考：http://docs.oracle.com/cd/E11882_01/appdev.112/e10766/tdddg_objects.htm#TDDDG191

           

再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！https://blog.csdn.net/jiangjunshow