Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? ()

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement？ ()

A. You cannot roll back this statement.

B. All pending transactions are committed.

C. All views based on the DEPT table are deleted.

D. All indexes based on the DEPT table are dropped.

E. All data in the table is deleted, and the table structure is also deleted.

F. All data in the table is deleted, but the structure of the table is retained.

G. All synonyms based on the DEPT table are deleted.

您可能感兴趣的试题

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 greater than $30 000?()

答案解析
The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION

答案解析
Evaluate this SQL statement:SELECT ename sal 12* sal+100 FROM emp;The SAL column stores

答案解析
Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?()

答案解析
Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table? ()

答案解析
Evaluate the SQL statement:What is the result of the statement?()

答案解析
Evaluate the SQL statement:1 SELECT a.emp_name a.sal a.dept_id b.maxsal2 FROM employees

答案解析