试题详情
- 多项选择题 Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command） （）
A、A CHECK constraint is created on the OID column.
B、A NOT NULL constraint is created on the OID column.
C、The ORDERS table is the only object created in the USERS tablespace.
D、The ORDERS table and a unique index are created in the USERS tablespace.
E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.
- B,D
关注下方微信公众号，在线模考后查看
热门试题
- Which two activities
- You are granted the
- Examinethestructurei
- 执行特定任务的子程序是（）。
- Which statement most
- Which two statements
- Given： When li
- User Mary has a view
- A media
- You issue&ensp
- In which scenario wo
- You are
- From the
- Sales details are b
- Given： What ca
- DESC student的作用是什么？
- You want to display
- Two database&#
- When a c
- 假设需要删除数据库中的CUSTOMER表