可学答题网 > 问答 > 1Z0-052题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Examine the command th


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) ()

  • AA CHECK constraint is created on the OID column.
  • BA NOT NULL constraint is created on the OID column.
  • CThe ORDERS table is the only object created in the USERS tablespace.
  • DThe ORDERS table and a unique index are created in the USERS tablespace.
  • EThe ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.
参考答案
参考解析:
分类:1Z0-052题库
相关推荐

1、Examine the command: &

Examine the command:  ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;  What...

2、Examine the following 

Examine the following command:  ALTER DISKGROUP data MOUNT FORCE;  In which scenario can&ensp...

3、Examine the following 

Examine the following parameter settings from an initialization (init.ora) file:  DB_CREATE_FILE_DEST ...

4、Examine the following 

Examine the following command that is used to duplicate a database on the same host: &ens...

5、Examine the following 

Examine the following RMAN command:  BACKUP DATABASE TAG TESTDB KEEP UNTIL ’SYSDATE+1’ ...

6、Examine the following 

Examine the following commands executed in your database: SQL> ALTER SESSION RECYCLEBIN=ON; Session&ens...