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.
第1题:
A.
B.
C.
D.
第2题:
Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?()
第3题:
Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?()
第4题:
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()
第5题:
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()
第6题:
It releases the storage space used by the table.
It does not release the storage space used by the table.
You can roll back the deletion of rows after the statement executes.
You can NOT roll back the deletion of rows after the statement executes.
An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table.
第7题:
It fails to delete the records because the records are locked in SHARE mode.
It deletes the rows successfully because the table is locked in SHARE mode
It fails to delete the records because the table is locked in EXCLUSIVE mode.
It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
第8题:
remove the ORDER BY clause
remove the table alias prefix from the WHERE clause
remove the table alias from the SELECT clause
prefix the column in the USING clause with the table alias
prefix the column in the ORDER BY clause with the table alias
replace the condition d.department_id NOT IN (10,40) in the WHERE clause with d.department_id <> 10 AND d.department_id <> 40
第9题:
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.
第10题:
GRANT select ON dept TO ALL_ USER;
GRANT select ON dept TO ALL;
GRANT QUERY ON dept TO ALL_USERS
GRANT select ON dept TO PUBLIC;
第11题:
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.
第12题:
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.
第13题:
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? ()
第14题:
下面哪一个SQL语句将删除DEPT表中的所有数据,并永久删除DEPT表的整个结构()
第15题:
Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? ()
第16题:
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? ()
第17题:
The DESCRIBE DEPT statement displays the structure of the DEPT table.
The ROLLBACK statement frees the storage space occupied by the DEPT table.
The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
第18题:
UPDATE TABLE
CREATE CLUSTER
TRUNCATE TABLE
ALTER TABLE MOVE
INSERT INTO···VALUES
ALTER TABLE···DROP COLUMN
ALTER TABLE···DROP PARTITION
第19题:
The DESCRIBE DEPT statement displays the structure of the DEPT table.
The ROLLBACK statement frees the storage space occupies by the DEPT table.
The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
第20题:
You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.
You can restore the DEPT table by using the Oracle Flashback Drop feature and a systemgenerated name will be assigned to the restored table.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
第21题:
The DESCRIBE DEPT statement displays the structure of the DEPT table.
The ROLLBACK statement frees the storage space occupies by the DEPT table.
The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.