多选题Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）AYou cannot roll back this statement.BAll pending transactions are committed.CAll views based on the DEPT table are deleted.DAll indexes based on the DEP

题目

多选题

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）

You cannot roll back this statement.

All pending transactions are committed.

All views based on the DEPT table are deleted.

All indexes based on the DEPT table are dropped.

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

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

All synonyms based on the DEPT table are deleted.

更多“Evaluate the SQL statement DROP TABLE DEPT: Which four state”相关问题

第1题

Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40) ORSER BY dept_name; The statement fails when executed. Which change fixes the error? （）A、remove the ORDER BY clauseB、remove the table alias prefix from the WHERE clauseC、remove the table alias from the SELECT clauseD、prefix the column in the USING clause with the table aliasE、prefix the column in the ORDER BY clause with the table aliasF、replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id 40"

点击查看答案
第2题

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）A、DROP emp_dept_uv;B、DELETE emp_dept_uv;C、REMOVE emp_dept_uv;D、DROP VIEW emp_dept_uv;E、DELETE VIEW emp_dept_uv;F、REMOVE VIEW emp_dept_uv;

点击查看答案
第3题

下面哪一个SQL语句将删除DEPT表中的所有数据，并永久删除DEPT表的整个结构（）A、DROP TABLE dept;B、DELETE TABLE dept;C、TRUNCATE TABLE dept;D、DELETE * . * FROM dept; [END CODE]"

点击查看答案
第4题

For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）A、UPDATE TABLEB、CREATE CLUSTERC、TRUNCATE TABLED、ALTER TABLE MOVEE、INSERT INTO···VALUESF、ALTER TABLE···DROP COLUMNG、ALTER TABLE···DROP PARTITION

点击查看答案
第5题

Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）A、It releases the storage space used by the table.B、It does not release the storage space used by the table.C、You can roll back the deletion of rows after the statement executes.D、You can NOT roll back the deletion of rows after the statement executes.E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

点击查看答案
第6题

User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）A、It fails to delete the records because the records are locked in SHARE mode.B、It deletes the rows successfully because the table is locked in SHARE modeC、It fails to delete the records because the table is locked in EXCLUSIVE mode.D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

点击查看答案
第7题

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.

点击查看答案

Evaluate the SQL statement DROP TABLE DEPT: Which four state

题目

更多“Evaluate the SQL statement DROP TABLE DEPT: Which four state”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容