网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Evaluate the set of SQL statements:CREATE TABLE dept(deptno NUMBER(2),dname VARCHAR2(14),loc VARCHAR2(13));ROLLBACK;DESCRIBE DEPTWhat 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.
参考答案
更多 “ Evaluate the set of SQL statements:CREATE TABLE dept(deptno NUMBER(2),dname VARCHAR2(14),loc VARCHAR2(13));ROLLBACK;DESCRIBE DEPTWhat 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. ” 相关考题
考题
下列程序的输出结果是【 】。 includeclass MyClass{public: int number; void set(in
下列程序的输出结果是【 】。include＜iostream. h＞class MyClass{public:int number;void set(int i);};int number=3;void MyClass: :set (int i){number=i;}void main( ){MyClass my1；int number=10;my1.set(5),cout＜＜my1, number＜＜',';my1.set(number);cout＜＜my1.number＜＜',';my1.set(: :number);cout＜＜my1.number＜＜'.';}
考题
WhichDBMS_RESOURCE_MANAGERprocedureprioritizesconsumer－groupmappings?()
A.CREATE_MAPPING_PRIORITYB.SET_MAPPING_PRIORITYC.SET_MAPPING_ORDERD.PRIORITIZE_MAPPING_ORDERE.ThisfunctionalityisnotavailablethroughtheDBMS_RESOURCE_MANAGERpackage.
考题
找出"作者"库表中没有出现在"获奖名单"库表中的所有作者信息的SQL语句,(提示:使用NOT IN,NOT EXISTS,以及外部连接(+)三种方法),并说明那种方法是不优化的出版社: 出版社代码 char(2),出版社名称 varchar2(32)图书: 图书编号 char(8),图书名称 varchar2(128),出版社代码 char(2),作者代号char(4),图书简介 varchar2(128)作者: 作者代号 char(4),作者名称 varchar2(10),性别 char(1),年龄 number(3),文学方向 varchar2(64)获奖名单: 获奖日期 date,获奖人员 char(4)
考题
YouhaveanExchangeServer2010organizationnamedcontoso.com.YourcompanyisinvestigatingausernamedUser1.YouneedtopreventUser1frompermanentlydeletingtheitemsinhismailbox.Whatshouldyourun()?
A.Set-MailboxUser1-LitigationHoldEnabled$trueB.Set-MailboxUser1-ModerationEnabled$trueC.Set-MailboxUser1-RetainDeletedItemsUntilBackup$trueD.Set-MailboxUser1-RetentionHoldEnabled$true
考题
以下关于PL／SQL变量类型的说法正确的是()
A.CHAR类型的变量比VARCHAR2类型的变量更省空间B.对VARCHAR2类型变量的访问效率要高于CHAR类型的变量C.BOOLEAN变量的值只有两种：TRUE和FALSED.DATE类型的变量取值可以精确毫秒E.PLS_INTEGER与BINARY_INTEGER类型变量取值范围相同
考题
列出所有部门的职工人数（包括没有职工的部门) （)。A．select dept.deptno,dname,count(emp.empno) from emp,dept where emp.deptno=dept.deptno group by dept.deptno,dname;B．select dept.deptno,dname,count(emp.empno) from emp,dept where emp.deptno()=dept.deptno group by dept.deptno,dname;C．select dept.deptno,dname,count(emp.empno) from emp,dept where emp.deptno=dept.deptno() group by dept.deptno,dname;D．select dept.deptno,dname,count(emp.empno) from emp,dept where emp.deptno(
考题
1、下列选项中，执行时会报错的语句是（）。A．set('Python')B．set(35.2,True)C．set([35.2,True])D．set((35.2,True))
热门标签
最新试卷