CMS专题
多选题Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）AA CHECK cons
题目
A CHECK constraint is created on the OID column.
A NOT NULL constraint is created on the OID column.
The ORDERS table is the only object created in the USERS tablespace.
The ORDERS table and a unique index are created in the USERS tablespace.
The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
相似问题和答案
第1题：
Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task?（）
A.
B.
C.
D.
第2题：
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:$> sqlldr hr/hr@pdb table=employeesWhich two statements are true regarding the command?（）
A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
B. It fails because no SQL *Loader data file location is specified.
C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
D. It fails because no SQL *Loader control file location is specified.
第3题：
A. It executes successfully but partition pruning cannot happen for this partition key.
B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
第4题：
Which two operations can be performed on an external table（）
- A、Create a view on the table.
- B、Create an index on the table.
- C、Create a synonym on the table.
- D、Add a virtual column to the table.
- E、Update the table using the UPDATE statement.
- F、Delete rows in the table using the DELETE command
正确答案:A,C
第5题：
Examine the commands executed in the following sequence： 1：SQL> CREATE ROLE mgrrole； 2：SQL> GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL> GRANT select，update ON sh.sales TO mgrrole； 4：SQL> CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL> GRANT ceo TO mgrrole； Which statement is true about the above commands（）
- A、The commands execute successfully.
- B、Command 6 produces an error because of circular role grant.
- C、Command 5 produces an error because a role cannot be granted to another role.
- D、Command 3 produces an error because the MGRROLE role already contains system privileges.
- E、The table created by HR remains and HR still has the CREATE TABLE system privilege.
- F、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
正确答案:B
第6题：
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL >REVOKE create table FROM C A_ADMIN;What is the result?（）
A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
B. It fails and reports an error because the CONTAINER=ALL clause is not used.
C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
E.It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
第7题：
Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（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 OID columnin the SYSTEM tablespace.
正确答案:B,D
第8题：
Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of this command?（）
A. All three tables in the recycle bin are purged
B. Only the table with the oldest DROPSCN is purged
C. The command returns an error because multiple entries with the same name exist in the recycle bin
D. Only the table with the latest DROPSCN is purged
第9题：
Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL> DROP TABLE emp；Table dropped. What happens in this scenario？（）
- A、The table is moved to the SYSAUX tablespace.
- B、The table is moved to the SYSTEM tablespace.
- C、The table is removed from the database permanently.
- D、The table is renamed and remains in the TBSFD tablespace.
正确答案:D
第10题：
Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）
- A、The constraint remains valid.
- B、The index on the constraint is dropped.
- C、It allows the loading of data into the table using SQL*Loader.
- D、New data conforms to the constraint， but existing data is not checked
- E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
正确答案:A,B,C