搜题
用户您好, 请在下方输入框内搜索其它题目:
搜题
题目内容 (请给出正确答案)
提问人:网友 发布时间:
【单选题】

CREATE TABLE dept<br /> (deptno NUMBER(2),<br /> dname VARCNAR2(14),<br /> 1oc VARCNAR2 (13));<br /> ROLLBACK;<br /> DESCRIBE DEPT<br /> 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 occupies 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.

更多“ CREATE TABLE dept<br /> (deptno NUMBER(2),<br /> dname VARCNAR2(14),<br /> 1oc VARCNAR2 (13));<br /> ROLLBACK;<br /> DESCRIBE DEPT<br /> What is true about the set? ()”相关的问题
第2题

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);&nbsp;&nbsp;BCREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));&nbsp;&nbsp;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));&nbsp;&nbsp;D、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));&nbsp;&nbsp;

点击查看答案
第3题

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);&nbsp;&nbsp;BCREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));&nbsp;&nbsp;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));&nbsp;&nbsp;D、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));&nbsp;&nbsp;

点击查看答案
第4题

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

点击查看答案
第5题

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

点击查看答案
第6题

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

点击查看答案
第7题

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

点击查看答案
第8题

A、CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);&nbsp;&nbsp;BCREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));&nbsp;&nbsp;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));&nbsp;&nbsp;D、CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));&nbsp;&nbsp;

点击查看答案
第9题

A、DROP TABLE dept;&nbsp;&nbsp;B、DELETE TABLE dept;&nbsp;&nbsp;C、TRUNCATE TABLE dept;&nbsp;&nbsp;D、DELETE * . * FROM dept; [END CODE]"&nbsp;&nbsp;

点击查看答案
客服
TOP

请使用微信扫码支付

订单号:
遇到问题请联系在线客服