Evaluate the set of SQL statements:CREATE TABLE dept(deptno NUMBER(2),dname VARCNAR2(14),1oc VARCNAR2 (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 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.

Evaluate the set of SQL statements:CREATE TABLE dept(deptno NUMBER(2),dname VARCNAR2(14),1oc VARCNAR2 (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 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.


相关考题:

下列程序的输出结果是【 】。 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.

为“数量”宇段增加有效性规则:数量>0,应该使用的SQL语句是【 】TABLE使用零件【 】数量SET【 】数量>0

YouhaveanExchangeServer2010organizationnamedcontoso.com.YourcompanyisinvestigatingausernamedUser1.YouneedtopreventUser1frompermanentlydeletingtheitemsinhismailbox.Whatshouldyourun()? A.Set-MailboxUser1-LitigationHoldEnabled$trueB.Set-MailboxUser1-ModerationEnabled$trueC.Set-MailboxUser1-RetainDeletedItemsUntilBackup$trueD.Set-MailboxUser1-RetentionHoldEnabled$true

YouhaveanExchangeServer2010organizationnamedcontoso.com.YourcompanyisInvestigatingausernamedUser1.YouneedtopreventUser1frompermanentlydeletingtheitemsinhismailbox.Whatshouldyourun?() A.Set-MailboxUser1-LitigationHoldEnabled$trueB.Set-MailboxUser1-ModerationEnabled$trueC.Set-MailboxUser1-RetainDeletedItemsUntilBackup$trueD.Set-MailboxUser1-RetentionHoldEnabled$true

下列选项中,执行时会报错的语句是()。A.set('Python')B.set(35.2,True)C.set([35.2,True])D.set((35.2,True))

列出所有部门的职工人数(包括没有职工的部门) ()。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(

52、set1 = {1, 2, 3} set2 = set1.copy() set3 =set1 set4=set(set1) 针对以上程序,当对set1进行修改时,以下说法正确的是()。A.set2发生改变B.set3发生改变C.set4发生改变D.set2 , set3和set4都发生改变

【单选题】对于建立在数据库上的DDL触发器,常用的激活DDL触发器的事件不包括()A.Create_Table,Alter_Table,Drop_TableB.Create_View,Alter_View,Drop_ViewC.Create_Procedure,Alter_Procedure,Drop_ProcedureD.Rollback

1、下列选项中,执行时会报错的语句是()。A.set('Python')B.set(35.2,True)C.set([35.2,True])D.set((35.2,True))