可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Evaluate the set of SQL statements: C


Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (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 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.
参考答案
参考解析:
分类:1Z0-007题库
相关推荐

1、Evaluate the SQL statement: What is

Evaluate the SQL statement:What is the result of the statement?()A The statement produces an error at line 1.B The statement produces an erro...

2、Evaluate these two SQL statements: SE

Evaluate these two SQL statements:SELECT last_name, salary , hire_dateFROM EMPLOYEESORDER BY salary DESC;SELECT last_name, salary, hire_dateFROM EMPL...

3、Evaluate this SQL statement: In the

Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?()A Selection, projection, joinB Difference,...

4、Evaluate the SQL statement DROP TABLE

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? ()A You cannot roll back this statement.B A...

5、Evaluate the SQL statement: What wil

Evaluate the SQL statement:What will be displayed?()A 0B 1C 0.00D An error statement

6、Which of the following SQL statements

Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary...