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

第1题：

第2题：

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.

第3题：

Which three are true?（）

• A、A MERGE statement is used to merge the data of one table with data from another.
• B、A MERGE statement replaces the data of one table with that of another.
• C、A MERGE statement can be used to insert new rows into a table.
• D、A MERGE statement can be used to update existing rows in a table.

第4题：

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

第5题：

You executed this command to create a temporary table：  SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddate DATE， class CHAR（20））ON COMMIT PRESERVE ROWS；  Which statement is true about the rows inserted into the REPORT_WORK_AREA table during atransaction （）

• A、The rows stay in the table only until session termination.
• B、The rows stay in the table only until the next transaction starts on the table.
• C、The rows are visible to all current sessions after the transaction is committed.
• D、The rows stay available for subsequent sessions after the transaction is committed

第6题：

You created the DEPT table by using the following command：   CREATE TABLE scott.dept   （deptno NUMBER（3），   dname VARCHAR2（15），   loc VARCHAR2（15） ）   STORAGE （INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）

• A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.
• B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.
• C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.
• D、 You cannot shrink the SCOTT.EMP table.

第7题：

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.

第8题：

You executed this command to create a temporary table： SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddateDATE， class CHAR（20）） ON COMMIT PRESERVE ROWS； Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction（）

• A、The rows stay in the table only until session termination.
• B、The rows stay in the table only until the next transaction starts on the table.
• C、The rows are visible to all current sessions after the transaction is committed.
• D、The rows stay available for subsequent sessions after the transaction is committed

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

Which two statements about subqueries are true? （）

• A、A subquery should retrieve only one row.
• B、A subquery can retrieve zero or more rows.
• C、A subquery can be used only in SQL query statements.
• D、Subqueries CANNOT be nested by more than two levels.
• E、A subquery CANNOT be used in an SQL query statement that uses group functions.
• F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

第15题：

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?（）

• A、The DESCRIBE DEPT statement displays the structure of the DEPT table.
• B、The ROLLBACK statement frees the storage space occupied 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.

第16题：

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.

第17题：

Which two statements about subqueries are true?（）

• A、A single row subquery can retrieve data from only one table.
• B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
• C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
• D、A single row subquery can retrieve data from more than one table.
• E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
• F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

第18题：

Which two statements about subqueries are true? （）

• A、A single row subquery can retrieve data from only one table.
• B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
• C、A SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.
• D、A single row subquery can retrieve data from more than one table.
• E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
• F、A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.

第19题：

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.

第20题：

第21题：

第22题：

第23题：

第24题：