单选题Which is a valid CREATE TABLE statement?（）A CREATE TABLE EMP9$# AS (empid number(2));B CREATE TABLE EMP*123 AS (empid number(2));C CREATE TABLE PACKAGE AS (packid number(2));D CREATE TABLE 1EMP_TEST AS (empid number(2));

第1题：

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.

第2题：

Which is a valid CREATE TABLE statement? （）

• A、CREATE TABLE EMP9$# AS (empid number(2));
• B、CREATE TABLE EMP*123 AS (empid number(2));
• C、CREATE TABLE PACKAGE AS (packid number(2));
• D、CREATE TABLE 1EMP_TEST AS (empid number(2));

第3题：

第4题：

Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）

• A、The table created by SKD is not accessible and SKD cannot create new tables.
• B、The tables created by SKD and HR remain， but both cannot create new tables.
• C、The table created by HR remains and HR still has the CREATE TABLE system privilege.
• D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

第5题：

You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key. You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?（）

• A、CREATE TABLE student_grades (student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY student (student_id));
• B、CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));
• C、CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES student (student_id));
• D、CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));

第6题：

评估此CREATE TABLE语句的执行结果： CREATE TABLE part( part_id NUMBER, part_name VARCHAR2(25), manufacturer_id NUMBER(9), retail_price NUMBER(7,2) NOT NULL, CONSTRAINT part_id_pk PRIMARY KEY(part_id), CONSTRAINT cost_nn NOT NULL(cost), CONSTRAINT FOREIGN KEY (manufacturer_id) REFERENCES manufacturer(id)); 哪一行会导致产生错误（）

• A、6
• B、7
• C、8
• D、9

第7题：

Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）

• A、The DESCRIBE DEPT statement displays the structure of the DEPT table.
• B、The ROLLBACK statement frees the storage space occupied by the DEPT table.
• C、The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
• D、The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

第8题：

你要操纵Oracle数据，下列哪个不是SQL命令？（）

• A、select*from dual；
• B、set define
• C、update emp set ename=6543where ename=‘SMITHERS’；
• D、create table employees（empid varchar2（10）primary key）；

第9题：

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.

第10题：

Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）

• A、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
• B、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
• C、CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
• D、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));