（多选题）
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.
正确答案
答案解析
略
相似试题
（单选题）
View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement？（）
（单选题）
View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.The graph recommends that the size of undo tablespace should be set to（）.
（单选题）
View the Exhibit and examine the output of the query. What do you infer from this（）
（单选题）
View the Exhibit and examine the output of the query. What do you infer from this（）
（多选题）
View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 listener（）
（多选题）
Exhibit： View the Exhibit and examine the properties of the USERS tablespace. You execute the following statement to shrink the TRANS table existing on the USERS tablespace： SQL> ALTER TABLE trans SHRINK SPACE CASCADE； Which objects would be affected by this command？（）
（单选题）
View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries？ （）
（多选题）
View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 listener（）
（单选题）
View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is trueabout the output of the command（）
（单选题）
View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident（）
