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
第1题:
Which two statements about subqueries are true? ()
第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题:
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement?()
第4题:
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?()
第5题:
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?()
第6题:
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.
第7题:
A single row subquery can retrieve data from only one table.
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.
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.
A single row subquery can retrieve data from more than one table.
A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.
第8题:
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT; statement.
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE; statement.
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE; statement.
You cannot shrink the SCOTT.EMP table.
第9题:
A single row subquery can retrieve data from only one table.
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.
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.
A single row subquery can retrieve data from more than one table.
A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
第10题:
A subquery should retrieve only one row.
A subquery can retrieve zero or more rows.
A subquery can be used only in SQL query statements.
Subqueries CANNOT be nested by more than two levels.
A subquery CANNOT be used in an SQL query statement that uses group functions.
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.
第11题:
It contains only the plan for the SQL statement executed by the user.
It contains the SQL text executed by the user and the bind variables used with it.
It contains the plan and statistics associated with the SQL statement executed by the user.
It contains the plan for the SQL statement executed by the user and the bind variables used with it
第12题:
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.
第13题:
Which three are true?()
第14题:
Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? ()
第15题:
Which two statements about subqueries are true?()
第16题:
Which two statements about subqueries are true? ()
第17题:
CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (13)); ROLLBACK; DESCRIBE DEPT What is true about the set? ()
第18题:
Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
A resumable statement is suspended only if an out of space error occurs.
When a resumable statement is suspended, the transaction that contains the statement is also suspended.
A resumable statement can only be suspended and resumed once during the execution of the statement.
You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session
第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 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.
第21题:
A MERGE statement is used to merge the data of one table with data from another.
A MERGE statement replaces the data of one table with that of another.
A MERGE statement can be used to insert new rows into a table.
A MERGE statement can be used to update existing rows in a table.
第22题:
Bind Variable Peeking
SQL Plan Baselines
Adaptive Cursor Sharing
Bind variable used in a SQL statement
Literals in a SQL statement
第23题:
It contains only the plan for the SQL statement executed by the user.
It contains the SQL text executed by the user and the bind variables used with it.
It contains the plan and statistics associated with the SQL statement executed by the user.
It contains the plan for the SQL statement executed by the user and the bind variables used with it.