多項(xiàng)選擇題

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.

你可能感興趣的試題

單項(xiàng)選擇題

You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this.
Which data type would you use for the new column（）

A.CLOB
B.BLOB
C.BFILE
D.LONG RAW

單項(xiàng)選擇題

You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL> DROP PROFILE app_user；
Which statement describes the result（）

A.The command produces an error.
B.The profile is dropped and current user sessions use the DEFAULT profile immediately.
C.The profile is dropped and only the subsequent user sessions use the DEFAULT profile.
D.The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

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） （）

你可能感興趣的試題

You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this. Which data type would you use for the new column（）

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）（）

You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this.
Which data type would you use for the new column（）